SQL

con.ConnectionString = ConfigurationManager.ConnectionStrings["Gisla"].ConnectionString;

SqlCommand cmd = new SqlCommand();

cmd.Connection = con;

cmd.CommandType = CommandType.Text;

cmd.CommandText = @"insert into Project(Company,JobNo,CarReg,Customer,Contact,Address,City)values('" + DropDownList1.SelectedItem + "', '" + TextBox1.Text + "','" + TextBox14.Text + "', '" + TextBox17.Text + "' ,'" + TextBox6.Text + "','" + TextBox9.Text + "')";

con.Open();

int i = cmd.ExecuteNonQuery();

con.Close();