SQL Server error: ExecuteNonQuery: Connection property has not been initialized

fegecv

New Member
I am trying to develop a sample registration page using ASP.Net and C#. I am calling a stored procedure to insert the data to database. My database is SQL Server 2008. This is my code:\[code\]public partial class Sample : System.Web.UI.Page{ SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ToString()); string str;protected void Page_Load(object sender, EventArgs e){ rbt_Male.Checked = true;}protected void btn_Submit_Click(object sender, EventArgs e){ string @Name = txtbx_Name.Text; string @Gender_male = rbt_Male.Text; string @Gender_Female = rbt_Female.Text; string @Email = txtbx_Email.Text; DateTime @Dob = Convert.ToDateTime(txt_Dob.Text); submitdata();}protected void submitdata(){ try { SqlCommand cmd = new SqlCommand(); cmd.Parameters.Clear(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "insertdata"; if (rbt_Male.Checked) { cmd.Parameters.AddWithValue("@Name", txtbx_Name.Text); cmd.Parameters.AddWithValue("@Gender_Male", rbt_Male.Text); cmd.Parameters.AddWithValue("@Email", txtbx_Email.Text); cmd.Parameters.AddWithValue("@Dob", Convert.ToDateTime(txt_Dob.Text)); } else if (rbt_Female.Checked) { cmd.Parameters.AddWithValue("@Name", txtbx_Name.Text); cmd.Parameters.AddWithValue("@Gender_Female", rbt_Male.Text); cmd.Parameters.AddWithValue("@Email", txtbx_Email.Text); cmd.Parameters.AddWithValue("@Dob", Convert.ToDateTime(txt_Dob.Text)); } if (con.State == ConnectionState.Closed) con.Open(); cmd.ExecuteNonQuery(); lbl_Errormsg.Visible = true; lbl_Errormsg.Text = "Record Inserted Successfully"; con.Close(); } catch (Exception ex) { lbl_Errormsg.Visible = true; lbl_Errormsg.Text = ex.Message; }\[/code\]I am getting the error message \[quote\] ExecuteNonQuery: Connection property has not been initialized. \[/quote\]I am getting this error at \[code\]cmd.ExecuteNonQuery();\[/code\] Please help me.My stored procedure is \[code\]ALTER Procedure insertdata( @Name Varchar(20), @Gender Varchar(6), @Email Varchar(20), @Dob date) As Begin Insert into samplelogintable (Name, Gender, Email, Dob) Values(@Name, @Gender, @Email, @Dob) End\[/code\]
 
Back
Top