private void button3_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\imran\Documents\Visual Studio 2010\Projects\CompleteProject\CompleteProject\Garments.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
con.Open();
SqlCommand cmd = new SqlCommand(" INSERT INTO OrderStyle (OrderNo,ProductId,SizeId,ColorId,Description) VALUES (@OrderNo,@ProductId,@SizeId,@ColorId,@Description)", con);
cmd.Parameters.Add(@OrderNo,SqlDbType.Int);
cmd.Parameters.Add(@ProductId,SqlDbType.Int);
cmd.Parameters.Add(@SizeId,SqlDbType.Int);
cmd.Parameters.Add(@ColorId,SqlDbType.Int);
cmd.Parameters.Add(@Description,SqlDbType.NVarChar);
cmd.Parameters["@OrderNo"].Value=int.Parse(comboBox1.SelectedValue.ToString());
cmd.Parameters["@ProductId"].Value=int.Parse(comboBox2.SelectedValue.ToString());
cmd.Parameters["@SizeId"].Value=int.Parse(comboBox3.SelectedValue.ToString());
cmd.Parameters["@ColorId"].Value=int.Parse(comboBox4.SelectedValue.ToString());
cmd.Parameters["@Description"].Value=textBox1.Text;
cmd.ExecuteNonQuery();
con.Close();
displayRecords();
}