In this blog we will know how to insert RadioButton values into database.

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="Radio_button_values.WebForm1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

<title>Untitled Page</title>

</head>

<body>

<form id="form1" runat="server">

<div>

<table align="center">

<tr>

<td colspan="2">

<h3>

Registraion</h3>

</td>

</tr>

<tr>

<td>

Name:</td>

<td>

<asp:TextBox ID="txtName" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

<td>

Email</td>

<td>

<asp:TextBox ID="txtEmail" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

<td>

Gender</td>

<td>

<asp:RadioButton ID="rb1" Text="Male" runat="server" />

<asp:RadioButton ID="rb2" Text="Female" runat="server" />

</td>

</tr>

<tr>

<td align="center" colspan="2">

<asp:Button ID="btn_register" runat="server" Text="Register"

onclick="btn_register_Click" />

</td>

</tr>

<tr>

<td align="center" colspan="2">

<asp:Label ID="lblmsg" runat="server"></asp:Label>

</td>

</tr>

</table>

</div>

</form>

</body>

</html>

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

namespace Radio_button_values

{

public partial class WebForm1 : System.Web.UI.Page

{

string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

SqlCommand com;

protected void btn_register_Click(object sender, EventArgs e)

{

if (rb1.Checked == true)

{

SqlConnection con = new SqlConnection(strConnString);

com = new SqlCommand();

com.Connection = con;

com.CommandType = CommandType.Text;

com.CommandText = "insert into login values(@Name,@Email,@Gender)";

com.Parameters.Clear();

com.Parameters.AddWithValue("@Name", txtName.Text);

com.Parameters.AddWithValue("@Email", txtEmail.Text);

com.Parameters.AddWithValue("@gender", rb1.Text);

if (con.State == ConnectionState.Closed)

con.Open();

com.ExecuteNonQuery();

con.Close();

lblmsg.Text = "Data entered successfully!!!";

clear();

}

else

{

SqlConnection con = new SqlConnection(strConnString);

com = new SqlCommand();

com.Connection = con;

com.CommandType = CommandType.Text;

com.CommandText = "insert into login values(@Name,@Email,@Gender)";

com.Parameters.Clear();

com.Parameters.AddWithValue("@Name", txtName.Text);

com.Parameters.AddWithValue("@Email", txtEmail.Text);

com.Parameters.AddWithValue("@gender", rb2.Text);

if (con.State == ConnectionState.Closed)

con.Open();

com.ExecuteNonQuery();

con.Close();

lblmsg.Text = "Data entered successfully!!!";

clear();

}

}

void clear()

{

txtName.Text = "";

txtEmail.Text = "";

rb1.Checked = false;

rb2.Checked = false;

}

}

}

Thanks for reading