SQL

Question

Please give me a insert coding without using stored procedure(SP)

Ankit Shukla · Answer

Hi Try this sample code. SqlConnection con = new SqlConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings[Gisla].ConnectionString; SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandType = CommandType.Text; cmd.CommandText = @insert into Project(CompanyJobNoCarRegCustomerContactAddressCity)values(' + DropDownList1.SelectedItem + ' ' + TextBox1.Text + '' + TextBox14.Text + ' ' + TextBox17.Text + ' ' + TextBox6.Text + '' + TextBox9.Text + '); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close();

viswa a · Answer

simple registration form which includes fnamelnamedobgenderaddress

Suraj Sahoo · Answer

What exactly do you want here?