Change Background color of GridView Row using RowDataBound event in ASP.Net using C# and VB.Net

In this article I will explain how to dynamically change background color of GridView Row using RowDataBound event in ASP.Net using C# and VB.Net.

 

GridView HTML Markup

The following HTML markup consists of an ASP.Net GridView consisting of two BoundField columns.

<asp:GridView ID="GridView1" CssClass = "Grid" runat="server" AutoGenerateColumns="false" OnRowDataBound = "OnRowDataBound">

    <Columns>

        <asp:BoundField DataField="Item" HeaderText="Item"/>

        <asp:BoundField DataField="Quantity" HeaderText="Quantity"/>

    </Columns>

</asp:GridView>

 

 

Namespaces

You will need to import the following namespaces.

C#

using System.Data;

using System.Drawing;

 

VB.Net

Imports System.Data

Imports System.Drawing

 

 

Binding the ASP.Net GridView control

I have used a DataTable to bind the GridView with data in the following way.

C#

protected void Page_Load(object sender, EventArgs e)

{

    if (!IsPostBack)

    {

        DataTable dt = new DataTable();

        dt.Columns.AddRange(new DataColumn[2] { new DataColumn("Item"), new DataColumn("Quantity") });

        dt.Rows.Add("Shirt", 145);

        dt.Rows.Add("Jeans", 0);

        dt.Rows.Add("Trousers", 190);

        dt.Rows.Add("Tie", 30);

        dt.Rows.Add("Cap", 0);

        dt.Rows.Add("Hat", 90);

        dt.Rows.Add("Scarf", 290);

        dt.Rows.Add("Belt", 150);

        GridView1.DataSource = dt;

        GridView1.DataBind();

    }

}

 

VB.Net

Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load

    If Not IsPostBack Then

        Dim dt As New DataTable()

        dt.Columns.AddRange(New DataColumn(1) {New DataColumn("Item"), New DataColumn("Quantity")})

        dt.Rows.Add("Shirt", 145)

        dt.Rows.Add("Jeans", 0)

        dt.Rows.Add("Trousers", 190)

        dt.Rows.Add("Tie", 30)

        dt.Rows.Add("Cap", 0)

        dt.Rows.Add("Hat", 90)

        dt.Rows.Add("Scarf", 290)

        dt.Rows.Add("Belt", 150)

        GridView1.DataSource = dt

        GridView1.DataBind()

    End If

End Sub

 

 

Changing the Background color of GridView Row as per condition dynamically

Using the GridView OnRowDataBound event I am checking the different quantity ranges and based on the quantity values I am setting the background color of the GridView Row as per the following conditions.

Quantity Range	Background Color
0	RED
1 - 50	YELLOW
51 - 100	ORANGE

 

C#

protected void OnRowDataBound(object sender, GridViewRowEventArgs e)

{

    if (e.Row.RowType == DataControlRowType.DataRow)

    {

        int quantity = int.Parse(e.Row.Cells[1].Text);

 

        foreach (TableCell cell in e.Row.Cells)

        {

            if (quantity == 0)

            {

                cell.BackColor = Color.Red;

            }

            if (quantity > 0 && quantity <= 50)

            {

                cell.BackColor = Color.Yellow;

            }

            if (quantity > 50 && quantity <= 100)

            {

                cell.BackColor = Color.Orange;

            }

        }

    }

}

 

VB.Net

Protected Sub OnRowDataBound(sender As Object, e As GridViewRowEventArgs)

    If e.Row.RowType = DataControlRowType.DataRow Then

        Dim quantity As Integer = Integer.Parse(e.Row.Cells(1).Text)

 

        For Each cell As TableCell In e.Row.Cells

            If quantity = 0 Then

                cell.BackColor = Color.Red

            End If

            If quantity > 0 AndAlso quantity <= 50 Then

                cell.BackColor = Color.Yellow

            End If

            If quantity > 50 AndAlso quantity <= 100 Then

                cell.BackColor = Color.Orange

            End If

        Next

    End If

End Sub

 

 

Screenshot