1,105,423 Community Members

using Table name as Variable string

Member Avatar
Z33shan
Light Poster
26 posts since Sep 2011
Reputation Points: 1 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
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 :)

Member Avatar
BitBlt
Practically a Posting Shark
895 posts since Feb 2011
Reputation Points: 442 [?]
Q&As Helped to Solve: 163 [?]
Skill Endorsements: 16 [?]
Featured
 
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!

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: