执行一条插入语句,再取最后一个自增值;
- public int t1()
- {
- string sql = "insert into test(b) values('e');SELECT @@IDENTITY AS 'Identity' ";
- object obj=ExecuteScalar(sql, null);
- return int.Parse(obj.ToString());
- }
执行一条插入语句,并将整个表获取到一个datatable中
- public DataTable t2()
- {
- string sql = "insert into test(b) values('e');select * from test order by a desc ";
- DataTable dt = ExecuteDataSet(sql, null).Tables[0];
- return dt;
- }