Member Avatar for 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 :)

  • 2 Contributors
  • 1 Reply
  • 174 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by BitBlt
Member Avatar for 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!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.