This is a migrated thread and some comments may be shown as answers.

[Solved] Is that possible to compare two column dynamically by ConditionalFormattingObject, or is there any way to do this?

8 Answers 504 Views

GridView

This is a migrated thread and some comments may be shown as answers.

8 Answers, 1 is accepted

Accepted

answered on 31 Dec 2009, 06:11 PM

Hello Joy,

According to this forum post, you need to handle the CellFormatting event, which gives you a greater degree of flexibility in setting styles in response to a more complex condition or more operands than made possible by the conditional formatting feature.

The following code should do something similar to what you have described:

                            private void radGridView1_CellFormatting(object sender, Telerik.WinControls.UI.CellFormattingEventArgs e)         
                    {         
                        // order date > due date         
                        if (((int)e.CellElement.RowElement.RowInfo.Cells[0].Value) > ((int)e.CellElement.RowElement.RowInfo.Cells[1].Value))         
                        {         
                            e.CellElement.DrawFill = true;         
                            e.CellElement.GradientStyle = GradientStyles.Solid;         
                            e.CellElement.BackColor = Color.Yellow;         
                            e.CellElement.ForeColor = Color.Red;         
                        }         
                        else // order date < due date         
                        {         
                            e.CellElement.ResetValue(VisualElement.ForeColorProperty);         
                            e.CellElement.ResetValue(VisualElement.BackColorProperty);         
                        }         
                    }         

I hope this helps.

- Robert

answered on 10 Feb 2010, 07:50 AM

Hi jerry,

You can changed the background to transperant as it is shown in the following code snippet:

button.Text = "Hello";

button.Size = new Size(100, 100);

button.ButtonElement.ButtonFillElement.GradientStyle = Telerik.WinControls.GradientStyles.Solid;

button.ButtonElement.ButtonFillElement.BackColor = Color.Transparent;

If you need help, feel free to write us back.

Kind regards,
Svett
the Telerik team

Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Follow the status of features or bugs in PITS and vote for them to affect their priority.

answered on 15 Feb 2010, 01:11 PM

Hello jerry,

Thank you for writing. You can access the button element in CellFormatting event using e.CellElement.Children collection. You have to follow the element structure.

To handle adding new row event, you can use RowsChanging or CurrentRowChanged .net events. Another option is to use CellBeginEdit event and check if current row is type of GridViewNewRowInfo.

Best wishes,
Martin Vasilev
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

answered on 15 Feb 2010, 04:21 PM

Martin,
I'm still not following what you are saying. When I user clicks on "add new row" a new row is added with every field in the grid even a button. I need to disable that but and leave the rest of the buttons already in the grid alone. So when I'm in the cellFormatting event how do I know that this cell i'm looking at is from a new row and that it is a button and then be able to disable it?
I'm already using RowsChanging to handle the data from the new row.

Do you have an example demo that I can look at? Please forgive my lack of understanding this control.

Thank You

answered on 18 Feb 2010, 07:19 AM

Hi jerry,

Please, excuse me for the misunderstanding. If you want to disable a command button in the new row you have to use ViewCellFormating event instead CellFormatting. Please, consider the following code as example:

void radGridView1_ViewCellFormatting(object sender, CellFormattingEventArgs e)

{

GridCommandCellElement commandCell = e.CellElement as GridCommandCellElement;

if (commandCell != null && commandCell.RowElement is GridNewRowElement)

{

RadButtonElement buttonElement = commandCell.Children[0] as RadButtonElement;

if (buttonElement != null)

{

buttonElement.Enabled = false;

}

Let me know if you need additional assistance.

Sincerely yours,
Martin Vasilev
the Telerik team