babubhai
asked on
In C#: How can I save changes in Database using SQL Command
Hello Experts,
Im trying to update record in C# but Im getting an error: Incorrect syntax near ','
while I dont have any ',' sign in my form input.
Also update query if fine and working in database.
Could you help me please....thanks in advance
my codes are in Update Button which are below:
string strCon = @"Data Source=YOUR-E659457A65\SQL EXPRESS;In itial Catalog=DLCallLog;Integrat ed Security=True";
SqlConnection myConnection = new SqlConnection(strCon);
myConnection.Open();
string strSQL = "Update [CLIENT TABLE] Set [CLIENT NAME] = '" + ClientName + "' Where JobID = " + JobID;
SqlCommand cmd = new SqlCommand(strSQL, myConnection);
cmd.ExecuteReader();
myConnection.Close();
myConnection.Dispose();
MessageBox.Show("Record Update successfully");
this.Close();
Im trying to update record in C# but Im getting an error: Incorrect syntax near ','
while I dont have any ',' sign in my form input.
Also update query if fine and working in database.
Could you help me please....thanks in advance
my codes are in Update Button which are below:
string strCon = @"Data Source=YOUR-E659457A65\SQL
SqlConnection myConnection = new SqlConnection(strCon);
myConnection.Open();
string strSQL = "Update [CLIENT TABLE] Set [CLIENT NAME] = '" + ClientName + "' Where JobID = " + JobID;
SqlCommand cmd = new SqlCommand(strSQL, myConnection);
cmd.ExecuteReader();
myConnection.Close();
myConnection.Dispose();
MessageBox.Show("Record Update successfully");
this.Close();
You need to use cmd.ExecuteNonQuery();
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
cmd.ExecuteScalar();
instead of cmd.ExecuteReader();