ASP.Net/ADO.net Database/FormView

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

Basic FormView

<%@ Page Language="C#" AutoEventWireup="true"%>
<!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 runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
        <asp:SqlDataSource ID="sourceEmployees" 
                           runat="server" 
                           ConnectionString="<%$ ConnectionStrings:Northwind %>"
                           ProviderName="System.Data.SqlClient" 
                           SelectCommand="SELECT * FROM Employees"/>
        <asp:FormView ID="FormView1" runat="server" DataSourceID="sourceEmployees">
                  <ItemTemplate>
                    <%# Eval("EmployeeID") %> - 
                    <%# Eval("TitleOfCourtesy") %> <%# Eval("FirstName") %>
                    <%# Eval("LastName") %>
                    <%# Eval("Address") %><br />
                    <%# Eval("City") %>, <%# Eval("Country") %>,
                    <%# Eval("PostalCode") %><br />
                    <%# Eval("HomePhone") %>
                    <%# Eval("Notes") %>
                  </ItemTemplate>
        </asp:FormView>
    </form>
</body>
</html>
File: Web.config
<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.ru/.NetConfiguration/v2.0">
  <appSettings/>
      <connectionStrings>
        <add name="Northwind" connectionString="Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI"/>
      </connectionStrings>
</configuration>



ItemTemplate in FormView

<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
  <title>Edit FormView</title>
</head>
<body>
  <form id="form1" runat="server">
    <div id="container">
      Book Details
          <asp:FormView ID="frmvBooks" runat="server" DataSourceID="dsBooks" 
               AllowPaging="true" DataKeyNames="Isbn">
           <ItemTemplate>
             ISBN: <br />
             <asp:Label ID="labIsbn" runat="server"
               Text="<%# Eval("ISBN") %>" /><br />
             Title:<br />
             <asp:Label ID="labTitle" runat="server"
               Text="<%# Eval("Title") %>" /><br />
             Publisher:<br />
             <asp:Label ID="labPublisher" runat="server"
               Text="<%# Eval("PublisherName") %>" /><br />
             Year:<br />
              <asp:Label ID="labYear" runat="server"
               Text="<%# Eval("YearPublished") %>" /><br />
             Description:<br />
              <asp:Label ID="txtDecs" runat="server"
               Text="<%# Eval("BriefDescription") %>" /><br/>             
             </div>
           </ItemTemplate>
            <EmptyDataTemplate>
               No book matched this ISBN
            </EmptyDataTemplate>
           
            
            <PagerStyle CssClass="singleBookTitle" />
            <PagerSettings Mode="NextPreviousFirstLast" 
               FirstPageImageUrl="images/page_first.gif"
               LastPageImageUrl="images/page_last.gif"
               NextPageImageUrl="images/page_next.gif"
               PreviousPageImageUrl="images/page_previous.gif"/>
         </asp:FormView>
    </div>
      <asp:SqlDataSource ID="dsBooks" runat="server"
         ProviderName="System.Data.OleDb" 
         ConnectionString="<%$ ConnectionStrings:Books %>"
         SelectCommand="SELECT ISBN,Title,PublisherName,Books.PublisherId,YearPublished,BriefDescription FROM Books INNER JOIN Publishers ON Books.PublisherId=Publishers.PublisherId WHERE ISBN=@isbn">
         <SelectParameters>
            <asp:QueryStringParameter Name="isbn" QueryStringField="id" />
         </SelectParameters>       
         
      </asp:SqlDataSource>
                   
  </form>
</body>
</html>



