Hello Every C# PRogrammer and Others: I need help in C# database programming. i need to save textbox text into table of c# Here is code Code: // create command SqlConnection conn = new SqlConnection(@"server = .\sqlexpress;integrated security = true;database = office"); conn.Open(); string query = @"insert into emp('"+txtid.Text+"','"+txtname.Text+"','"+txtdesig.Text+"','"+txtsal.Text+"','"+txtjoin.Text+"','"+txtadd.Text+"','"+txtjoin.Text+"','"+txtcont.Text+"');"; SqlCommand cmd = new SqlCommand(query, conn); cmd.ExecuteNonQuery(); conn.Close(); This code is In Save Button: but when i execute this always Getting Error: as incorrrect Syntex. Any Help suggestion
yes, you will get an error of Incorrect Syntax, because the Insert statement is not correct. The correct syntax would be: 1] If you want to insert all values Code: "insert into emp values('"+txtid.Text+"','"+txtname.Text+"','"+txtdesig.Text+"','"+txtsal.Text+"','"+txtjoin.Text+"','"+txtadd.Text+"','"+txtjoin.Text+"','"+txtcont.Text+"');"; 2] If you want to insert specific values Code: "insert into emp(id,name,desig,sal) values('"+txtid.Text+"','"+txtname.Text+"','"+txtdesig.Text+"','"+txtsal.Text+"');";