.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,