Compare 2 gridview columns and colour the text if different

Question

0.00/5 (No votes)

See more:

I want to compare two gridview columns and only color the ones that are different.

What i tried below just colors the whole column zero without matching.

What I have tried:

protected void GridView1_RowCreated(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)
       {
           if (e.Row.RowType == DataControlRowType.DataRow)
           {

               if (DataBinder.Eval(e.Row.DataItem, "RockwellPartno") != DataBinder.Eval(e.Row.DataItem, "Part_Number"))
               {
                   e.Row.Cells[0].ForeColor = System.Drawing.Color.Red;
               }
           }
       }

Posted 12-Oct-17 8:39am

Member 12336474

Updated 12-Oct-17 11:06am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

an0ther1 · Accepted Answer · 2017-10-12T11:06:00

The property e.Row.DataItem is not available until the RowDataBound event has fired, from memory this is fired after the RowCreated event

If you debug this you will probably find that these values are null, try as follows;
a) Add a break-point to you RowCreated event handler
b) When you are in the event handler, open your Immediate window in Visual Studio & enter the following;

C#

? DataBinder.Eval(e.Row.DataItem, "RockwellPartno")

This will tell you what the value of your expression is - if it is null & the other expression is also null there is your issue. Nulls are not equal hence the expression is false.

From memory, to access the values in the datagrid you need to do either of the following;
a) Access the inner text value of the field in the code behind;

C#

e.Row.Cells[0].Text

b) Add the required fields to the DataKeyNames property of your data-grid in your ASPX page & then access the values in your code behind using the following

C#

GridView1.DataKeys[e.Row.RowIndex]["RockwellPartno"].ToString()

Use your debugger & read the documentation.
The Immediate & Local windows in your debugger will show you what values you have access to & will allow you to figure out what you can & cannot do.
MSDN contains literally thousands of examples & the documentation is typically very detailed. The below link is the MSDN documentation for the GridView control

GridViewRow Class (System.Web.UI.WebControls)[^]

Kind Regards