C# with SQL [Window Forms Help]

faizulhaque's Avatar, Join Date: May 2008
Skilled contributor
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
0
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor
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+"');";
0
faizulhaque's Avatar, Join Date: May 2008
Skilled contributor
Issue Solved THanks Mate: