呵呵,如果你的ID是自增的就可以这样
insert into tbltest(name,sex,age) values ("test","man","24"); select @@IDENTITY as id from tbltest
然后用ExecuteScalar()就OK了~,,很简单的,你可以试一下~
database类
public object ExecuteScalar(string strSql)
{
Open();
SqlCommand cmd = new SqlCommand(strSql,conn);
object mm=cmd.ExecuteScalar();
return mm;
}
cmdText = "insert into city_shop (shopname)values ("+google+"); shopid自动增长
调用
DataBase db = new DataBase();
int shopid = Convert.ToInt32(db.ExecuteScalar(cmdText).ToString());