Solved

coloring gridview rows dynamically

Posted on 2014-11-05
3
248 Views
Last Modified: 2014-12-01
Hi,

In my gridview I want to color in green the rows for which the fielddate value is today and in orange the rows for which the fielddate value is tomorrow and later. The problem is that the following code works fine when binding the gridview because the code can find the label "lblDel" but fail when I edit the gridview because it can't find the the textbox "txtDel".

If I change the label by the text box them the gridview binding will fail.

Any idea how to code this?

Here is part of my code:

<asp:TemplateField SortExpression="DeliveryDate">
<ItemStyle wrap="false" Width="350px" />
<HeaderTemplate><asp:LinkButton ID="LinkButton5" runat="server" Text="DeliveryDate" CommandName="sort" CommandArgument="DeliveryDate"  /></HeaderTemplate>
<ItemStyle HorizontalAlign="left" Wrap="false"></ItemStyle>
<ItemTemplate><asp:Label ID="lblDel" Text='<%#Eval("DeliveryDate","{0:dd/mm/yyyy}")%>' runat="server" Width="150px" /></ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtDel" Text='<%# Bind("DeliveryDate","{0:dd/mm/yyyy}") %>' runat="server" width="150px" />
</EditItemTemplate>
</asp:TemplateField>

 Sub GridOrders_RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs)
        '///coloring the rows//////
        For Each row As GridViewRow In GridOrders.Rows  'Loop through the row of the gridview
            Dim strCurrentDate As String = CType(DateAndTime.Today().ToString, Date).Date 'Declare the current date
            'Get the date from the gridview row and convert to date type
            Dim lblDelDate As Date = CDate(CType(row.FindControl("lblDel"), Label).Text.ToString).Date
            'Dim txtDelDate As Date = CDate(CType(row.FindControl("txtDel"), TextBox).Text.ToString).Date

            If lblDelDate = strCurrentDate Then
                row.BackColor = Drawing.Color.Green
            Else
                row.BackColor = Drawing.Color.Orange
            End If
        Next
End Sub
0
Comment
Question by:pascalmartin
3 Comments
 
LVL 16

Expert Comment

by:Kamal Khaleefa
ID: 40425620
try to add event rowEditing and to but ur code there
0
 

Author Comment

by:pascalmartin
ID: 40425656
I got an error message of object not found
0
 
LVL 14

Accepted Solution

by:
CtrlAltDl earned 500 total points
ID: 40448442
You don't need to  loop trough each row since RowDataBound is called after each row.

Use e.Row.RowType to check if it is a data row and not a header or footer.  Use e.Row.RowState to see if the gridview is in edit mode.

 Sub GridOrders_RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs)
        '///coloring the rows//////
        //Check if it is a data row and not a header/footer and check if it is in the Edit mode
        If e.Row.RowType = DataControlRowType.DataRow And e.Row.RowState <> DataControlRowState.Edit Then
            Dim strCurrentDate As String = CType(DateAndTime.Today().ToString, Date).Date 'Declare the current date
            'Get the date from the gridview row and convert to date type
            Dim lblDelDate As Date = CDate(CType(row.FindControl("lblDel"), Label).Text.ToString).Date
            'Dim txtDelDate As Date = CDate(CType(row.FindControl("txtDel"), TextBox).Text.ToString).Date

            If lblDelDate = strCurrentDate Then
                row.BackColor = Drawing.Color.Green
            Else
                row.BackColor = Drawing.Color.Orange
            End If
        End If
End Sub 

Open in new window

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The goal of the video will be to teach the user the concept of local variables and scope. An example of a locally defined variable will be given as well as an explanation of what scope is in C++. The local variable and concept of scope will be relat…

943 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

5 Experts available now in Live!

Get 1:1 Help Now