gistfile1.txt

<asp:GridView ID="GridView1" runat="server" AllowPaging="True"   
            AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="CustomerID"   
            DataSourceID="SqlDataSource1">  
            <Columns>  
                <asp:BoundField DataField="CustomerID" HeaderText="CustomerID" ReadOnly="True"   
                    SortExpression="CustomerID" />  
                <asp:BoundField DataField="CompanyName" HeaderText="CompanyName"   
                    SortExpression="CompanyName" />  
                <asp:BoundField DataField="ContactName" HeaderText="ContactName"   
                    SortExpression="ContactName" />  
                <asp:BoundField DataField="ContactTitle" HeaderText="ContactTitle"   
                    SortExpression="ContactTitle" />  
                <asp:BoundField DataField="Address" HeaderText="Address"   
                    SortExpression="Address" />  
                <asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />  
                <asp:BoundField DataField="Region" HeaderText="Region"   
                    SortExpression="Region" />  
                <asp:BoundField DataField="PostalCode" HeaderText="PostalCode"   
                    SortExpression="PostalCode" />  
                <asp:BoundField DataField="Country" HeaderText="Country"   
                    SortExpression="Country" />  
                <asp:BoundField DataField="Phone" HeaderText="Phone" SortExpression="Phone" />  
                <asp:BoundField DataField="Fax" HeaderText="Fax" SortExpression="Fax" />  
            </Columns>  
        </asp:GridView>  
        <asp:SqlDataSource ID="SqlDataSource1" runat="server"   
            ConnectionString="<%$ ConnectionStrings:AppConnectionString1 %>"   
            SelectCommand="SELECT * FROM [Customers]"></asp:SqlDataSource>