Subject Field Name problem in Query
Author peedswarge
Hi All,

I am facing problem while fetching a field called 'DATE' from a table
using C#.
The query string is ..
SqlDataSource1.SelectCommand = "Select First 10 NAME, DATE, ID from
Table1";
I am getting following error :
//-----------//
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 27
,
//-----------//

I have tried the following too ..
SqlDataSource1.SelectCommand = "Select First 10 NAME, \"DATE\", ID
from Table1";
But no good... :(

Please Help ...

Thx & Regards,
Peed Swarge.