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

Here I have explained how to populate GridView from SqlDataSource.

Connection String

The following connection string has been set in the ConnectionStrings section of the Web.Config file.

<connectionStrings>
   <add name="constr" connectionString="Data Source=.\SQL2008;Initial Catalog=myschool;Integrated Security=true" />
</connectionStrings>

Html Markup

<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" AutoGenerateColumns="false">
    <Columns>
        <asp:BoundField DataField="CustomerId" HeaderText="Customer Id" />
        <asp:BoundField DataField="ContactName" HeaderText="Contact Name" />
        <asp:BoundField DataField="Country" HeaderText="Country" /> </Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:constr %>" SelectCommand="SELECT TOP 10 * FROM Customers"></asp:SqlDataSource>