I am using sql express with visual studio..untill now itwas going fine but suddenly i encountered a new problem where i am getting parsing error if i do not specify my table name in square brackets.why is that so? can anyone plz explain??

like string sql="select * from [tablename]";
why square brackets????

Maybe because your table name is a reserved word (like User) or contains spaces in its name?

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

thanx a lot..that was precisely may problem..i was using a keyword as table name