Filling a DataSet using OleDbDataAdapter

[jzamss]

Good Day.

 

I encountered a problem when filling a dataset using the OleDbDataAdapter. The scenario is like this:

 

I created an object say, Record, that has a DataSet member variable in it. The DataSet's Tables and Columns definition are dynamically defined and created based on a XmlSchema. When filling a specific table in the DataSet, the SelectCommand.CommandText and the Parameters are dynamically created before calling the Adapter.Fill method.

 

example sql: SELECT * FROM CUSTOMER WHERE id=@id

 

where : @id = is created as a parameter for the SelectCommand

and the Param.Value is set to a known value

 

---------------------------------------------------------------

Error Message: Must declare the variable @id

---------------------------------------------------------------

 

What is strange is that when using SqlConnection and SqlDataAdapter instead of the OleDbConnection and OleDbDataAdapter, the DataSet if properly filled and the program runs without problem.

 

I think the problem is with the OleDbDataAdapter. I'm new to C# and hopefully you can give me some information and guidance.

 

Best Regards...

[fadi]

statement should be

"SELECT * FROM CUSTOMER WHERE id=' " & @id & "' "

[jzamss]

Thanks fadi.

[Robby]

@id is a parameter not a variable, you cannot concatinate it with the Select statement. It should be part of the string itself.