Popular Articles | Latest Articles | Categories | RSS Feeds
Web Development
Web Design
Programming
Security
Databases
Web Hosting

How to Get Identity of New Record

Published on 2/17/2006 by Site Editor
More articles in ASP



 Vote this tutorial:

 

Sometimes you need the learn new record number while your are adding a new record. Following example adds a new records to a table and gets the the autonumber or identity of that records.

<%
 Set Con = CreateObject("ADODB.Connection")
 Con.Open strCon
 Con.execute ("INSERT INTO users (email, pword) VALUES ('"& email &"', '"& pword &"')")
 set rs = Con.execute"SELECT @@IDENTITY from users")
 response.write "Last Record ID is : " & rs(0)
%>

 

Comments:
no comments submitted


Only members can write comments.Please, login / register to write comment.

Latest Posts

    Active News Manager - news management system




    Welcome to Dotnetindex.com:Login  |  Register
    Free software:
    Giga RSS Reader
    IkonAdman
    QMailing list     		Active News
    Download Manager (PRO)
    Download Manager (Lite)

    Search Dotnetindex.com:


    Who's online

    • There 14 online users.

    Latest tutorialsAutocomplete Filter from the Old Futures Project Working in Dynamic Data 4
    Developing a Facebook Connect Application Using ASP.NET
    Conditional Row Highlighting in Dynamic Data
    UserControl as a DLL Made Easy
    Using GroupTemplate in ASP.NET ListView Control (Tiled Display)
    Creating Master-Detail GridView Using jQuery
    ASP.NET MVC 2.0 and AJAX Part 1
    Sorting Tabular Data in ASP.NET MVC
    Asynchronous Form in ASP.NET MVC 2
    Populating ASP.NET TreeView Control Recursively
    A look at SAP Crystal Reports for Visual Studio 2010
    Reporting in Threads
    Regular Expressions Make Pattern Matching and Data Extraction Easier
    Perform Database Administration Operations with SQL Server Management Objects
    SQL Server Compact 3.5 Beta 2 available for download
    ASP.NET Resources, Reviews

    ASP Resources, Reviews

    PHP, ASP, .NET, JSP Resources, Reviews

    Hotscripts.com Free Photoshop, Flash and 3DS MAX tutorials