ASP.NET Tutorial/Data Binding/CheckBoxField

Материал из .Net Framework эксперт
Перейти к: навигация, поиск

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>