试过很正确,表结构如下:
函数如下:两个sql 语句空格连起来就可以了。
public int InsertSubjectreturn(string Sub_Name, string Sub_Note, string insertname)
{
string strsql = "insert into KSXT_subject(Sub_Name,Sub_Note,insertname) values ('" + Sub_Name + "','" + Sub_Note + "','" + insertname + "') select @@IDENTITY as insertid ";
DBAccess mydb = new DBAccess();
return(Convert.ToInt32( mydb.ExecuteScalar(strsql)));
}
调用如下:
Subject mysub = new Subject();
int a= mysub.InsertSubjectreturn ("计算机文化基础", "2008级通修", "郝永生");