Getting error into UPDATE query

Question

0.00/5 (No votes)

See more:

.NET3.5

Below code is for update the record in excel sheet:-

try
{
System.Data.OleDb.OleDbConnection MyConnection;
System.Data.OleDb.OleDbCommand myCommand = new System.Data.OleDb.OleDbCommand();
string sql = null;
MyConnection = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\\csharp.net-informations.xlsx;Extended Properties=Excel 12.0 Xml;");
MyConnection.Open();
myCommand.Connection = MyConnection;

sql = (@"Update [Sheet1$] set (candidatefname='" + txtFName.Text + "', candidatemname='" + txtMName.Text + "', candidatelname='" + txtLName.Text + "', dob='" + dtpDOB.Value + "', sex='" + cmbSex.Text + "', currentaddress='" + txtCurrentAddress.Text + "', permanentaddress='" + txtParmanentAddress.Text + "', mobilenumber='" + txtMobile.Text + "', mailid='" + txtMailID.Text + "', maritalstatus='" + cmbMaritalStatus.Text + "', experience='" + txtExperience.Text + "', departmentname='" + cmbDepartment.Text + "') where SrNo='" + cID + "' ");
myCommand.CommandText = sql;
myCommand.ExecuteNonQuery();
MyConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}

I am getting the error : Syntax error in UPDATE statement.

When I am debugging the code getting all the value perfectly as I want, but in sql object I am getting null value.

So please can anybody tell me what is wrong with this?

Posted 9-Jul-14 21:48pm

DT_2

Add a Solution

Comments

Pheonyx 10-Jul-14 4:08am

I would suggest you re-factor that code to use parameters else it becomes susceptible to sql injection attacks.

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

purvivani · Accepted Answer · 2014-07-09T22:05:00

Solution 1

Update query syntax is wrong - update table set field = newvalue where criteria...
you have used "(" after set .
please remove "(" after set and also remove ")" before where

Posted 9-Jul-14 22:05pm

purvivani

*Suvabrata Roy* · Accepted Answer · 2014-07-09T22:06:00

Remove "(" & ")" after "set" in the SQL it will work

(@"Update [Sheet1$] set (candidatefname='" + txtFName.Text + "', candidatemname='" + txtMName.Text + "', candidatelname='" + txtLName.Text + "', dob='" + dtpDOB.Value + "', sex='" + cmbSex.Text + "', currentaddress='" + txtCurrentAddress.Text + "', permanentaddress='" + txtParmanentAddress.Text + "', mobilenumber='" + txtMobile.Text + "', mailid='" + txtMailID.Text + "', maritalstatus='" + cmbMaritalStatus.Text + "', experience='" + txtExperience.Text + "', departmentname='" + cmbDepartment.Text + "') where SrNo='" + cID + "' ");

Getting error into UPDATE query

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Getting error into UPDATE query

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us