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\SQLEXPRESS;Initial Catalog=DLCallLog;Integrated 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();
cmd.ExecuteScalar();
instead of cmd.ExecuteReader();