Hi ,
Try this it will be much better
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["testConnectionString"].ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("insert into dbo.cars(carID, Capicity, Luggage, Doors,Category,carname) values ('688', '5' , '9' , '8' , @parm , 'datsun')", conn))
{
cmd.Parameters.AddWithValue("@parm", DropDownList2.SelectedValue);
cmd.ExecuteNonQuery();
}
}
Connection in web.config
<configuration>
<connectionstrings>
<add name="testConnectionString" connectionstring="Data Source=.;Initial Catalog=test;Integrated Security=True">
providerName="System.Data.SqlClient" />
</add></connectionstrings></configuration>
Best Regards
M.Mitwalli