Why are you doing that? You shouldn't need a bunch of identical tables created at runtime. There's a number of risks and problems with doing that. Most notably that you'll need the user account running this to have CREATE TABLE permission, which will let them create all sorts of tables other than the one you want them to.
You could just have one table called Abhi_Try, and add a column where when you put data in, also add 101 or 555 into the new column so you know which one it's associated with. (Better still would be to create a second table to list those and make a foreign key, but you'll probably need assistance from someone with experience to do that.)
If you really want to do it anyway, fundamentally it's just a query. You can change it the same way you'd change a SELECT query's parameters.
Thanks for the suggestion, but I am creating this application for internal company use where my team member whill have all the access to create, update and delete table and its on the basis of business need.
You said I can modify the select query and I tried same but still I an getting error.
As I said I am using a textbox on front screen with name textbox1 and it will have numeric values e.g. 101, 500, 202, 345 anything...
when I am using in select statment is not working at runtime and getting below error,
ERROR WITH TEST METHOD: System.Data.OleDb.OleDbException: ORA-00922: missing or invalid option at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at _Default.Button1_Click(Object sender, EventArgs e) in c:\Users\jaiab01\Abhi\DotNet\Default.aspx.cs:line 313
my code and select query is as below,
if (con.State == ConnectionState.Closed)
OleDbCommand myCommand = new OleDbCommand();
myCommand.Connection = con;
string number = TextBox1.Text;
myCommand.CommandText = "CREATE TABLE Abhi_Test_DotNet_'"+number+"' as Select CUSTOMER_CITY, CUSTOMER_STATE, Region from Karen_Provided_Excel";
// plus symbols added at starting and end poing of number but dont know the reson why it is not displaying here i.e. '"plus number plus"'
Label1.Text = "Table Created Successfully";
catch (Exception ex)
Label1.Text = "<br />ERROR WITH TEST METHOD: " + ex;
if (con.State == ConnectionState.Open)