0

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 :)

2
Contributors
1
Reply
2
Views
4 Years
Discussion Span
Last Post by BitBlt
0

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!

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.