title: Can we use variable for a table name in query?
body: <p>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...</p>
  
  <pre><code>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);
  </code></pre>
  
  <p>Note- this is just the part of the code, the exception is occuring in this code only.</p>