troubleshooting Question

In C#: How can I save changes in Database using SQL Command

Avatar of babubhai
babubhai asked on
.NET Programming
3 Comments1 Solution1058 ViewsLast Modified:
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();
ASKER CERTIFIED SOLUTION
EmrahZengin

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros