Post
Ask Question

Populate (Bind) GridView Control using SqlDataSource in ASP.NET

Connection String

The following connection string has been set in the ConnectionStrings section of the Web.Config file. 
  1. <connectionStrings>  
  2.    <add name="constr" connectionString="Data Source=.\SQL2008;Initial Catalog=myschool;Integrated Security=true" />  
  3. </connectionStrings>  
Html Markup 
  1. <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" AutoGenerateColumns="false">  
  2.     <Columns>  
  3.         <asp:BoundField DataField="CustomerId" HeaderText="Customer Id" />  
  4.         <asp:BoundField DataField="ContactName" HeaderText="Contact Name" />  
  5.         <asp:BoundField DataField="Country" HeaderText="Country" /> </Columns>  
  6. </asp:GridView>  
  7. <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:constr %>" SelectCommand="SELECT TOP 10 * FROM Customers"></asp:SqlDataSource>