yes, Rows = table.Select("select @@identity"); in Sql Server INSERT INTO jobs (job_desc,min_lvl,max_lvl) VALUES ('Accountant',12,125) SELECT @@IDENTITY AS 'Identity' @@IDENTITY is SQL system variable datatable have very SQL method , So you think dataset like a small SQl server
Agree ...