Loading

Update to MSSQL database failed.

Update to MSSQL database failed.

Cris Abella

12y1.7kVisual Basic .NET

Hello everybody please consider me as a newbie in C# and I am much willing to learn this language. This is first time I've join the community.

why update to mssql database failed.

mssql table

custId = int(autoincrement)

custname = varchar(30)

SqlConnection con = new SqlConnection("Data Source=CRIS-PC\\SQLEXPRESS;Integrated Security=True;Initial Catalog = POS");

SqlCommand command = new SqlCommand("Update customers set custname = @custname where custid = @custId)", con);

command.Parameters.AddWithValue("@custname",txtName.Text);

command.Parameters.AddWithValue("@custId",Convert.ToInt32(txtCustId.Text));

thank in advance.

Cris

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhay Shanker12y ago
Accepted answer
Try as below

string conn = "";
conn = ConfigurationManager.ConnectionStrings["Conn"].ToString();
SqlConnection objsqlconn = new SqlConnection(conn);
objsqlconn.Open();
SqlCommand objcmd = new SqlCommand("Update Employee set Employee_Name='" + txtName.Text + "',Employee_Address='" + txtAddress.Text + "',Employee_Salary='" + txtSal.Text + "' where Employee_Id='" + txtEmpID.Value + "'", objsqlconn);

objcmd.ExecuteNonQuery();
Cris Abella12y ago
Thanks a lot Madam, It works!
Biswa Pujarini Mohapatra12y ago
I think you have not open the connection also to update the database you need to call ExecuteNonQuery(). here is your code

SqlConnection con = new SqlConnection("Data Source=CRIS-PC\\SQLEXPRESS;Integrated Security=True;Initial Catalog = POS");
con.Open();
SqlCommand command = new SqlCommand("Update customers set custname = @custname where custid = @custId)", con);
command.Parameters.AddWithValue("@custname", txtName.Text);
command.Parameters.AddWithValue("@custId", Convert.ToInt32(txtCustId.Text));
command.ExecuteNonQuery();
con.Close();

hope it helps you