Identity

[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

 

[Mr. Arnold]

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)

The short answer is no.

But this may work for you.

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

 

[Cor Ligthert [MVP]]

Mex

Why not, however proces the select with the executescalar

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executescalar.aspx

Cor