
SqlCommand cmd1 = new SqlCommand("TCInsert");
cmd1.Parameters.AddWithValue("@adminNo", txtAdmissionno.Text);
cmd1.Parameters.AddWithValue("@nationality", ddlNationality.Text);
cmd1.Parameters.AddWithValue("@communityReligion", ddlCommunity.Text);
cmd1.Parameters.AddWithValue("@dateOfPromotion", txtpromotion.Text);
cmd1.Parameters.AddWithValue("@classToPromotion", ddlSemester.Text);
Download: eType1.com/f.php
string connectioString =@"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\Projects\adoxA2Z db\adoxA2z.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
SqlConnection con = new SqlConnection(connectioString);
con.Open();
cmd1.Connection = con;
cmd1.CommandType = CommandType.StoredProcedure;
//cmd.Connection = con;
//con.Open();
cmd1.ExecuteNonQuery();
con.Close();

Satyapriya NayakPosted Sep 3, 2011, 9:53 AM
From your above code you have three dropdownlist so
Replace
ddlNationality.Text with ddlNationality.SelectedItem.Text
ddlCommunity.Text with ddlCommunity.SelectedItem.Text
ddlSemester.Text with ddlSemester.SelectedItem.Text
Thanks
If this post helps you mark it as answer
Satish BhatPosted Sep 3, 2011, 8:03 AM
For example,
cmd1.Parameters.AddWithValue("@adminNo", txtAdmissionno);
Note '.Text' is missing.
Or
cmd1.Parameters.AddWithValue("@communityReligion", ddlCommunity.SelectedItem);
Note '.Value' is missing.
Or you are using wrong vaiable name while adding the parameter to the sqlcommand
Check for this mistake in your code.
Jiteendra SampathiraoPosted Sep 3, 2011, 7:38 AM
check the column names in your stored Procedure...(better trace every line using break points)
jayakrishnan MorayurPosted Sep 3, 2011, 7:04 AM
thanks
Jiteendra SampathiraoPosted Sep 3, 2011, 6:58 AM