How to add checkbox in DataTable?

Question

I want to add the checkbox in DataTable and the bind ti grid view.

So I try like this.

DataTable dt = new DataTable("UserAcess");

DataColumn dc1 = new DataColumn("PageName");
dt.Columns.Add(dc1);

foreach (var item in RoleName)
{   
    DataColumn  dc = new DataColumn(item.RoleName);
    dt.Columns.Add(dc);                     
}

int i=0, j = 0;
foreach (var page in pageName)
{
     i +=1;
    DataRow dr = dt.NewRow();

    dr["PageName"] = page.PAGE_NAME;   

    j = 0;                   

    foreach (var role in RoleName)
    {                  
        dt.Columns.Add(new DataColumn("che" + i.ToString() + j.ToString(), typeof(System.Web.UI.WebControls.CheckBox)));                        
        j += 1;
        CheckBox ck = new CheckBox();                   
        ck.Checked = true;                   
        dr[role.RoleName] = ck;                   

    }
    dt.Rows.Add(dr);
}    
NewDataGrid.DataSource = dt;
NewDataGrid.DataBind();

But but out put like this

enter image description here

I want to add the check boxes. How can I do it?

instead of using checkbox in datatable you must use checkbox in grid view and provide the values to checkbox from datatable.. — Rahul
– Rahul, Commented Aug 30, 2013 at 4:25
Don't confuse the DataTable class (which is about data), with the CheckBox control (which is about presentation). — John Saunders
– John Saunders, Commented Aug 30, 2013 at 5:17

rs. · Accepted Answer · 2013-08-30 05:10:09Z

1

change your code to this:

create columns for each role of type boolean

foreach (var item in RoleName)
{   
    DataColumn  dc = new DataColumn(item.RoleName, typeof(bool));
    dt.Columns.Add(dc);                     
}

then change your code where you are stroring checkboxes in datacolumn to store boolean true/false value for column

foreach (var role in RoleName)
{                  
    dr[role.RoleName] = true;    
}

Final Code:

DataTable dt = new DataTable("UserAcess");

DataColumn dc1 = new DataColumn("PageName");
dt.Columns.Add(dc1);

foreach (var item in RoleName)
{   
    DataColumn  dc = new DataColumn(item.RoleName, typeof(bool));
    dt.Columns.Add(dc);                      
}

foreach (var page in pageName)
{
    DataRow dr = dt.NewRow();
    dr["PageName"] = page.PAGE_NAME; 

    foreach (var role in RoleName)
    {                  
        dr[role.RoleName] = true; 
    }
    dt.Rows.Add(dr);
}    

NewDataGrid.DataSource = dt;
NewDataGrid.DataBind();

answered Aug 30, 2013 at 5:10

rs.

27.6k13 gold badges71 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

aruni Over a year ago

Can you please tell me how to enable check box? By default all the check boxes are disable.So user can't edit it. Can you please tell how to enable check box?

rs. Over a year ago

Are you trying to edit and save checkbox data? use Edit Command button, when you click edit it should show checkbox in enabled mode.

Ehsan · Accepted Answer · 2013-08-30 04:32:49Z

1

just add a boolean field in datatable and it will be mapped as checkbox field in datagridview.

DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("IsActive", typeof(bool)));

now IsActive field will be mapped as Checkbox on grid view.

answered Aug 30, 2013 at 4:32

Ehsan

32.8k6 gold badges61 silver badges66 bronze badges

2 Comments

rs. Over a year ago

And how will you display checkbox for dynamic columns here using your code above? OP has dynamic columns based on roles.

Ehsan Over a year ago

@rs. OP can just add columns to datattable and re-bind. What is the issue with that?

Ronak Patel · Accepted Answer · 2013-08-30 04:43:57Z

1

You can do this as below

<asp:GridView ID="GridView1" runat="server">
            <Columns>
                <asp:CheckBoxField HeaderText="Select" DataField="IsActive" />
            </Columns>
        </asp:GridView>

Do not add checkbox field to data table. Just add a boolean field to it and bind it to the checkboxfield of grid view

answered Aug 30, 2013 at 4:43

Ronak Patel

2,60219 silver badges20 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:07:14Z

0

You have to Add a field with Boolean type and assign bool value in DataTable and then bind that DataTable with Grid View.

Try to Follow this Link

edited May 23, 2017 at 12:07

CommunityBot

11 silver badge

answered Aug 30, 2013 at 4:34

Rahul

5,6556 gold badges38 silver badges58 bronze badges

Comments

Grigory Zhadko · Accepted Answer · 2021-03-19 07:22:10Z

0

It is necessary that you create an option to enable it. Configurator comes as disabled by default. You can do this as below.

<script type="text/javascript">
    function fnSelectAll() {
        const disabledAllCheckboxInPage = 
        Array.from(document.querySelectorAll("input[type='checkbox']"))
        disabledAllCheckboxInPage.forEach(item => item.disabled = false)
    }
</script>

<asp:GridView ID="GridView1" runat="server">
   <Columns>
       <asp:TemplateField>
            <HeaderTemplate>
               <input id="chkAll" type="checkbox" onclick="fnSelectAll()" />
             </HeaderTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

edited Mar 19, 2021 at 7:22

Grigory Zhadko

1,8841 gold badge28 silver badges39 bronze badges

answered Mar 18, 2021 at 19:44

Fabio Macieira

1

Comments

Fabio Macieira · Accepted Answer · 2021-03-22 22:20:07Z

0

I found another way to solve your problems, after gridview1.DataBind (); enter the code below.

 gridview1.DataSource = dt;
 gridview1.DataBind ()

 foreach (GridViewRow row in gridview1.Rows)
 {
    for (int i = 0; i <= row.Cells.Count - 1; i++)
    {
       if (i > 1)
       {
         CheckBox check = (row.Cells[i] as DataControlFieldCell).Controls[0] as CheckBox;
         check.Enabled = true;
       }
    }
 }

answered Mar 22, 2021 at 22:20

Fabio Macieira

1

1 Comment

Fabio Macieira Over a year ago

when in doubt see the link stackoverflow.com/questions/6788922/…. if you need to save the data passed by the check use the link forums.asp.net/t/…

Collectives™ on Stack Overflow

How to add checkbox in DataTable?

6 Answers 6

2 Comments

2 Comments

Comments

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

2 Comments

2 Comments

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related