SqlConnection con = new .............SqlComand com = new SqlCommand("insert into .........;select @@identity",con);con.open();int id = (int)com.ExecuteScalar();con.close();
insert into tb(col1,col2...) values(col1,col2...) select @@identity@@identity--->自動獲得最新插入的id的值
select @@identity@@identity--->自動獲得最新插入的id的值