using Table name as Variable string

[Z33shan]

hello :)

i'm developing an app in VS 2010 C#, linked with an MS Access Database.
i want to use a table name as variable. i have tried:

string tblname = students;
string query = "select * from  '" + tblname + "' where rollno=123";

but it's not working :(
kindly guide me.

thanks :)

[BitBlt]

Replace the single-quotes with square brackets like so:

string tblname = students;
string query = "select * from  [" + tblname + "] where rollno=123";

By putting single-quotes, you are basically telling your database engine to select everything from a string. Probably not what you want. MSAccess interprets anything inside square brackets as a database object (table, column, etc.). You could simply leave off the brackets altogether, but then if your variable tblname contains any spaces or special characters (which Access allows) then you'll get an error.

Hope this helps! Good luck!