Highlight Rows : GridView « ADO.net Database « ASP.Net

Highlight Rows


<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<script runat="server">
    protected void grdProducts_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            decimal totals = (decimal)DataBinder.Eval(e.Row.DataItem, "BoxOfficeTotals");
            if (totals > 30)
                e.Row.BackColor = System.Drawing.Color.Yellow;
        }
    }
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
    <title>Highlight Rows</title>
</head>
<body>
    <form id="form1" runat="server">
    <asp:GridView
        id="grdProducts"
        DataSourceID="srcProducts"
        OnRowDataBound="grdProducts_RowDataBound"
        AutoGenerateColumns="false"
        Runat="server">
        <Columns>
        <asp:BoundField
            DataField="Title"
            HeaderText="Title" />
        <asp:BoundField
            DataField="BoxOfficeTotals"
            DataFormatString="{0:c}"
            HtmlEncode="false"
            HeaderText="Box Office Totals" />
        </Columns>
    </asp:GridView>

    <asp:SqlDataSource
        id="srcProducts"
        ConnectionString="<%$ ConnectionStrings:Products %>"
        SelectCommand="SELECT * FROM Products"
        Runat="server" />
    </form>
</body>
</html>

File: Web.config

<configuration>
  <connectionStrings>
    <add name="Products" 
         connectionString="Data Source=.\SQLEXPRESS;
         AttachDbFilename=|DataDirectory|MyDatabase.mdf;Integrated Security=True;User Instance=True" />
  </connectionStrings>
</configuration>

Related examples in the same category

1.	Displaying data in database table with the GridView control.
2.	The GridView control supports programmatic databinding
3.	Selecting Data
4.	Using Data Keys
5.	Paging Through Data
6.	Sortable GridView
7.	Change row style for higher value
8.	Numeric Format Strings
9.	Time and Date Format Strings
10.	GridView custom paging with ObjectDataSource
11.	GridView format event
12.	Turn off the GridLine
13.	GridView selection style
14.	GridView Summaries
15.	Using the RowDeleted event to catch SQL errors (C#)
16.	Using the RowDeleted event to catch SQL errors (VB)
17.	Adding a delete link to the GridView
18.	Checking for Update errors using the RowUpdated event (C#)
19.	Checking for Update errors using the RowUpdated event (VB)
20.	Turning off AutoGenerateColumns in the GridView control
21.	Using the RowCreated Event to programmatically change the style
22.	Adding Indicators to display Sorting Direction