Identity

  • Thread starter Thread starter Mex
  • Start date Start date
M

Mex

Hi

Is possible to get identity value with SCOPE_IDENTITY()
if i use DataSet, SqlDataAdapter and CommandBuilder?


MyDataRow = MyDataSet.Tables(MyBaseTable).NewRow
MyDataSet.Tables(MyBaseTable).Rows.Add(MyDataRow)

Dim cb As New SqlCommandBuilder(MyDataAdapter)

MyDataAdapter.Update(MyDataSet, MyBaseTable)



With best regards;
Mex
 
Mex said:
Hi

Is possible to get identity value with SCOPE_IDENTITY()
if i use DataSet, SqlDataAdapter and CommandBuilder?


MyDataRow = MyDataSet.Tables(MyBaseTable).NewRow
MyDataSet.Tables(MyBaseTable).Rows.Add(MyDataRow)

Dim cb As New SqlCommandBuilder(MyDataAdapter)

MyDataAdapter.Update(MyDataSet, MyBaseTable)
Click to expand...

The short answer is no.

But this may work for you.

http://www.vbforums.com/showthread.php?t=352219
 
Back
Top