Subject | Field Name problem in Query |
---|---|
Author | peedswarge |
Post date | 2008-11-30T10:48:24Z |
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.
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.