Insert data to database and get the primarykey

[chathura86]

public void insertData(String sql)
{
    if(conn != null)
    {
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = conn ; //setting the connection to sql command
        cmd.CommandText = "INSERT INTO Bla bla bla"; //setting the sql
        conn.Open() //open database connection
        cmdUpdateLog.ExecuteNonQuery(); //execute the sql command
 
        cmd.CommandText = "SELECT @@IDENTITY";
        string pri_key = cmd.ExecuteScalar().ToString()
        conn.Close() //close db connection
    }
}
 

i'm using this code to insert data to database and get the primarykey

is their any way to combind the two queries and execute as a single query

because i heard that

INSERT INTO Bla bla bla;SELECT @@IDENTITY";

will work in jdbc

will it work on .net

if so how?

thank you

Chathura Bamunusingh

[r035198x]

Insert and select are two different statements. Insert can potentially insert more than one value and so the best information that it can return is the number of rows updated. You could implement it yourself in your own Data Access Class but it would ultimately use two statements.

[chathura86]

Thanks for making it clear

I had doubt about that

So seems that the way i implemented it is the only way

Thanks again for the help

Chathura Bamunusinghe