SqlCommand cmd = new SqlCommand("insert into Register values (@Username,@Password,@conformmail,@Repeatmail,@Dateofbirth,@Gender,@Mobile,@Address,@Selectcountry,@Selectstate,@Selectcity,@securityquestion,@Capchaimage)", con);
cmd.Parameters.AddWithValue("@Username",TextBox1.Text.ToString());
cmd.Parameters.AddWithValue("@Password", TextBox2.Text.ToString());
cmd.Parameters.AddWithValue("@ConformMail", TextBox3.Text.ToString());
cmd.Parameters.AddWithValue("@Repeatmail", TextBox4.Text.ToString());
cmd.Parameters.AddWithValue("@Gender", RdoGender.SelectedItem.Text.ToString());
cmd.Parameters.AddWithValue("@Dateofbirth",TextBox5.Text.ToString());
cmd.Parameters.AddWithValue("@Address", TextBox6.Text.ToString());
cmd.Parameters.AddWithValue("@Mobile", TextBox7.Text.ToString());
cmd.Parameters.AddWithValue("@Selectcountry", DropDownList1.Text.ToString());
cmd.Parameters.AddWithValue("@Selectstate", DropDownList2.Text.ToString());
cmd.Parameters.AddWithValue("@Selectcity", DropDownList3.Text.ToString());
cmd.Parameters.AddWithValue("@Capchaimage", TextBox8.Text.ToString());
cmd.Parameters.AddWithValue("@securityquestion", TextBox9.Text.ToString());
con.Open();
cmd.ExecuteNonQuery();
Response.Write("registered successfully");
con.Close();