ADO Database ASP.Net


            <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="FormatHighPrices" %>



    Untitled Page


    
                                   runat="server" 
                           ConnectionString="<%$ ConnectionStrings:Northwind %>"
            SelectCommand="SELECT ProductID, ProductName, UnitPrice FROM Products">
        
                              runat="server" 
                      AutoGenerateColumns="False" 
                      DataSourceID="SqlDataSource1"
                      OnRowDataBound="GridView1_RowDataBound">
            
                
                
                                                HtmlEncode="false" 
                                HeaderText="Price" 
                                DataFormatString="{0:C}" />
            
        
    


File: Default.aspx.cs
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class FormatHighPrices : System.Web.UI.Page
{
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            decimal price = (decimal)DataBinder.Eval(e.Row.DataItem, "UnitPrice");
            if (price > 50)
            {
                e.Row.BackColor = System.Drawing.Color.Maroon;
                e.Row.ForeColor = System.Drawing.Color.White;
                e.Row.Font.Bold = true;
            }
        }
    }
}
File: Web.config