Link to home
Create AccountLog in
Avatar of babubhai
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\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();
Avatar of Gautham Janardhan
Gautham Janardhan

try
cmd.ExecuteScalar();
instead of cmd.ExecuteReader();

 
You need to use cmd.ExecuteNonQuery();
ASKER CERTIFIED SOLUTION
Avatar of EmrahZengin
EmrahZengin
Flag of Türkiye image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account