How to insert variable inside a Select statement

Question

string table = "City";
string query = "Select * from '"+table+"'";

This gives me error stating incorrect symbol near ".

However,

string query = "Select * from City";

Gives the proper output.

Answer 1

You just this

string query = "Select * from '"+table+"'";

to be replaced by

string query = "Select * from " + table;

Because you Query string is not "Select * from City"; While it is forming "Select * from 'City'";

and thus you getting error