how to add table name from textboxid in insert data query

Question

Dear Friends,

i have a code where i insert values in table and table name comes from textbox id

Code is...

SqlConnection con = new SqlConnection();

con.ConnectionString = "data source=NDTS12; initial Catalog=ndts_tm247; integrated security=true;";

con.Open();

string sql = "INSERT INTO " + txtemployeeid.Text.Trim() + "values('" + txtname.Text + "','" + txtcont.Text + "','" + txtcont2.Text + "','" + txtaddress.Text + "','" + txtmail.Text + "','" + txtsaletype.Text + "','" + txtamount.Text + "','" + dateTimePicker1.Text + "','" + txtissue.Text + "','" + txtstatus.Text + "','" + txttechname.Text + "','" + txtos.Text + "','" + txttvid.Text + "','" + txttvpw + "','" + txtdiscription.Text + "' )"; sql += ")";

SqlCommand cmd = new SqlCommand(sql, con);

cmd.ExecuteNonQuery();

con.Close();

But this code Generate an exception new "' )"; sql += ")";

any one can tell AS SOON AS POSIBLE me where is the problem in this code

my email id is [email protected]

Vulpes · Answer

It looks to me like there should be a space before 'values' and that you don't need the line : sql += ")"; as you've closed the parentheses needed for the 'values' clause already. So I'd try: string sql = "INSERT INTO " + txtemployeeid.Text.Trim() + " values ('" + txtname.Text + "','" + txtcont.Text + "','" + txtcont2.Text + "','" + txtaddress.Text + "','" + txtmail.Text + "','" + txtsaletype.Text + "','" + txtamount.Text + "','" + dateTimePicker1.Text + "','" + txtissue.Text + "','" + txtstatus.Text + "','" + txttechname.Text + "','" + txtos.Text + "','" + txttvid.Text + "','" + txttvpw + "','" + txtdiscription.Text + "' )";

Shourya Verdhan · Answer

Dear Vulpes, Thank you so much for reply, But i got my fault already. My fault was that i had put 2 times ) bracket at last so that's why this code generate Exception.. But Thank u so much....