Solved

coloring gridview rows dynamically

Posted on 2014-11-05
3
254 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

How to remove superseded packages in windows w60 or w61 installation media (.wim) or online system to prevent unnecessary space. w60 means Windows Vista or Windows Server 2008. w61 means Windows 7 or Windows Server 2008 R2. There are various …
The purpose of this article is to demonstrate how we can use conditional statements using Python.
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.
The viewer will learn how to clear a vector as well as how to detect empty vectors in C++.

726 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