Continuing my ASP.NET GridView Tips and Tricks series, this post shows how to bind the Checkbox in an ASP.NET GridView.
You may have columns in your database that represents status, like 0 or 1. They are usually represented using the ‘Bit’ datatype in SQL Server For eg: The Discontinued column in the Products table of the Northwind database. If you are binding the GridView to such a column via a DataSource, you can use the CheckBoxField to bind to bit datatypes, as shown below
<asp:CheckBoxField DataField="Discontinued" HeaderText="Discontinued"
Bind CheckBox to a Column which has data in ‘Yes’ or ‘No’ format
However, at times developers use ‘Yes’ or ‘No’ in their tables to represent status. In such cases, here’s how to use the ItemTemplate to bind a Checkbox in an ASP.NET GridView
As you can see, we are using a DataBinding expression and calling the Eval() method. Behind the scenes, the Eval() method calls the static DataBinder.Eval() method and uses reflection to find the column name. If you want to avoid using reflection, use the following code: