CodeVerge.Net Beta


   Explore    Item Entry    Members      Register  Login  
NEWSGROUP
.NET
Algorithms-Data Structures
Asp.Net
C Plus Plus
CSharp
Database
HTML
Javascript
Linq
Other
Regular Expressions
VB.Net
XML

Free Download:




Zone: > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.microsoft_application_blocks Tags:
Item Type: NewsGroup Date Entered: 10/20/2003 12:44:07 PM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 2 Views: 29 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
3 Items, 1 Pages 1 |< << Go >> >|
AZeitler
Asp.Net User
How to get ID of currently inserted record10/20/2003 12:44:07 PM

0/0

hi,

how can i obtain the id of the currently inserted record (using a View/Stored Procedure) in a access database using DAAB?

regards

Alex
regards

Alex
Stephen Vakil
Asp.Net User
Re: How to get ID of currently inserted record10/21/2003 1:44:15 PM

0/0

What version of access? If it's 2000 or higher you can select @@IDENTITY
AZeitler
Asp.Net User
Re: How to get ID of currently inserted record10/21/2003 1:46:57 PM

0/0

access 2000. I did it now this way: i inserted a field GUID, where i save a GUID generated from C#. After the insert, i make a select * from mytable where guid = GUID.
regards

Alex
3 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Spidering Hacks: 100 Industrial-Strength Tips and Tools Authors: Kevin Hemenway, Tara Calishain, Pages: 402, Published: 2004
Active, Real-time, and Temporal Database Systems: Second International Workshop, ARTDB-97, Como, Italy, September 8-9, 1997 : Proceedings Authors: Sten F. Andler, Jörgen Hansson, Pages: 244, Published: 1997
Advances in Database Technology--EDBT 2002: 8th International Conference on Extending Database Technology, Prague, Czech Republic, March 25-27, 2002 : Proceedings Authors: Christian S. Jensen, K. G. Jeffery, J. Pokorny, S. Saltenis, Elisa Bertino, K. Boehm, Matthias Jarke, Pages: 776, Published: 2002
Computational Logic: Logic Programming and Beyond : Essays in Honour of Robert A. Kowalski Authors: Antonis C. Kakas, Fariba Sadri, Robert Kowalski, Pages: 678, Published: 2002
The Logic Programming Paradigm: A 25-year Perspective Authors: Krzysztof R. Apt, Victor W. Marek, Mirek Truszczynski, David S. Warren, Pages: 456, Published: 1999
Microsoft Office Access 2003: Professional Results Authors: Noel Jerke, Pages: 400, Published: 2003
MySQL Cookbook: Solutions and Examples for MySQL Database Developers. Authors: Paul DuBois, Pages: 992, Published: 2003
Professional HaXe and Neko Authors: Franco Ponticelli, Lee McColl-Sylvester, Pages: 619, Published: 2008
Microsoft Office XP 8-in-1: Office XP 8 in 1 Authors: Joe Habraken, Pages: 921, Published: 2001
Biometrics Authors: John D. Woodward, Nicholas M. Orlans, Peter T. Higgins, Pages: 432, Published: 2003

Web:
How to get ID of currently inserted record - ASP.NET Forums How to get ID of currently inserted record. Last post 10-21-2003 10:08 AM by AZeitler. 2 replies. Sort Posts: ...
how to retrieve the id of the currently inserted record with C# ... how to retrieve the id of the currently inserted record with C# ... the id of the inserted record that was generated by SQL but i get -1 or ...
Get the ID number of a record that just entered [Archive ... I call a stored Procedure to that gets the current number from the .... If you want to KNOW the id of the newly inserted record use the ...
Christian Cantrell: Safely Selecting the Last Inserted ID I'm using the MySQL function LAST_INSERT_ID() to get the last inserted ID, however the ID's scope is the current connection, so if I use two CFQUERY tags ...
MySQL Performance: MySQL => How to get last inserted record? Re: How to get last inserted record? [message #2750 is a reply to message ... http://dev.mysql.com/doc/refman/5.0/en/getting-unique-id.htm l ...
PHP: mysql_insert_id - Manual SELECT to insert multiple rows at once, you get the autonumber ID of the *first* row added by the INSERT. e.g. if there are 4 records in table 'init' that ...
PHP-MySQL: Returning ID when new record is made? - PHP will user1 get the id of the data he *just* inserted, or will he get user2's id? ... last record inserted by the current instance?[/color] ...
Have GridView Highlight Last Inserted Record in ASP.NET 2.0 ... Dec 7, 2006 ... NewId is actually a return parameter, so we can get that back in the .... In my next page I would need to know the id of the row inserted. ...
Obtaining an Inserted record's ID. I'm using the below type of code to Insert a records into a Sql table. I need to get the value of the the auto-generated Primary key (id) of the record ...
ColdFusion 8: Getting the autonumber insert ID : Raymond Camden's ... Have you ever inserted a record into a table that used an autonumber primary key ? I bet you wanted a nice way to get the value of that ID? ...

Videos:
A Googly MySQL Cluster Talk Google TechTalks April 28, 2006 Stewart Smith Stewart Smith works for MySQL AB as a software engineer working on MySQL Cluster. He is an active memb...
Developing JavaScript with Chickenfoot Google TechTalks July 25, 2006 Rob Miller Michael Bolin ABSTRACT Chickenfoot is a Firefox extension that embeds a JavaScript programming environmen...
Long Beach City Council Meeting Long Beach City Council Meeting
Long Beach City Council Meeting Long Beach City Council Meeting




Search This Site:










copyright bug in 3.2 maybe??

asp.net: automatic authentication on active directory while logged on domain?

2 modules in 1 line

.net 2.0, password reminder gets me "an unhandled error has occurred."

viewstate

unable to load past project, visual studio 2005

enhancement to sqlcommandgen. for large amounts of data

custom calender control

stock quote module

to solicit about export data from sql to file .doc?

is it worth it

php photopost

where to do authentication?

applying themes to content pages

themes vs stylesheet speed

migrating web site project to web application project

deploying live issue

what to do to activate a class at a specified time on daily basis.

des key & iv

hosting by discountasp.net

dnn 3.0.5 beta. install issue- invalid ojbect name 'tabs'

need help...urgent!

how do i disabled back button in ie for master.page, those who have content pages

css problem in masterpages

code line number? how to view??

dotnet menu control on a master page

thank you, & deploying to a dnn (virtual) sub directory

windowsidentity confusion

module to create rss feeds

how to link a dynamic created control to event module

 
All Times Are GMT