Элементы-потребители данных ASP .NET 2.0

protected void GridView1_RowUpdating(Object sender, 
GridViewUpdateEventArgs e)
    {
        foreach (DictionaryEntry entry in e.NewValues)
        {
            if(entry.Value!=null)
            e.NewValues[entry.Key] = 
Server.HtmlEncode(entry.Value.ToString());
        }
    }

<asp:Label ID="ErrorLabel" runat="server" Text=" " Font-
Bold="True" ForeColor="Red"></asp:Label><br />

protected void GridView1_RowUpdated(object sender, 
GridViewUpdatedEventArgs e)
    {
        if (e.Exception != null)
        {
            ErrorLabel.Text = e.Exception.Message;
            e.ExceptionHandled = true;
        }
    }

protected void GridView1_RowDataBound(object sender, 
GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            switch ((int)((DataRowView)e.Row.DataItem)["CategoryID"])
            {
                case 1: e.Row.BackColor = Color.AliceBlue; break;
                case 2: e.Row.BackColor = Color.AntiqueWhite; break;
                case 3: e.Row.BackColor = Color.FloralWhite; break;
                case 4: e.Row.BackColor = Color.Beige; break;
                default:
                    e.Row.BackColor = Color.White; break;
            }
        }
    }

protected void GridView1_RowDataBound(object sender, 
GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        e.Row.Attributes["onmouseover"] = 
"this.style.backgroundColor='#FFE4B5'";
        e.Row.Attributes["onmouseout"] = 
"this.style.backgroundColor='#FFFFFF'";
    }
}

<asp:SqlDataSource ID="SqlDataSource2" runat="server" 
        ConnectionString="<%$ 
ConnectionStrings:NorthwindConnectionString %>" 
        SelectCommand="SELECT [CategoryID], [CategoryName] FROM 
[Categories] ORDER BY [CategoryName]">
    </asp:SqlDataSource>

<asp:TemplateField HeaderText="Категория" 
SortExpression="CategoryID">
    <EditItemTemplate>
        <asp:DropDownList  ID="CatDropDownList" runat="server" 
            DataSourceID="SqlDataSource2" 
DataValueField="CategoryId" 
            DataTextField="CategoryName" SelectedValue=<%# 
Bind("CategoryId") %>>
        </asp:DropDownList >
    </EditItemTemplate>
    <ItemTemplate>
        <asp:Label ID="CatLabel" runat="server" ></asp:Label>
    </ItemTemplate>
</asp:TemplateField>

protected void GridView1_RowDataBound(object sender, 
GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    if (e.Row.RowState == DataControlRowState.Normal ||
        e.Row.RowState == DataControlRowState.Alternate)
    {
        // получить данные из SqlDataSource2
        DataView ds = 
(DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty);
        // получить значение текущей категории
        DataRowView view = (DataRowView)e.Row.DataItem;
        int catid = (int)view.Row[3];
        // отфильтровать нужную категорию
        ds.RowFilter = string.Format("CategoryID='{0}'", catid);
        Label Text1 = (Label)e.Row.FindControl("CatLabel");
        Text1.Text = ds[0].Row["CategoryName"].ToString();
     }
}