Using a FormView control to display and edit data

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:FormView ID="FormView1" Runat="server" DataSourceID="SqlDataSource1"
             DataKeyNames="CustomerID" AllowPaging="True">
            <EditItemTemplate>
                CustomerID:
                <asp:Label Text="<%# Eval("CustomerID") %>" Runat="server"
                     ID="CustomerIDLabel1">
                </asp:Label><br />
                CompanyName:
                <asp:TextBox Text="<%# Bind("CompanyName") %>" Runat="server"
                     ID="CompanyNameTextBox"></asp:TextBox><br />
                ContactName:
                <asp:TextBox Text="<%# Bind("ContactName") %>" Runat="server"
                     ID="ContactNameTextBox"></asp:TextBox><br />
                ContactTitle:
                <asp:TextBox Text="<%# Bind("ContactTitle") %>" Runat="server"
                    ID="ContactTitleTextBox"></asp:TextBox><br />
                Address:
                <asp:TextBox Text="<%# Bind("Address") %>" Runat="server"
                     ID="AddressTextBox"></asp:TextBox><br />
                City:
                <asp:TextBox Text="<%# Bind("City") %>" Runat="server"
                     ID="CityTextBox"></asp:TextBox><br />
                Region:
                <asp:TextBox Text="<%# Bind("Region") %>" Runat="server"
                     ID="RegionTextBox"></asp:TextBox><br />
                PostalCode:
                <asp:TextBox Text="<%# Bind("PostalCode") %>" Runat="server"
                     ID="PostalCodeTextBox"></asp:TextBox><br />
                Country:
                <asp:TextBox Text="<%# Bind("Country") %>" Runat="server"
                     ID="CountryTextBox"></asp:TextBox><br />
                Phone:
                <asp:TextBox Text="<%# Bind("Phone") %>" Runat="server"
                     ID="PhoneTextBox"></asp:TextBox><br />
                Fax:
                <asp:TextBox Text="<%# Bind("Fax") %>" Runat="server"
                     ID="FaxTextBox"></asp:TextBox><br />
                <br />
                <asp:Button ID="Button2" Runat="server" Text="Update"
                     CommandName="update" />
                <asp:Button ID="Button3" Runat="server" Text="Cancel"
                     CommandName="cancel" />
            </EditItemTemplate>
            <ItemTemplate>
              CustomerID:<asp:Label ID="CustomerIDLabel" Runat="server"
                                 Text="<%# Bind("CustomerID") %>">
                                 </asp:Label>
              CompanyName:<asp:Label ID="CompanyNameLabel" Runat="server"
                                 Text="<%# Bind("CompanyName") %>">
                                 </asp:Label>
              ContactName:<asp:Label ID="ContactNameLabel" Runat="server"
                                 Text="<%# Bind("ContactName") %>">
                                 </asp:Label><br />
              ContactTitle:<asp:Label ID="ContactTitleLabel" Runat="server"
                                 Text="<%# Bind("ContactTitle") %>">
                                 </asp:Label><br />
               <asp:Label ID="AddressLabel" Runat="server"
                                             Text="<%# Bind("Address") %>">
                                             </asp:Label></td>
               <asp:Label ID="CityLabel" Runat="server"
                                             Text="<%# Bind("City") %>">
                                             </asp:Label></td>
               <asp:Label ID="RegionLabel" Runat="server"
                                             Text="<%# Bind("Region") %>">
                                             </asp:Label></td>
               <asp:Label ID="PostalCodeLabel"
                                            Runat="server" 
                                            Text="<%# Bind("PostalCode") %>">
                                            </asp:Label>
               <asp:Label ID="CountryLabel" Runat="server"
                                             Text="<%# Bind("Country") %>">
                                             </asp:Label></td>
               Phone:<asp:Label ID="PhoneLabel" Runat="server" 
                                                   Text="<%# Bind("Phone") %>">
                                                   </asp:Label><br />
               Fax:<asp:Label ID="FaxLabel" Runat="server"
                                             Text="<%# Bind("Fax") %>">
                                             </asp:Label><br />
               <asp:Button ID="Button1" Runat="server"
                                 Text="Edit" CommandName="edit" />
            </ItemTemplate>
        </asp:FormView>
        <asp:SqlDataSource ID="SqlDataSource1" Runat="server" 
             SelectCommand="SELECT * FROM [Customers]"
             ConnectionString="<%$ ConnectionStrings:AppConnectionString1 %>">
        </asp:SqlDataSource>
    
    </div>
    </form>
</body>
</html>
File: Web.config
<configuration>
  <appSettings/>
  <connectionStrings>
        <add name="AppConnectionString1" 
             connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True"
             providerName="System.Data.SqlClient" />
    </connectionStrings>
  <system.web>
    <compilation debug="true" strict="false" explicit="true">
      <codeSubDirectories>
        <add directoryName="VB"></add>
        <add directoryName="CS"></add>
      </codeSubDirectories>
    </compilation>
    <pages>
      <namespaces>
        <clear/>
        <add namespace="System"/>
        <add namespace="System.Collections"/>
        <add namespace="System.Collections.Specialized"/>
        <add namespace="System.Configuration"/>
        <add namespace="System.Text"/>
        <add namespace="System.Text.RegularExpressions"/>
        <add namespace="System.Web"/>
        <add namespace="System.Web.Caching"/>
        <add namespace="System.Web.SessionState"/>
        <add namespace="System.Web.Security"/>
        <add namespace="System.Web.Profile"/>
        <add namespace="System.Web.UI"/>
        <add namespace="System.Web.UI.WebControls"/>
        <add namespace="System.Web.UI.WebControls.WebParts"/>
        <add namespace="System.Web.UI.HtmlControls"/>
      </namespaces>
    </pages>
    <authentication mode="Windows"></authentication>
    <identity impersonate="true"/>
  </system.web>
</configuration>
Источник — «http://nfex.ru/index.php?title=ASP.Net/ADO.net_Database/FormView&oldid=1687»