how to insert radio button value in windows forms

Question

hello i make a registration form in widows forms. And in this i take 2 radio button male and female in groupBox. How to insert radio button value in sql. please send me insert query.

Satyapriya Nayak · Answer

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace Insert_radiobutton_value_windows { public partial class Form1 : Form { SqlConnection con = new SqlConnection(@server = HOME-SAT/SQLEXPRESS;data source = .; initial catalog = test; user id=sa;pwd =pintu ;integrated security = SSPI); SqlCommand com; public Form1() { InitializeComponent(); } private void btn_insert_Click(object sender EventArgs e) { if (txtName.Text == ) { MessageBox.Show(Please enter name); txtName.Focus(); } else if (rbtn_male.Checked == false && rbtn_female.Checked == false) { MessageBox.Show(Please select radiobutton); } else if (rbtn_male.Checked == true) { com = new SqlCommand(); com.Connection = con; com.CommandType = CommandType.Text; com.CommandText = insert into register values(@Name@Gender); com.Parameters.Clear(); com.Parameters.AddWithValue(@Name txtName.Text); com.Parameters.AddWithValue(@Gender rbtn_male.Text); if (con.State == ConnectionState.Closed) con.Open(); com.ExecuteNonQuery(); con.Close(); MessageBox.Show(Data entered successfully!!!); clear(); } else { com = new SqlCommand(); com.Connection = con; com.CommandType = CommandType.Text; com.CommandText = insert into register values(@Name@Gender); com.Parameters.Clear(); com.Parameters.AddWithValue(@Name txtName.Text); com.Parameters.AddWithValue(@gender rbtn_female.Text); if (con.State == ConnectionState.Closed) con.Open(); com.ExecuteNonQuery(); con.Close(); MessageBox.Show(Data entered successfully!!!); clear(); } } void clear() { txtName.Text = ; rbtn_male.Checked = false; rbtn_female.Checked = false; } } }

Iftikar Hussain · Answer

Hi You can do like this private void button1_Click(object sender EventArgs e) { string gender=; if(rdoButtonMale.Checked) { gender=Male; } else if(rdoButtonFemale.Checked) { gender=Female; } } Regards Iftikar