CheckBox in datagridview asp.net

Question

1.00/5 (1 vote)

See more:

I have a column in my database which is bit column when i displayed it in the dataGridView it's shown as a checkbox but i can't click on this checkbox , i want to be able to click on it and select rows from the output table to do some action on them .. any help ?

C++

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString);

SqlDataAdapter adabt = new SqlDataAdapter();
DataTable table = new DataTable();
SqlCommand cmd = new SqlCommand("GetAllEmployees", con); // this gets all data about employees
cmd.CommandType = CommandType.StoredProcedure;
adabt.Fill(table);
GridView1.DataSource = table;
GridView1.DataBind();

Posted 12-Mar-13 15:01pm

Hend Riad

Updated 12-Mar-13 18:38pm

Vani Kulkarni

v3

Add a Solution

Comments

[no name] 12-Mar-13 21:03pm

Please post your code that demonstrates this problem.

Hend Riad 12-Mar-13 21:07pm

i'm not making any thing different in the code i just bind the data from DB, and as this column is saved as bit so it's transformed into checkbox .. but i didn't edit in anything else

Sergey Alexandrovich Kryukov 12-Mar-13 21:04pm

System.Windows.Forms? Tag it.
Yes, you can click on it. If you think you cannot, you screwed up things very well. Without a short but comprehensive code sample, it's hard to say what.
—SA

Hend Riad 12-Mar-13 21:05pm

but i'm not using windows forms, i'm dealing with web forms

Sergey Alexandrovich Kryukov 12-Mar-13 21:07pm

I see "ASP.NET", good, but "datagridview" is confusing. Is there a class with such name in ASP.NET? I don't think so.
And think about the code sample I mentioned. No one will consider your problem is you don't show it. Use "Improve question".
—SA

Sergey Alexandrovich Kryukov 12-Mar-13 21:59pm

No relevant code. Where are you check boxes, etc.?
—SA

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vani Kulkarni · Answer 1 · 2013-03-12T19:18:00

If you are directly binding datasource to a gridview defining bound columns then checkbox will be displayed for Bit fields.
If you want the checkbox to be clickable, then you need to define Template Column or CheckBoxField for BIT column.
See example in below link for CheckBoxField:
aspnet-gridview-checkboxfield-example[^]

For Template Column, refer following code:

ASP.NET

<asp:gridview id="GridView1" runat="server" allowpaging="True" xmlns:asp="#unknown">
   AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="PersonID" 
   DataSourceID="mySource" Width="366px" CellPadding="4" 
   ForeColor="#333333" GridLines="None">
 <columns>
   <asp:commandfield showselectbutton="True" />
   <asp:boundfield datafield="PersonID" headertext="PersonID">
         InsertVisible="False" ReadOnly="True" SortExpression="PersonID" />
   <asp:boundfield datafield="Name" headertext="Name">
                                       SortExpression="Name" />
   <asp:templatefield headertext="Select">
    <itemtemplate>
       <asp:checkbox id="chkSelect" runat="server" />
    </itemtemplate>
    <headertemplate>
    </headertemplate>
   </asp:templatefield>
 </asp:boundfield></asp:boundfield></columns>
 <footerstyle backcolor="#990000" font-bold="True" forecolor="White" />
 <rowstyle backcolor="#FFFBD6" forecolor="#333333" />
 <pagerstyle backcolor="#FFCC66" forecolor="#333333">
                           HorizontalAlign="Center" />
 <selectedrowstyle backcolor="#FFCC66" font-bold="True" forecolor="Navy" />
 <headerstyle backcolor="#990000" font-bold="True" forecolor="White" />
 <alternatingrowstyle backcolor="White" />
</pagerstyle></asp:gridview>

Also refer this link:
Selecting multiple checkboxes inside a GridView control[^]