C# dataAdapt,sqlcommand两种方法更新数据源问题
本人小白~下面的代码用了dataAdapt,sqlcommand两种方法更新数据源都不成功dataset中的改了~但是未返回数据库
用dataAdapt+dataset
//login.pass=“stu01”
SqlConnection conn = new SqlConnection(connString);
string sqlstr = "select * from student where sid='stu01'";
DataSet ds = new DataSet();
//string sqlstr = "update student set sname='" + Texsname.Text + "' " + "where sid='" + Login.pass + "'";
SqlDataAdapter sda = new SqlDataAdapter(sqlstr,conn);
SqlCommandBuilder combulid = new SqlCommandBuilder(sda);
sda.Fill(ds);
DataRow dr = ds.Tables[0].Rows[0];
//更新部分
dr.BeginEdit();
dr["sname"] = snameTextBox.Text;
dr["易做图"] = 易做图TextBox.Text;
dr["sclass"] = sclassTextBox.Text;
dr["saddress"] = saddressTextBox.Text;
dr["sbirth"] = sbirthTextBox.Text;
dr["sdepartment"] = sdepartmentTextBox.Text;
dr.EndEdit();
//ds.Tables[0].Rows[0]["sname"] = "apple2";
sda.UpdateCommand = combulid.GetUpdateCommand();
sda.Update(ds);
用sqlcommand修改的
string sqlstr = string.Format("update student set saddress='{0}' where sid='{1}'", "11111111", "stu01");
SqlCommand command = new SqlCommand(sqlstr, conn);
conn.Open();
ExecuteSql(sqlstr);
conn.Close();
snameTextBox.ReadOnly = true;
private void ExecuteSql(string sqlstr) //SQL语句执行
{
SqlConnection conn = new SqlConnection(connString);
SqlCommand command = new SqlCommand(sqlstr, conn);
conn.Open();
try
{
command.ExecuteNonQuery();
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
conn.Close();
}
执行都成功但是没有修改数据源
补充:.NET技术 , C#