Need to create a custom gridview with different cell colors : VB

Hello,

You need to use RowDataBound event of your gridview and do something like that:

      protected void GridView1_RowDataBound( object sender, GridViewRowEventArgs e )
      {
            GridViewRow row = e.Row;

            if( row.RowType == DataControlRowType.DataRow )
            {
                  if( row.Cells[ 2 ].Text == "1" )
                        row.Cells[ 1 ].BackColor = Color.Green;

                  else if( row.Cells[ 2 ].Text == "0" )
                        row.Cells[ 1 ].BackColor = Color.Red;

                  else
                        row.Cells[ 1 ].BackColor = Color.Gray;

            }
      }

As for visible, not visible, just play with your "Edit Columns" settings for your GridView. You hide columns, you can set hyperlink columns to pass databound values etc. The GridView is quite flexible control ;)

Good luck,
Yurich

05.06.2008 at 08:21PM PDT, ID: 21512975

Rank: Master

I have to do something like this before. What you are going to do is pass a value that wil run a switch statement and return the proper color, here is an example

Inside a gridview:
<asp:TemplateField>
<ItemTemplate>
<div style="Background:<%# getColor(Eval("id")) %>;" >
<asp:Label runat="server" Text='<%# Eval("id") %>' />
</div>
</ItemTemplate>
</asp:TemplateField>

Notice getColor and the parameter that is passed (id is an integer)
And the function, this will make the cell red if the id is 1-5, blue if it anything else. I know that this is not exactly what you want, but it shows what you need to do. You can also use it will a classes or anything else.

                       
                                    Public Function getColor(ByVal input As Integer) As String
        Select Case input
            Case 1 To 5
                Return "Red"
            Case Else
                Return "Blue"
        End Select
    End Function

Open in New Window

05.06.2008 at 08:27PM PDT, ID: 21512991

Rank: Master

2 naspinski: doesn't look like a simplest way of doing it :\

05.06.2008 at 08:29PM PDT, ID: 21512999

Rank: Master

Just a different method, which I think is easier :)

05.06.2008 at 08:37PM PDT, ID: 21513032

Rank: Master

it's more original, that's for sure ;)

05.06.2008 at 09:01PM PDT, ID: 21513106

Sorry guys, I'm very new to asp.net can you provide a full set of code on how I would use your ideas? Also how could I replace the "_" in the column headers?
I attached my current gridview code.

I was thinking I would have to loop though both columns and rows building one at a time.

                       
                          
                             
                             
                                <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:CLLDdataSQLConnectionString %>" 
        SelectCommand="test2" SelectCommandType="StoredProcedure">
        <SelectParameters>
            <asp:Parameter DefaultValue="2" Name="ClientID" Type="Int32" />
            <asp:Parameter DefaultValue="container" Name="ShipmentType" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
    
        <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1">
        </asp:GridView>
    
    </div>
 
    </form>
</body>
</html>

                             
                          

                    

Open in New Window

05.06.2008 at 09:07PM PDT, ID: 21513121

Rank: Master

for mine, stick this into your gridview:

<asp:TemplateField>
<ItemTemplate>
<div style="Background:<%# getColor(Eval("holdArrival_Date")) %>;" >
<asp:Label runat="server" Text='<%# Eval("holdArrival_Date") %>' />
</div>
</ItemTemplate>
</asp:TemplateField>

and this in your code:

                       
                                    Public Function getColor(ByVal input As Integer) As String
        Select Case input
            Case 1
                Return "Red"
            Case 0
                Return "Green"
            Case Else
                Return String.Empty
        End Select
    End Function

Open in New Window

Accepted Solution

05.07.2008 at 12:50PM PDT, ID: 21519761

Yurich: I'm working with VB not C# and can not edit columns as the columns are different every time

naspinski: I tried what you said and it does not work (error is shown below). The second issued is that I can not declare the field "holdArrival_Date" as this need to work on many different columns. Please see the excel file attached at the beginning of this posting

Error: 'System.Web.UI.WebControls.GridView' does not have a public property named 'TemplateField'.

Need code that goes though the dataset, if there is a "HOLD" + field name then it changes the color of the field name background and removes the hold column. I have attached what the table should look like after the process.

SP-results.xls (17 KB) (File Type Details)

dataset results and finished look

05.07.2008 at 01:15PM PDT, ID: 21519989

Rank: Master

Quote: "Yurich: I'm working with VB not C# and can not edit columns as the columns are different every time" - that was funny :)

You can do in VB 95% if not even more of what you can do in C# and that simple exercise you can do for sure.

You columns can't be different every time - you're loading from the same database table, aren't you? And even if they're, you can use a column name, not an index.

I'll see if I can VB code for you to do it today...

Good luck,
Yurich

05.07.2008 at 04:47PM PDT, ID: 21521307

Rank: Master

Error: 'System.Web.UI.WebControls.GridView' does not have a public property named 'TemplateField'.

That is because it has to be embedded within 2 <Columns> tags:

<Gridview ... >
<Columns>
<ItemTemplate>
</ItemTemplate>
</Columns>
</Gridview>

05.07.2008 at 06:12PM PDT, ID: 21521642

Solution to the problem below

                       
                                    Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound
        If e.Row.RowType = DataControlRowType.DataRow Then
            For j = 0 To e.Row.Cells.Count - 1
                If IsNumeric(e.Row.Cells(j).Text) Then
                    If e.Row.Cells(j).Text = 1 Then
                        e.Row.Cells(j - 1).BackColor = System.Drawing.Color.Maroon
                    End If
                End If
            Next
        End If
    End Sub

Open in New Window

05.07.2008 at 07:15PM PDT, ID: 21521874

Rank: Master

Well, and isn't it what I was telling you?? Using RowDataBound event?? I do object about JUST closing this question.

05.07.2008 at 07:32PM PDT, ID: 21521926

Yurich: Since you have an objection, answer the question in its entirety for the full points. You pointed me in a direction and thats why I awarded you 100 Points. You were and are missing parts to the solution.

05.07.2008 at 08:41PM PDT, ID: 21522168

Rank: Master

Well first, I don't see any points awarded to me, it's said you requested to close the question with points refunded. Second, all you had to do is implement to some particulars specific to your data format, i gave you a working sample, which you applied to your particular situation.

Amazing how people can be mingy and ungreatful after they got helped - you asked for help, you got two working samples, due to your lack of experience you couldn't use them at the first time and now you're arguing if you were helped at all. We saved you time and money and what am I getting?? You're telling me off!! If it was in any consultancy, I (or any other programmer-consultant) would write this code for your for 5 minutes and you'd get charged for a couple of hundred bucks, and that woud be your full answer. Unbelievable.

05.07.2008 at 09:04PM PDT, ID: 21522257

Yurich:
I see you are very troubled about this. First off, you have yet to complete the question proposed at the beginning (which was valued at 500 points). Second the solution did not even come close to the problem, all be it you advised to look at RowDataBound (thus the reason for the 100 Points awarded). The program language was incorrect, your response did not address the fact that there are multiple columns that need to have the color changed, did not take into account removing certain columns, did not create the link on the first column.

You were provided a fair number of points for advising to look at RowDataBound.Please move on from this question, from the start of this posting you have been a very rude person not just to me but others and in no way am I telling you off, I did offer you 1/5 of the initial offer for your guidance. Answer the full question and I will award you the full points.

No response is required unless you are answering the question. If you have an issue with me, please take it up with the mediator

05.09.2008 at 03:24PM PDT, ID: 21536755

Rank: Master