Try to send SET NOCOUNT ON INSERT .... SELECT scope_identity()

BOb


>.NET datatable doesn't return identity.
>
>ds=sqlData.runsql(strSql,"Dealer")
>dt=ds.tables(0)
>dim idx as integer = dt.rows(0)(0)
>return idx
>
>idx is dbnull always with .NET
>
>If I run the query in Query Analyzer, I get the proper id# for my auto-increment primary key id field right after running an INSERT command.
>
>Does .NET dataset not support the @@identity?
>
>How would I get the last created id?
>
>Thanks,