Can we use variable for a table name in query?

Question

Here in the code I am trying to retrieve information from a database and store it in a table. In query i have used a variable to specify a table, i am doing so because i want to use this single piece of code to retrieve information from various tables based on which table name the variable "a" contain but when i am executing this it's throwing me an exception. please help...

MyOleDbConnection.Open();
string a = "login";
string query = string.Format("select Email,Username,PhoneNo,Department from '{1}' where Email='{0}'", editrecordtextBox.Text,a);
DataTable dt = new DataTable();
OleDbDataAdapter da = new OleDbDataAdapter();
da = new OleDbDataAdapter(query, MyOleDbConnection.vcon);
da.Fill(dt);

Note- this is just the part of the code, the exception is occuring in this code only.

Whats the exception message? What database are you using? Probable cause is single quote around table name in your query. Try to remove it. — Jurica Smircic
– Jurica Smircic, Commented May 4, 2013 at 17:41

Martin Mulder · Accepted Answer · 2013-05-04 18:07:51Z

3

Your code is in fact working correctly.

First of all, remove your single quotes around the table name. These mark a text, not an identifier or name.

I can imagine that login is a reseverd name you cannot use as plain text in your SQL. Depending on the database you can quote your tablename so it is recognizes as a name, not an reserved word.

For SQL-Server it would be done with [ and ]:

string query = string.Format("select Email,Username,PhoneNo,Department from [{1}] where Email='{0}'", editrecordtextBox.Text,a);

If you would give us your database, we could help.

edited May 4, 2013 at 18:07

answered May 4, 2013 at 17:45

Martin Mulder

13k3 gold badges30 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kratos Over a year ago

thanks man, but its working fine after removing the single quotes.

Attila · Accepted Answer · 2017-10-11 11:19:56Z

0

the way that tested and Worked is something like Below as you see the Table Name is Variable Form i Make a query with concatenate 3 section together

string query = "SELECT TOP 1 * FROM M" + TableName.ToString() + " ORDER BY ID 
DESC";

answered Oct 11, 2017 at 11:19

Attila

1491 silver badge4 bronze badges

Collectives™ on Stack Overflow

Can we use variable for a table name in query?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related