Q: fetch identity field

[Guest]

Hello,

Let say myTable has two fields: ID and Name. ID is an identity field and
increased sequentially by 1 each time a record is entered into table.


dr["Name"]=â€MayNameâ€;
dataSet11.Tables[myTable].Rows.Add(dr);
sqlDataAdapter1.Update(dataSet11, myTable);

Now after update, I need to find what the ID value is for the record I just
added. This is a multi-user environment. How should I fetch it?

Thanks,

 

[Guest]

Eliyahu,
Thanks for your help.
I found this:

Dim myconn As New SqlConnection("yourconnectionstring")
strsql = "INSERT INTO TABLENAME (COLUMN) VALUES ('" &somevalue &"'); SELECT
SCOPE_IDENTITY() AS LAST_INSERT "
myconn.Open()
Dim mycommand As New SqlCommand(strsql, myconn)
Dim lastinsert As Integer = CType(mycommand.ExecuteScalar(), Integer)
myconn.Close()

Any idea how I can convert this so that it will work with my
sqlDataAdapter1.Update(dataSet11, myTable); command?

Make a batch and use SCOPE_IDENTITY(). Look up Transact SQL help for
details.

Eliyahu

Hello,

Let say myTable has two fields: ID and Name. ID is an identity field and
increased sequentially by 1 each time a record is entered into table.


dr["Name"]="MayName";
dataSet11.Tables[myTable].Rows.Add(dr);
sqlDataAdapter1.Update(dataSet11, myTable);

Now after update, I need to find what the ID value is for the record I just
added. This is a multi-user environment. How should I fetch it?

Thanks,

 

[Eliyahu Goldin]

Make a batch and use SCOPE_IDENTITY(). Look up Transact SQL help for
details.

Eliyahu

 

[Paul Clement]

¤ Hello,
¤
¤ Let say myTable has two fields: ID and Name. ID is an identity field and
¤ increased sequentially by 1 each time a record is entered into table.
¤
¤
¤ dr["Name"]=”MayName”;
¤ dataSet11.Tables[myTable].Rows.Add(dr);
¤ sqlDataAdapter1.Update(dataSet11, myTable);
¤
¤ Now after update, I need to find what the ID value is for the record I just
¤ added. This is a multi-user environment. How should I fetch it?

See the following:

HOW TO: Retrieve an Identity Value from a Newly Inserted Record from SQL Server by Using Visual
Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;320141


Paul
~~~~
Microsoft MVP (Visual Basic)