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

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

<!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:RadioButtonList ID="rbtGender" runat="server" RepeatDirection="Horizontal">

<asp:ListItem>Male</asp:ListItem>

<asp:ListItem>Female</asp:ListItem>

</asp:RadioButtonList>

</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 _Default : System.Web.UI.Page

{

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

SqlCommand com;

protected void btn_register_Click(object sender, EventArgs e)

{

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", rbtGender.SelectedValue);

if (con.State == ConnectionState.Closed)

con.Open();

com.ExecuteNonQuery();

con.Close();

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

}

}

}

Thanks for reading