CODEWITHSUNDEEP
c#ms-accessms-access-2003
New Coder
New Coder

Reputation: 501

Reading reserved keyword column name of MSACCESS using c# code

I am creating a application which is having database as MSACCESS. one of the column name in the database is "Date", when i try to read the column using C# CODE its says "No value given for one or more required parameter"

    SELECT [DATE] FROM TABLE1

Is there any way we read the reserved keyword columns in c# coding.

please help

Upvotes: 0

Views: 338

Answers (1)

Akash Thakare
Akash Thakare

Reputation: 22972

"No value given for one or more required parameter"

This is generated because you are not passing parameters properly to query.

For example

"select name from table where name="+abc+";

this kind of thing generate this problem as ' ' are missing.

Or you are providing less parameters in query for prepared statement. (there may be some other reasons)

Please check.

Because I don't find anything wrong with this

SELECT [Date] FROM TABLE1

Upvotes: 2

Related Questions