c# 如何将修改后的登录密码更新到数据库中?
private void okBtn_Click(object sender, EventArgs e){
string userName = string.Empty, password = string.Empty;
SqlCommand sqlcomm = new SqlCommand("select * from Worker where WorkerLogin='" + oldPassword.Text + "'", da.link());//
SqlDataReader reader = sqlcomm.ExecuteReader();
if (reader.Read())
{
userName = reader.GetValue(2).ToString();
password = reader.GetValue(3).ToString();
}
if (oldPassword.Text != password)
{
MessageBox.Show("密码不正确!", "提示!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
if (newOnePassword.Text != newOnePassword.Text)
{
MessageBox.Show("确认密码与新密码不一致!", "提示!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
SqlDataAdapter sqlda = new SqlDataAdapter("select * form Worker", da.link());
SqlCommand sqlcomm1 = new SqlCommand("update Worker set" +
"WorkPassword=@WorkPassword where WorkPassword='" +
newPassword.Text+"'",da.link());
sqlcomm1.Parameters.AddWithValue("@WorkPassword", newPassword.Text);
sqlda.UpdateCommand.ExecuteNonQuery();
MessageBox.Show("修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.Close();
}
}
}
以上是将修改后的密码保存到Worker中。为什么程序运行到“sqlda.UpdateCommand.ExecuteNonQuery();”时就提示有如下错误啊“未将对象引用设置到对象的实例。”。为什么啊?如何改啊? --------------------编程问答-------------------- sqlda为null。
补充:.NET技术 , C#