Post
Ask Question

Insert RadioButtonList values into database

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