How to Insert RadioButton selected Text & Checkboxlist selected text in database

See more:

ASP.NET

Hi,

(Am unable to insert Radio Button selected Text, Checkboxlist selected text in database please help me to solve this problem).

I had solved this problem the following code is working now

protected void Button1_Click(object sender, EventArgs e)
    {
        string EmpNo = TextBox1.Text;
        string EmpName = TextBox2.Text;
        string Designation = DropDownList1.SelectedItem.Text;
        string Department = DropDownList2.SelectedItem.Text;
        decimal Salary = Convert.ToDecimal(TextBox3.Text);
        string Gender = RadioButtonList1.SelectedItem.Text;
        string Preference = CheckBoxList1.SelectedItem.Text;      
       

        SqlConnection con = new SqlConnection("Server=********;uid=sa;password=*****; database=sreeramdasari;");
        SqlCommand cmd = new SqlCommand("insert into EmployeeDetails values(@EmpNo,@EmpName,@Designation,@Department,@Salary,@Gender,@Preference)", con);

        
    
        cmd.Parameters.AddWithValue("@EmpNo", EmpNo);
        cmd.Parameters.AddWithValue("@EmpName", EmpName);
        cmd.Parameters.AddWithValue("@Designation", Designation);
        cmd.Parameters.AddWithValue("@Department", Department);
        cmd.Parameters.AddWithValue("@Salary", Salary);
        cmd.Parameters.AddWithValue("@Gender",Gender);
        cmd.Parameters.AddWithValue("@Preference",Preference);
        con.Open();

       
       int i= cmd.ExecuteNonQuery();
       if (i > 0)
       {
           Label6.Text = ("Record Added Successfuly");
           //MessageBox.Show("Record Added");
       }


       else
       {
           Label6.Text = ("Record not Added");
           //MessageBox.Show("Record not Added");          
       }
       Label6.Enabled = true;
       Button2.Enabled = false;

        con.Close();            
}

Thank you very much for one and all

Thanks & Regards
Sreeram