Data Binding ASP.Net Tutorial

  1. Home
  2. ASP.Net Tutorial
  3. Data Binding
  4. Sortable GridView
<%@ Page Language="VB" AutoEventWireup="false" %>


    Untitled Page


    
    

                                   runat="server" 
                           ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
            SelectCommand="SELECT * FROM [Books]">
    
    

                              runat="server" 
                      AllowSorting="True" 
                      AutoGenerateColumns="False"
                      BackColor="White" 
                      BorderColor="#DEDFDE" 
                      BorderStyle="None" 
                      BorderWidth="1px"
                      CellPadding="4" 
                      DataKeyNames="BookID" 
                      DataSourceID="SqlDataSource1" 
                      ForeColor="Black"
                      GridLines="Vertical">
            
            
                                    SortExpression="BookID" />
                
                
                
                
                
                
            
            
            
            
            
            
        
    


File: Web.config


  
             connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MyFirstDatabase.mdf;Integrated Security=True;User Instance=True"
         providerName="System.Data.SqlClient" />