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 31 online users.

    Latest tutorialsIntroduction to Dependency Injection Using StructureMap
    SEO For ASP.NET Web Site
    Using ASP.NET 3.5's ListView and DataPager Controls: The Ultimate DataPager Interface
    Using jQuery To Hijack ASP.NET MVC Form Posts
    Accessing and Updating Data in ASP.NET: Filtering Data Using a CheckBoxList
    Predictive Fetch with jQuery and the ASP.NET Ajax Library
    Building ASP.NET Web Forms to Use a MySQL Database
    A Guide to Upgrading Your XP Machine for Optimum Performance with Windows 7
    Retrieving Data from Microsoft SQL Server 2008 Using ASP.NET 3.5
    Creating an ASP.NET Dynamic Web Page Using MS SQL Server 2008 Database (GridView Display)
    Inserting Data into a Microsoft SQL 2008 Database in ASP.NET 3.5
    Using C#, ASP.NET, and ADO.NET To Develop A Multi-Tier App From Start To Finish
    URL Routing in ASP.NET 4.0
    Integrating Twitter Into An ASP.NET Website
    Creating Multiple Choice Exam Application Using ASP.NET MVC Framework
    ASP.NET Resources, Reviews

    ASP Resources, Reviews

    PHP, ASP, .NET, JSP Resources, Reviews

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