ASP.NET

RowDataBound in GridView in ASP.NET

Initial Chamber

Step 1: Open Visual Studio 2010 and create an empty website, give it a suitable name (DataList_demo).

Step 2: In Solution Explorer, you will get your empty website, add a web form, SQL Database and proceed as in the following.

For Web Form

Gridviewrow_demo (your empty website): Right-click, Add New Item, then select Web Form and name it gridview_demo.aspx.

For SQL Server Database:

gridview_demo (your empty website): Right-click, Add New Item, then select SQL Server Database (add a database inside the App_Data_folder).

Database Chamber

Step 3: In Server Explorer, click on your database (Database.mdf), then Tables and Add New Table. Create the table as in the following.

Table: tbl_std (Don't forget to make ID as IS Identity : True.)

Table

Add some values to the database by going as in the following: Database.mdf, Tables, then go to tbl_std and right-click to show the table data. Now, add some data to the database.

Design Chamber

Step 4: Open your design page (aspx page), gridview_demo.aspx and write the following code:

  1. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>  
  2.   
  3. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">  
  4.   
  5. <html xmlns="http://www.w3.org/1999/xhtml">  
  6. <head runat="server">  
  7.     <title></title>  
  8.   
  9.     
  10.     <style type="text/css">  
  11.         .style1  
  12.         {  
  13.             width: 268px;  
  14.         }  
  15.         .style2  
  16.         {  
  17.             text-decoration: underline;  
  18.             font-size: x-large;  
  19.         }  
  20.         .style3  
  21.         {  
  22.             width: 345px;  
  23.         }  
  24.         .style4  
  25.         {  
  26.             text-align: left;  
  27.         }  
  28.     </style>  
  29.   
  30.     
  31. </head>  
  32. <body>  
  33.     <form id="form1" runat="server">  
  34.     <div>  
  35.   
  36.     <div>  
  37.       
  38.         <br />  
  39.         <br />  
  40.     </div>  
  41.     </div>  
  42.     <p>  
  43.          </p>  
  44.     <table style="width:100%;">  
  45.         <caption class="style4">  
  46.             <span class="style2"><strong>RowdataBound in Gridview</strong></span><br />  
  47.         </caption>  
  48.         <tr>  
  49.             <td class="style1">  
  50.                  </td>  
  51.             <td class="style3">  
  52.                  </td>  
  53.             <td>  
  54.                  </td>  
  55.         </tr>  
  56.         <tr>  
  57.             <td class="style1">  
  58.       
  59.         <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"   
  60.             BackColor="White" BorderColor="White" BorderStyle="Ridge" BorderWidth="2px"   
  61.             CellPadding="3" CellSpacing="1" GridLines="None"   
  62.             onrowdatabound="GridView1_RowDataBound1">  
  63.             <Columns>  
  64.                 <asp:BoundField DataField="id" HeaderText="Std_id" />  
  65.                 <asp:BoundField DataField="stdname" HeaderText="Student name" />  
  66.                 <asp:BoundField DataField="stdsubject" HeaderText="Subject" />  
  67.                 <asp:BoundField DataField="result" HeaderText="Result" />  
  68.             </Columns>  
  69.             <FooterStyle BackColor="#C6C3C6" ForeColor="Black" />  
  70.             <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#E7E7FF" />  
  71.             <PagerStyle BackColor="#C6C3C6" ForeColor="Black" HorizontalAlign="Right" />  
  72.             <RowStyle BackColor="#DEDFDE" ForeColor="Black" />  
  73.             <SelectedRowStyle BackColor="#9471DE" Font-Bold="True" ForeColor="White" />  
  74.             <SortedAscendingCellStyle BackColor="#F1F1F1" />  
  75.             <SortedAscendingHeaderStyle BackColor="#594B9C" />  
  76.             <SortedDescendingCellStyle BackColor="#CAC9C9" />  
  77.             <SortedDescendingHeaderStyle BackColor="#33276A" />  
  78.         </asp:GridView>  
  79.       
  80.             </td>  
  81.             <td class="style3">  
  82.                  </td>  
  83.             <td>  
  84.                  </td>  
  85.         </tr>  
  86.         <tr>  
  87.             <td class="style1">  
  88.                  </td>  
  89.             <td class="style3">  
  90.                  </td>  
  91.             <td>  
  92.                  </td>  
  93.         </tr>  
  94.     </table>  
  95.     </form>  
  96.     </body>  
  97. </html>  
You can even manually add this thing by going to your GridView in design mode. Now clicking on the arrow sign of the GridView, it will open your template option window where you need to add the column that you want to show in the GridView. Make a column in the GridView by going to the Template window, then Available fields, select 3 bound fields and add them.

Add

Name the bound fields by going to Bound Fields Properties, then Header Text and name it as in the following:

Bound Fields Header Text Data Fields
Std_id Std_id id
Student Name Student Name stdname
Subject Subject stdsubject
Result Result result

Header Text

Add all these things and uncheck the Auto Generate Fields. Now after pressing OK, you can see the design as in the following:

Auto Generate Fields

Code Chamber:

Step 5: Open your gridview_demo.aspx.cs page. Here we will code to get a result less than 35 that will make the color Red and otherwise Blue.

First add some namespaces to the page.

Add some Namespace to the page

Here is the code for your application:

  1. using System;  
  2. using System.Collections.Generic;  
  3. using System.Linq;  
  4. using System.Web;  
  5. using System.Web.UI;  
  6. using System.Web.UI.WebControls;  
  7. using System.Data;  
  8. using System.Data.SqlClient;  
  9.   
  10. public partial class _Default : System.Web.UI.Page  
  11. {  
  12.     protected void Page_Load(object sender, EventArgs e)  
  13.     {  
  14.         if (!Page.IsPostBack)  
  15.         {  
  16.             refreshdata();  
  17.         }  
  18.   
  19.     }  
  20.   
  21.     public void refreshdata()  
  22.     {  
  23.   
  24.         SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True");  
  25.         SqlCommand cmd = new SqlCommand("select * from tbl_std", con);  
  26.         SqlDataAdapter sda = new SqlDataAdapter(cmd);  
  27.         DataTable dt = new DataTable();  
  28.         sda.Fill(dt);  
  29.         GridView1.DataSource = dt;  
  30.         GridView1.DataBind();  
  31.   
  32.   
  33.   
  34.   
  35.     }  
  36.      
  37.     protected void GridView1_RowDataBound1(object sender, GridViewRowEventArgs e)  
  38.     {  
  39.         try  
  40.         {  
  41.             if (e.Row.RowType == DataControlRowType.DataRow)  
  42.             {  
  43.                 int result;  
  44.                 if (int.TryParse(e.Row.Cells[3].Text, out result))  
  45.                 {  
  46.                     if (result < 35)  
  47.                         e.Row.Cells[3].ForeColor = System.Drawing.Color.Red;  
  48.                     else  
  49.                         e.Row.Cells[3].ForeColor = System.Drawing.Color.Navy;  
  50.                 }  
  51.             }  
  52.         }  
  53.         catch  
  54.         {  
  55.   
  56.         }  
  57.     }  
  58. }  
Output Chamber
Output

I hope you liked it. Thank you for reading. Have a good day!

Up Next
    Ebook Download
    View all
    Learn
    View all
    Get Started

    You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.

    Become a sharper developer and jumpstart your career.

    Basic

    $0

    $

    . 00

    monthly

    For Basic members:

    • Standard Profile
    • Access learning courses
    • Access free e-books
    • 1x point
    Premium

    $20

    $

    . 00

    monthly

    For Premium members:

    • Earn 2x reward points
    • Premium profile with Verified check
    • Premium Avatar with status update
    • Learning courses
    • Unlimited Certifications and badges on profile
    • Unlimited Book downloads
    • Access to Premium content
    • Online Training
    • Unlimited PDF conversions and downloads
    • Professional Resume Writing
    • Interview Preparations Guide
    • 25 messages per month
    • 1 "Kodzu" avatar, basic
    Elite

    $45

    $

    . 00

    monthly

    For Elite members:

    • Bundle E-books
    • Access to all Learn Series
    • Unlimited Apply Jobs