直接将cmd定义成Adapter的实例:
SqlDataAdapter cmd = new SqlDataAdapter("sp_update_spTest",cn);
把
//dataAdapter.UpdateCommand = cmd;
注释掉
试试看!!
SqlDataAdapter cmd = new SqlDataAdapter("sp_update_spTest",cn);
把
//dataAdapter.UpdateCommand = cmd;
注释掉
试试看!!
cmd.Update(dataSet,"spTest");
dataSet.AcceptChanges();
before you update the database, otherwise, the database will think you have nothing to update
cmd.CommandType = CommandType.StoredProcedure ;
cmd.Parameters.Add(new SqlParameter("@id",SqlDbType.Int));
cmd.Parameters.Add(new SqlParameter("@no",SqlDbType.Char,10));
cmd.ExecuteNonQuery()
cmd.CommandType = CommandType.StoredProcedure ;
cmd.Parameters.Add(new SqlParameter("@id",SqlDbType.Int));
cmd.Parameters.Add(new SqlParameter("@no",SqlDbType.Char,10));cmd.CommandText = 存储过程名;
string myConnectionString = "data source=cxj;initial catalog=master;user id=sa;password=";
SqlConnection myConnection = new SqlConnection(myConnectionString);
cmd.Connection = myConnection;
myConnection.Open();
cmd.ExecuteNonQuery();
dataSet.AcceptChanges();
myConnection.Close();
cmd.Parameters["@id"].value=?
cmd.Parameters.Add(new SqlParameter("@no",SqlDbType.Char,10));
cmd.Parameters["@no"].value=?如果你的数据是从dataSet.Table("spTest")来的那么
new SqlParameter("@id",SqlDbType.Int,
4, "id")
格式来写
注意名称要对应
用COMMAND。EXECUTE只能存一条记录
ms-help://MS.NETFrameworkSDK.CHS/cpguidenf/html/cpconupdatingdatabasewithdataadapterdataset.htm
AcceptChange把放到最后。
结贴
谢谢大家
new SqlParameter("@id",SqlDbType.Int)改为
new SqlParameter("@id",SqlDbType.Int,4, "id")