获得刚插入数据的自动增长ID(主键)
cmd.CommText="insert into T_User(UserName,PassWord) output inserted.Id values('admin','admin')";
int i=Convert.ToInt32(cmd.ExecuteScalar());
cmd.CommText="insert into T_User(UserName,PassWord) output inserted.Id values('admin','admin')";
转载于:https://www.cnblogs.com/blackHorseplan/p/3887447.html