Populate DropDownCheckBoxes from Database using C# in ASP.Net

Hi jain4,

I have created sample. Refer the below code.

For this sample i have make use of Northwind database which you can get by clicking on the link below.

Download Northwind Database

HTML

<asp:DropDownCheckBoxes ID="DropDownCheckBoxes1" runat="server" UseSelectAllNode="false">
    <Style SelectBoxWidth="195" DropDownBoxBoxWidth="160" DropDownBoxBoxHeight="90" />
</asp:DropDownCheckBoxes>
&nbsp;
<asp:ExtendedRequiredFieldValidator ID="ExtendedRequiredFieldValidator1" runat="server"
    ControlToValidate="DropDownCheckBoxes1" ErrorMessage="Required" ForeColor="Red"></asp:ExtendedRequiredFieldValidator>
<br />
<br />
<asp:Button Text="Submit" runat="server" OnClick="Submit" />

Code

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        this.PopulateCategory();
    }
}

private void PopulateCategory()
{
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT CategoryID,CategoryName FROM Categories"))
        {
            using (SqlDataAdapter sda = new SqlDataAdapter())
            {
                cmd.CommandType = CommandType.Text;
                cmd.Connection = con;
                sda.SelectCommand = cmd;
                using (DataTable dt = new DataTable())
                {
                    sda.Fill(dt);
                    DropDownCheckBoxes1.DataSource = dt;
                    DropDownCheckBoxes1.DataTextField = "CategoryName";
                    DropDownCheckBoxes1.DataValueField = "CategoryID";
                    DropDownCheckBoxes1.DataBind();
                }
            }
        }
    }
}

protected void Submit(object sender, EventArgs e)
{
    string message = string.Empty;
    foreach (ListItem item in DropDownCheckBoxes1.Items)
    {
        if (item.Selected)
        {
            message += item.Text + " " + item.Value + "\\n";
        }
    }
    ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "alert('" + message + "');", true);
}

Screenshot