Example of getting the inserted Record ID

<% @ Import namespace="System. Data"  %>

<% @ Import namespace="System. Data. sqlclient"  %>

< Html >

< Head >

< Title > Example of getting the inserted Record ID </ Title >

< Script Language = "C #" Runat = "Server" >



Void Page_load (Object sender, system. eventargs E)

{

// Database connection string

String connstr = System. configuration. configurationsettings. deleettings [ " Connectionsqlserver " ];

// Create an insert SQL statement and call the @ identity function to return the id value

String insert_query =   " Insert into categories (categoryname, description) values ('it', 'internet '); "

+   " Select @ identity as 'identified '; " ;


// Perform database operations

Sqlcommand mycommand =   New Sqlcommand (insert_query, New Sqlconnection (connstr ));

Mycommand. Connection. open ();

Mylabel. Text = Mycommand. executescalar (). tostring ();

Mycommand. Connection. Close ();

}



</ Script >

</ Head >

< Body >

< Form ID = "Form1" Method = "Post" Runat = "Server" >

< H3 > Example of getting the inserted Record ID </ H3 >

The returned id value is:

< ASP: Label ID = "Mylabel" Runat = "Server" > </ ASP: Label >

</ Form >

</ Body >

</ Html >