Bind Column Names to checkbox list

is it possible to bind just the column names of a dataset to a checkboxlist. So i have ten columns in my dataset containing products sold by a company and want to populate the checkbox list with these column names so that we can track if the products are sold by the company.

Thanks Ahead of time for any input

Re: Bind Column Names to checkbox list

Hi..

Plz use the below code...

In Aspx page:

<asp:CheckBoxList ID="cblist" runat="Server"></asp:CheckBoxList>

In server side page:

cblist.DataSource = ds(This is dataset)
cblist.DataTextField = "COLUMN_NAME"
cblist.DataValueField = "ID"
cblist.DataBind()

Re: Bind Column Names to checkbox list

Hi...try this

cmd.Connection = con
            cmd.CommandType = CommandType.Text
            cmd.CommandText = Sql
            dap = New SqlDataAdapter()
            dap.SelectCommand = cmd
            dap.Fill(dt)
            Chbox.Items.Clear()
            Chbox.DataSource = dt.DefaultView.ToTable(True, "name")
            Chbox.DataTextField = "name"
            Chbox.DataBind()

Re: Bind Column Names to checkbox list

I actually went a different route. SInce Datasets dont have columns or rows i needed to pull the DataTable and populate the checkbox using

cblClinInfo.DataSource = ds_1.Tables[0].Columns;

Thanks

all for the help