How to change the background color of rows in a GridView in ASP.NET 3.5

</connectionStrings>

Note: It's a good practice to add your connection string in the Web.config file. I am using SQL Server 2005 Express edition. You can add your own connection string.

Step 3: Write code for the SQLDataSource in Default.aspx file

<asp:SqlDataSource
ID="sqlProduct"
runat="server"
ConnectionString="<%$ConnectionStrings:conString %>"
SelectCommand="SELECT ProductID, Name, ListPrice FROM
Production.Product WHERE ListPrice>0" />

Note: You can drag a SqlDataSource control from the ToolBox and configure its DataSource using Configure Data Source wizard.

Step 4: Write code for the GridView in Default.aspx file

<asp:GridView
ID="grdProduct"
runat="server"
DataSourceID="sqlProduct"
OnRowDataBound="grdProduct_RowDataBound">
</asp:GridView>

Note: You can drag a GridView and set its properties using Properties Dialog Box.

Step 5: Write code for the RowDataBound event of the GridView

protected void grdProduct_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Double ListPrice=Double.Parse(e.Row.Cells[2].Text);
if (ListPrice > 1000)
{
e.Row.BackColor = System.Drawing.Color.Red;
}
}
}

RowDataBound event of the GridView control fires every time a row is bound to data. So this is the best place to access row value before it is displayed in the GridView.

DataControlRowType.DataRow is used here to determine the type of row being bound. Other frequently used properties are Header, Footer and Pager.

Result:



Note: I am using AdventureWorks database. Which can be downloaded from here.