Search

Wednesday, September 16, 2015
0 comments

Bind CheckBoxList from Database in ASP.Net C# Example

11:42 PMWednesday, September 16, 2015
Introduction:
In this article we will learn how to bind CheckBoxList in asp.net c#. I will give you an example of CheckBoxlist binding. you can use a CheckBoxList control to display a number of check boxes at once as a column of check boxes. The CheckBoxList control exists within the System.Web.UI.WebControls namespace. This control is often useful when you want to bind the data from a datasource to checkboxes . The CheckBoxList control creates multiselection checkbox groups at runtime by binding these controls to a data source.



Public Properties of the CheckBoxList class
Cellpadding : Obtains the distance between the border and data of the cell in pixels.

CellSpacing : Obtains the distance between cells in pixels.

RepeatColumns : Obtains the number of columns to display in the CheckBoxList control.

RepeatDirection : Obtain a value that indicate , whether the control displays vertically or horizontally.

RepeatLayout : Obtains the layout of the check boxes.

TextAlign : Obtains the text placement for the check boxes within the group.


STEP-1 :  Create Database Table  in visual studio 2012.



STEP-2 :   Select CheckBoxList from ToolBox and drop onto Design window

checkboxlist

STEP-3 : Bind CheckBoxList on PageLoad method.






using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class checkboxlist : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
         if (!Page.IsPostBack)
        {
            using (SqlConnection con=new SqlConnection ())
            {
con.ConnectionString =ConfigurationManager.ConnectionStrings ["ConnectionString"].ToString ();
                con.Open ();
                using (SqlCommand cmd = new SqlCommand())
                {
                    cmd.CommandText = "select * from [Table]";
                    cmd.Connection = con;
                    using (DataSet ds = new DataSet())
                    {
                        using (SqlDataAdapter da = new SqlDataAdapter(cmd))
                        {
                            da.Fill(ds);
                            CheckBoxList1.DataSource = ds;
                            CheckBoxList1.DataTextField = "name";
                            CheckBoxList1.DataValueField = "Employeeid";
                            CheckBoxList1.DataBind();
                        }
                    }
                }

                
            }
        }
    }
}



OutPut Screen

output screen



Protected by Copyscape Online Copyright Protection Software

0 comments :

Post a Comment

 
Toggle Footer
Top