你这个问题很容易实现。
用select @@identity就可以了。@@identity是SQL server专门用来完成这个工作的东东。
例子如下:
string insertStr = "INSERT INTO Table1()values();select @@identity";
SqlCommnad cm = new sqlcommand(insertStr,sqlconnection);
sqlconnection.open();
SqlDataReader reader = cm.ExecuteReader();
while (reader.Read())
{
object obValue = reader.GetValue(0);
ID = Convert.ToInt32(obValue.ToString());
}
id就是你要的结果
用select @@identity就可以了。@@identity是SQL server专门用来完成这个工作的东东。
例子如下:
string insertStr = "INSERT INTO Table1()values();select @@identity";
SqlCommnad cm = new sqlcommand(insertStr,sqlconnection);
sqlconnection.open();
SqlDataReader reader = cm.ExecuteReader();
while (reader.Read())
{
object obValue = reader.GetValue(0);
ID = Convert.ToInt32(obValue.ToString());
}
id就是你要的结果
...
int id=Convert.ToInt32(ExecuteScale(mySql));
{
try
{
SqlCommand cmd=new SqlCommand(Sql,GetConn());
return cmd.ExecuteScalar();
}
catch(Exception ee)
{
throw ee;
}
}///
string mySql="insert into p_mbjd(mbbh,jdlx,ch,sd)values('"+txtMbbh.Text.Trim()+"','LinkPoint',"+iCH+","+iSD+");"+"select @@identity";
int id=Convert.ToInt32(UsualProcess.ExeScalar(mySql));