更新语句更改错误的记录
本文关键字:记录 错误 语句 更新 | 更新日期: 2024-09-24 13:00:04
-
我有一个包含4列的数据网格视图:
UserID, FirstName, LastName, Email
-
当我双击一行时,另一个表单会弹出4个文本框,其中包含该行的值,每个文本框都有单元格值
-
当我单击提交按钮时,该行将使用文本框值进行更新。
-
我所使用的
....where UserID = @UserID
。但是如果列单元格我正在更改是否修改UserId
、错误的行或没有行。
问题
如何编辑ANY列值的行,并在没有增量列的情况下更改右侧行?
代码
public partial class EditUser : Form
{
public DataGridViewRow dgvRow;
public EditUser()
{
InitializeComponent();
}
private void EditUser_Load(object sender, EventArgs e)
{
lbl5.Text = dgvRow.Cells[0].Value.ToString();
txtUserID.Text = dgvRow.Cells[0].Value.ToString();
txtFName.Text = dgvRow.Cells[1].Value.ToString();
txtLName.Text = dgvRow.Cells[2].Value.ToString();
txtEmail.Text = dgvRow.Cells[3].Value.ToString();
label1.Visible = false;
txtUserID.Visible = false;
}
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
this.Visible = false;
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection sc = new SqlConnection();
SqlCommand com = new SqlCommand();
sc.ConnectionString = ("");
sc.Open();
com.Connection = sc;
com.CommandText = ("update JoshUserTable SET UserID = @UserID, FirstName=@FirstName,LastName=@LastName,Email=@Email where UserID = @UserID");
com.Parameters.AddWithValue("@UserID", txtUserID.Text);
com.Parameters.AddWithValue("@FirstName", txtFName.Text);
com.Parameters.AddWithValue("@LastName", txtLName.Text);
com.Parameters.AddWithValue("@Email", txtEmail.Text);
com.ExecuteNonQuery();
sc.Close();
}
private void linkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
label1.Visible = true;
txtUserID.Visible = true;
SqlConnection sc = new SqlConnection();
SqlCommand con = new SqlCommand();
sc.ConnectionString = ("");
sc.Open();
con.Connection = sc;
con.CommandText = ("update JoshUserTable SET UserID = @UserID, FirstName=@FirstName,LastName=@LastName,Email=@Email where FirstName = @FirstName");
con.Parameters.AddWithValue("@UserID", txtUserID.Text);
con.Parameters.AddWithValue("@FirstName", txtFName.Text);
con.Parameters.AddWithValue("@LastName", txtLName.Text);
con.Parameters.AddWithValue("@Email", txtEmail.Text);
con.ExecuteNonQuery();
sc.Close();
}
}
我认为您遇到了更大的问题。如果一个记录同时被另一个用户更改了怎么办。您将在并发问题中运行。这就是为什么CommandBuilder的自动生成代码总是检查旧值的原因。
对于您当前的代码,我添加了对原始userID的检查。
private void button1_Click(object sender, EventArgs e)
{
SqlConnection sc = new SqlConnection();
SqlCommand com = new SqlCommand();
sc.ConnectionString = ("My Connection String");
sc.Open();
com.Connection = sc;
/// check for original value in whereClause
com.CommandText = ("update JoshUserTable SET UserID = @NEW_UserID,
FirstName=@FirstName,LastName=@LastName,Email=@Email
where UserID = @ORIGINAL_UserID");
com.Parameters.AddWithValue("@NEW_UserID", txtUserID.Text);
com.Parameters.AddWithValue("@ORIGINAL_UserID", INSERT_ORIGINAL_USERID);
com.Parameters.AddWithValue("@FirstName", txtFName.Text);
com.Parameters.AddWithValue("@LastName", txtLName.Text);
com.Parameters.AddWithValue("@Email", txtEmail.Text);
com.ExecuteNonQuery();
sc.Close();
}
并发问题仍未解决。。。。