ADO to ADO.NET - Retrieve the AutoIncrement or Identity value of a column

[Loren Dummer]

Hello All,

I am converting a VB6 application to .Net and having problems converting the
following code.


VB6 Code:

Dim lDataID as Long

sSql = "SELECT * " & _
"FROM MSMQData"

Set adoRs = New ADODB.Recordset
With adoRs

.Open sSql, adoCn, adOpenKeyset, adLockOptimistic, adCmdText

.AddNew

!XMLData = objDOM.xml

.Update

lDataID = !DataID

.Close
End With
Set adoRs = Nothing


I can get this to work using a SQLCommand object and pass back the
@@Identity value in an Output parameter with the stored procedure.

I cannot figure out what I should be using to convert this correctly.

Any help is appreciated.

 

[William Ryan eMVP]

Check out Bill Vaughn's Article "Retreiving the Gozoutas" at
www.betav.com ->Articles -> MSDN, he's got a really good walk through.

--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/
http://www.devbuzz.com/content/zinc_personal_media_center_pg1.asp