OleDbException: No value given for one or more required parameters. Update Query. Excel C#

Question

Updating MS Excel. OldeDbException: No value given for one or more required parameters. What is wrong in the below code,

private string _connString = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\\Workspace\\TestSet.xls;Mode=Share Deny None;Extended Properties=\"Excel 12.0;HDR=YES;READONLY=FALSE\"";

OpenConnection();
using (OleDbCommand objConfigCmdUpdate = new OleDbCommand("UPDATE [Config$] SET Enabled='1' WHERE TestSuite='CFTS'", ExlConn))
{
     objConfigCmdUpdate.ExecuteNonQuery();
     CloseConnection();
}

What is wrong in this code?

Thank you for the reply, but this did not help. `using (OleDbCommand objConfigCmdUpdate = new OleDbCommand("UPDATE [Config$] SET Enabled='1' WHERE TestSuite='CFTS';", ExlConn))` — Sharan, Jun 13 '14 at 06:02
Nobody knows the solution to this issue? Someone help me. I am stuck. — Sharan, Jun 14 '14 at 03:35

score 0 · Answer 1 · edited May 23 '17 at 12:12

0

If you use HDR=NO the column names are F1, F2 F3 etc...... so your query shlould be

"UPDATE [Config$] SET F1='1' WHERE F2='CFTS'"

for your ref click here

edited May 23 '17 at 12:12

Community

1
1

answered Jun 13 '14 at 05:56

Dhaval Patel

7,471
6
37
70

I dont to keep my code with respect to cell number, I want it to be column specific. Please suggest. – Sharan Jun 13 '14 at 06:00
Dhaval, even this did not work. i tried the below command, `using (OleDbCommand objConfigCmdUpdate = new OleDbCommand("UPDATE [Config$] SET B4='1' WHERE A4='CFTS';", ExlConn))` – Sharan Jun 13 '14 at 09:18

OleDbException: No value given for one or more required parameters. Update Query. Excel C#

1 Answers1