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">

<title>Untitled Page</title>

</head>

<body>

<div>

<tr>

<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>

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

onclick="btn_register_Click" />

</td>

</tr>

<tr>

<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;

}

Insert Checkbox values into database

2 comments: