Update to MSSQL database failed.

Question

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

Abhay Shanker · 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 Abella · Answer

Thanks a lot Madam, It works!

Biswa Pujarini Mohapatra · Answer

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