GridView example: how to use GridView in asp.net



  1. <%@ Page Language="C#" %>  
  2.   
  3. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">  
  4.   
  5. <script runat="server">  
  6.   
  7. </script>  
  8.   
  9. <html xmlns="http://www.w3.org/1999/xhtml">  
  10. <head runat="server">  
  11.     <title>GridView example: how to use GridView in asp.net</title>  
  12. </head>  
  13. <body>  
  14.     <form id="form1" runat="server">  
  15.     <div>  
  16.       
  17.         <asp:GridView ID="GridView1" runat="server" AllowPaging="True"   
  18.             AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="CustomerID"   
  19.             DataSourceID="SqlDataSource1">  
  20.             <Columns>  
  21.                 <asp:BoundField DataField="CustomerID" HeaderText="CustomerID" ReadOnly="True"   
  22.                     SortExpression="CustomerID" />  
  23.                 <asp:BoundField DataField="CompanyName" HeaderText="CompanyName"   
  24.                     SortExpression="CompanyName" />  
  25.                 <asp:BoundField DataField="ContactName" HeaderText="ContactName"   
  26.                     SortExpression="ContactName" />  
  27.                 <asp:BoundField DataField="ContactTitle" HeaderText="ContactTitle"   
  28.                     SortExpression="ContactTitle" />  
  29.                 <asp:BoundField DataField="Address" HeaderText="Address"   
  30.                     SortExpression="Address" />  
  31.                 <asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />  
  32.                 <asp:BoundField DataField="Region" HeaderText="Region"   
  33.                     SortExpression="Region" />  
  34.                 <asp:BoundField DataField="PostalCode" HeaderText="PostalCode"   
  35.                     SortExpression="PostalCode" />  
  36.                 <asp:BoundField DataField="Country" HeaderText="Country"   
  37.                     SortExpression="Country" />  
  38.                 <asp:BoundField DataField="Phone" HeaderText="Phone" SortExpression="Phone" />  
  39.                 <asp:BoundField DataField="Fax" HeaderText="Fax" SortExpression="Fax" />  
  40.             </Columns>  
  41.         </asp:GridView>  
  42.         <asp:SqlDataSource ID="SqlDataSource1" runat="server"   
  43.             ConnectionString="<%$ ConnectionStrings:AppConnectionString1 %>"   
  44.             SelectCommand="SELECT * FROM [Customers]"></asp:SqlDataSource>  
  45.       
  46.     </div>  
  47.     </form>  
  48. </body>  
  49. </html>  
Your Ad Here
Source:asp-net-example

Comments

Post a Comment