how to add table name from textboxid in insert data query

Shourya Verdhan

14y2kVisual Basic .NET

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]

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shourya Verdhan14y ago
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....
Vulpes14y ago
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 + "' )";