Using GridView in ASP.NET & C# — PART 1

GridView displays the values of a data source in a table where each column represents a field and each row represents a record. The GridView control enables you to select, sort, and edit these items. In this article I would discuss some basic scenarios using GridView.

Example 1: Bind the Gridview with DataSet

Step 1: Create a new ASP.NET Web Application in Visual Studio

Step 2: I am using AdventureWorks for my samples. Open web.config and add following entry to connection strings element

<add name="Sql" connectionString="Data Source=<SERVERNAME>;
     Initial Catalog= AdventureWorks;User=testuser;Password=testuser;" 
     providerName="System.Data.SqlClient"/> 

Step 3: Open aspx file in design mode and add the following in div tag

<asp:gridview id="gvProducts"          
          autogeneratecolumns="False"
          emptydatatext="No data available."           
          runat="server" DataKeyNames="ProductID">
   <Columns>
     <asp:BoundField DataField="ProductID" HeaderText="Product ID"/>
     <asp:BoundField DataField="Name" HeaderText="Product Name" />         
     <asp:BoundField DataField="ProductNumber" HeaderText="Product Number" />    
     <asp:BoundField HeaderText="Price" 
                  DataField="ListPrice"
                  DataFormatString="{0:c}">
          <ItemStyle HorizontalAlign="Right"></ItemStyle>
     </asp:BoundField>                 
   </Columns>
</asp:gridview>

Step 4: Open Default.aspx.cs and add the following code in the page_load function

//fetch the connection string from web.config
string connString = ConfigurationManager.ConnectionStrings["Sql"].ConnectionString;

//SQL statement to fetch 10 entries from product category
string sql = @"Select top 10  P.ProductID, P.Name, 
            P.ProductNumber, ListPrice from Production.Product P
            where ProductSubcategoryID is not null";

DataSet dsResults = new DataSet();
//Open SQL Connection
using (SqlConnection conn = new SqlConnection(connString)) 
{ 
    conn.Open(); 
    //Initialize command object
    using (SqlCommand cmd = new SqlCommand(sql, conn))
    {
        SqlDataAdapter adapter = new SqlDataAdapter(cmd);
        //Fill the result set
        adapter.Fill(dsResults);
    }
}
//Bind the grid view
gvProducts.DataSource = dsResults;
gvProducts.DataBind();

Step 5: Run the application

Output:

Example 2: Bind the GridView with SQL DataReader

Step 1: Repeat Steps 1 to Step 3 from “Bind the Gridview with DataSet” section

Step 2: Open Default.aspx.cs and add the following code in the page_load function

//fetch the connection string from web.config
string connString = ConfigurationManager.ConnectionStrings["Sql"].ConnectionString;
//SQL statement to fetch 10 entries from product category
string sql = @"Select top 10  P.ProductID, P.Name, 
            P.ProductNumber, ListPrice from Production.Product P
            where ProductSubcategoryID is not null";
SqlDataReader reader = null;
//Open SQL Connection
using (SqlConnection conn = new SqlConnection(connString)) 
{ 
    conn.Open(); 
    //Initialize command object
    using (SqlCommand cmd = new SqlCommand(sql, conn))
    {
        reader = cmd.ExecuteReader();        
        //Bind the grid view
        gvProducts.DataSource = reader;
        gvProducts.DataBind();    }
}

Step 3: Run the application.

Output

Be Sociable, Share!

•