ASP.NET Tutorial/Data Binding/CheckBoxField
Using CheckBoxFields
<source lang="csharp">
<%@ Page Language="C#" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" > <head id="Head1" runat="server">
<title>Show CheckBoxField</title>
</head> <body>
<form id="form1" runat="server">
<asp:GridView id="grdProducts" DataSourceID="srcProducts" DataKeyNames="Id" AutoGenerateColumns="false" AutoGenerateEditButton="true" Runat="server"> <Columns> <asp:BoundField DataField="Title" HeaderText="Product Title" /> <asp:CheckBoxField DataField="InTheaters" HeaderText="In Theaters" /> </Columns> </asp:GridView> <asp:SqlDataSource id="srcProducts" ConnectionString="<%$ ConnectionStrings:Products %>" SelectCommand="SELECT Id,Title,InTheaters FROM Products" UpdateCommand="UPDATE Products SET Title=@Title, InTheaters=@InTheaters WHERE Id=@Id" Runat="server" />
</form>
</body> </html> File: Web.config <configuration>
<connectionStrings> <add name="Products" connectionString="Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDirectory|MyDatabase.mdf;Integrated Security=True;User Instance=True" /> </connectionStrings>
</configuration></source>