Mega Code Archive

 
Categories / ASP.Net Tutorial / Data Binding
 

Pageable asp

<%@ Page Language="VB" AutoEventWireup="false"%> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server">     <title>Untitled Page</title> </head> <body>     <form id="form1" runat="server">     <div>         <asp:SqlDataSource ID="SqlDataSource1"                             runat="server"                             ConnectionString="<%$ ConnectionStrings:ConnectionString %>"             SelectCommand="SELECT * FROM [Books]"></asp:SqlDataSource>          </div>         <asp:GridView ID="GridView1"                        runat="server"                        AllowPaging="True"                        BackColor="White"                       BorderColor="#DEDFDE"                        BorderStyle="None"                        BorderWidth="1px"                        CellPadding="4"                        DataSourceID="SqlDataSource1"                       ForeColor="Black"                        GridLines="Vertical"                        PageSize="2">             <FooterStyle BackColor="#CCCC99" />             <RowStyle BackColor="#F7F7DE" />             <SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />             <PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" />             <HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />             <AlternatingRowStyle BackColor="White" />         </asp:GridView>     </form> </body> </html> File: Web.config <?xml version="1.0"?> <configuration>     <connectionStrings>         <add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MyFirstDatabase.mdf;Integrated Security=True;User Instance=True"             providerName="System.Data.SqlClient" />     </connectionStrings> </configuration>