How to get Id of inserted row from codeBehind?..

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

Hey everyone,

I am inserting into a db table from codebehind.How can i get the ID of this last raw inserted from codebehind?...

Thanks
Amit

Posted 29-Oct-10 0:34am

AmitChoudhary10

Add a Solution

Comments

Rajesh Anuhya 29-Oct-10 6:37am

Your Question is not clear for me.., if your inserting the ID field to a Table, you should know the ID value before inserting.....

Steven J Jowett 29-Oct-10 6:39am

What DB are you using e.g. Access, SQL Server? Is the Id field sequencial? If so SELECT MAX(Id) FROM Table but has room for error.

AmitChoudhary10 29-Oct-10 6:40am

Id in db table is self generated by identity-specification.And i am inserting into this table from code behind.....

AmitChoudhary10 29-Oct-10 6:41am

SQL server 2005

3 solutions

Solution 3

It could be easier if you use Data Access Application Block.

http://www.codeproject.com/KB/architecture/MS-EntLib-DataAccess1.aspx?msg=3168720 [^]

Posted 29-Oct-10 0:57am

TOMATEPODRE

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RECSEN · Accepted Answer · 2010-10-29T00:41:00

Solution 1

The table will have two column called ID and Name
ID is auto generator
then use the below command for getting the last inserted record id

insert into tables('Arun');
select scope_identity();

Posted 29-Oct-10 0:41am

RECSEN

Comments

AmitChoudhary10 29-Oct-10 6:42am

thats for sql,i want to get id from codebehind,asp.net...

Steven J Jowett 29-Oct-10 6:47am

The answer is valid. In your codebehind you will need to execute the insert and select statements as 1 transacrion. You could write a stored procedure to accept the values to insert and return the id

AmitChoudhary10 29-Oct-10 6:55am

thanks man,gotcha..

Mohd Wasif · Accepted Answer · 2010-10-29T00:51:00

Solution 2

Sqlcommand cmd=new SqlCommand("insert into dep(date)values ('10/11/2010');select scope_identity();",con);

string serviceID
= cmd.ExecuteScalar();
Label.Text=serviceID ;

Posted 29-Oct-10 0:51am

Mohd Wasif

Updated 29-Oct-10 0:54am

v2