你可以随便插入一条数据在带有自增字段的表中
insert into S_Student(name)values(@name)
然后执行
select @@IDENTITY
会看到你刚插入那一行的ID
那么问题怎么获取你刚插入的那条数据的ID呢
string sql1 = @"insert into S_Student(name)values(@name)
select @identityV=@@IDENTITY";
SqlParameter[] parameter = new SqlParameter[]{
new SqlParameter("@name",SqlDbType.NVarChar,50),
new SqlParameter("@identityV", SqlDbType.Int)
};
parameter[0].Value = "xiaoming";
parameters[1].Direction = ParameterDirection.Output; //返回值identityid
int yesNo = DbHelperSQL.ExecuteSql(sql1, parameter);
int identityV =Convert.ToInt32(parameters[1].Value); //identityV就是返回来的那个id