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(@custnametxtName.Text); command.Parameters.AddWithValue(@custIdConvert.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