当我更新一条记录时为什么所有记录都在更新为什么？ [英] Why All Of The Records Are Updating When I Updating One Record Why?

问题描述

我的代码是



protected void btnupdate_Click（object sender，EventArgs e）

{

try

{

SqlConnection con = new SqlConnection（cs）;

SqlCommand cmd = new SqlCommand（更新Employee1设置EmployeeName = @ PEmployeeId，EmployeeDesignation = @ PEmployeeDesignation，EmployeeDOJ = @ PEmployeeDOJ，EmployeeSalary = @ PEmployeeSalary，EMployeeDepartmentno = @ PEmployeeDepartmentno，con）;

cmd.CommandType = CommandType.Text;

cmd.Parameters .AddWithValue（@ PEmployeeId，TextBox1.Text）;

cmd.Parameters.AddWithValue（@ PEmployeeName，TextBox2.Text）;

cmd.Parameters.AddWithValue （@PEmployeeDesignation，TextBox3.Text）;

cmd.Parameters.AddWithValue（@ PEmployeeDOJ，TextBox4.Text）;

cmd.Parameters.AddWithValue（ @PEmployeeSalary，TextBox5.Text）;

cmd.P arameters.AddWithValue（@ PEmployeeDepartmentno，TextBox6.Text）;

con.Open（）;

int i = cmd.ExecuteNonQuery（）;

con.Close（）;

Console.WriteLine（数据更新）;

}

catch（Exception ex）< br $>
{



lblmessage.Text = ex.Message;

}

当我从表中更新一个记录时，我表中的记录都在更新

my code is

protected void btnupdate_Click(object sender, EventArgs e)
{
try
{
SqlConnection con = new SqlConnection(cs);
SqlCommand cmd = new SqlCommand("update Employee1 set EmployeeName=@PEmployeeId,EmployeeDesignation=@PEmployeeDesignation,EmployeeDOJ=@PEmployeeDOJ,EmployeeSalary=@PEmployeeSalary,EMployeeDepartmentno=@PEmployeeDepartmentno", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@PEmployeeId", TextBox1.Text);
cmd.Parameters.AddWithValue("@PEmployeeName", TextBox2.Text);
cmd.Parameters.AddWithValue("@PEmployeeDesignation", TextBox3.Text);
cmd.Parameters.AddWithValue("@PEmployeeDOJ", TextBox4.Text);
cmd.Parameters.AddWithValue("@PEmployeeSalary", TextBox5.Text);
cmd.Parameters.AddWithValue("@PEmployeeDepartmentno", TextBox6.Text);
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
Console.WriteLine("Data Updated");
}
catch (Exception ex)
{

lblmessage.Text = ex.Message;
}
The Records which are in my table all of them are updating when i updating one record form my table

推荐答案

你没有 WHERE 在你的sql命令中



http：// www .w3schools.com / sql / sql_where.asp [ ^ ]

You have no WHERE in your sql command

http://www.w3schools.com/sql/sql_where.asp[^]

因为您忘记添加条件。添加 WHERE 子句来更新特定记录。

Because you forgot to add criteria. Add WHERE clause to update particular record.

你好，



您没有在查询中提供任何 Where 条件。因此所有行都会更新。



修改后的查询将是这样的

Hello ,

you have not given any Where condition in your query . hence all rows are updated .

modified query will be like this

update Employee1 set EmployeeName=@PEmployeeId,EmployeeDesignation=@PEmployeeDesignation,EmployeeDOJ=@PEmployeeDOJ,EmployeeSalary=@PEmployeeSalary,EMployeeDepartmentno=@PEmployeeDepartmentno where EmployeeId=@PEmployeeId

谢谢

animesh

thanks
animesh

这篇关于当我更新一条记录时为什么所有记录都在更新为什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！