Insert Checkbox values into database

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

 

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Checkbox_values_insert._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:CheckBox ID="chk1" Text="Male" runat="server" />

                    <asp:CheckBox ID="chk2" 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 Checkbox_values_insert

{

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

    {

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

        SqlCommand com;

        protected void Page_Load(object sender, EventArgs e)

        {

 

        }

 

        protected void btn_register_Click(object sender, EventArgs e)

        {

            if (chk1.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", chk1.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", chk2.Text);

                if (con.State == ConnectionState.Closed)

                    con.Open();

                com.ExecuteNonQuery();

                con.Close();

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

                clear();

            }

        }

        void clear()

        {

            txtName.Text = "";

            txtEmail.Text = "";

            chk1.Checked = false;

            chk2.Checked = false;

        }

    }

}

 

 

Thanks for reading