Hi

When I do an insert using the update(datatable) method I can get the new
identity but when I do an insert directly with the Insert method I can only
get the record count becuase the InsertCommand uses ExecuteNonQuery.

Can I get the Insert method to return the identity?

the sproc looks like

error when adding column to datatable: There is no row at position
Readonly Datatable
Query Analizer vs ADONET
Data Paging: How To?
Simple multiple table design question