Silverlight Controls and Silverlight Toolkit

Change the style of cell within datagrid

Hi, as mentioned in the title, is anyone know how to access and obtain the properties of any single cell within the datagrid and change its style base on certain conditions, says if the content value is greater than zero?

I am very new to Silverlight, is there any documentation for me to know all the members of datagrid control?

Thanks in advance!

Re: Change the style of cell within datagrid

Here is a starting point on the datagrid cell:

http://msdn.microsoft.com/en-us/library/system.windows.controls.datagridcell(VS.95).aspx

Notice the different templates that tie back to the Visual State Manger. Also look at this link:

http://msdn.microsoft.com/en-us/library/cc278066(VS.95).aspx for datagrid styles and templates.

(Please mark as Answered if this helps!) [H]

Re: Change the style of cell within datagrid

Thanks for reply, WadeFlextronics, do you have any sample code to change the properties of datagrid cell?

for example, change the foreground color of a datagrid cell which is located on column 2 and row 2 to blue color?

Re: Change the style of cell within datagrid

Hi,

You can try to refer the below code the change the datagrid's column 2 and row 2's font color to blue.

private void peopleDataGrid_LoadingRow(object sender, DataGridRowEventArgs e)
        {
            if (e.Row.GetIndex() == 2)
            {
                this.peopleDataGrid.SelectedIndex = e.Row.GetIndex();
                DataGridColumn column = this.peopleDataGrid.Columns[1];
                FrameworkElement fe = column.GetCellContent(e.Row);
                FrameworkElement result = GetParent(fe, typeof(DataGridCell));
                if (result != null)
                {
                    DataGridCell cell = (DataGridCell)result;

                    cell.Foreground = new SolidColorBrush(Colors.Blue);
                }
            }
        }

        private FrameworkElement GetParent(FrameworkElement child, Type targetType)
        {
            object parent = child.Parent;
            if (parent != null)
            {
                if (parent.GetType() == targetType)
                {
                    return (FrameworkElement)parent;
                }
                else
                {
                    return GetParent((FrameworkElement)parent, targetType);
                }
            }
            return null;
        }

Re: Change the style of cell within datagrid

Amanda Wang - MSFT

....

private void peopleDataGrid_LoadingRow(object sender, DataGridRowEventArgs e)
        {
            if (e.Row.GetIndex() == 2)
            {
                this.peopleDataGrid.SelectedIndex = e.Row.GetIndex();
                DataGridColumn column = this.peopleDataGrid.Columns[1];
                FrameworkElement fe = column.GetCellContent(e.Row);
                FrameworkElement result = GetParent(fe, typeof(DataGridCell));

....

Thanks for your help, Amanda! Basically, can you recommend me in learning datagrid? i had been working so much but found it very much different compare to gridview in ASP.NET ...

As for this case, the key of code is "e.Row", is it possible to obtain the row of datagrid like "peopleDataGrid.Row"? because i usually will not going to raise an event to obtain the "e.Row".

Re: Change the style of cell within datagrid

Hi,

siomi
Basically, can you recommend me in learning datagrid? i had been working so much but found it very much different compare to gridview in ASP.NET ...

Unfortunately, there is no much resource on learning the datagrid. I learn it just from the SDK and the internet. You can try to search on this forum, there are many excellent threads on the DataGrid control, which can be helpful.

siomi
As for this case, the key of code is "e.Row", is it possible to obtain the row of datagrid like "peopleDataGrid.Row"? because i usually will not going to raise an event to obtain the "e.Row".

In fact, there are many differences between the ASP.NET DataGrid Control and the SilverLight Control. The Silverlight DataGrid does not have the Rows property.

If you want to retrieval the data of a row, you can try to refer the below code:

DataGridColumn column= peopleDataGrid.Columns[0];

FrameworkElement fe= peopleDataGrid.GetCellContent(people[1]);//people is a collection to which Datagrid is bound

The above code will get you the Content of 1st column of 2nd row.

Re: Change the style of cell within datagrid

Amanda Wang - MSFT

Hi,

You can try to refer the below code the change the datagrid's column 2 and row 2's font color to blue.

private void peopleDataGrid_LoadingRow(object sender, DataGridRowEventArgs e)
        {
            if (e.Row.GetIndex() == 2)
            {
                this.peopleDataGrid.SelectedIndex = e.Row.GetIndex();
                DataGridColumn column = this.peopleDataGrid.Columns[1];
                FrameworkElement fe = column.GetCellContent(e.Row);
                FrameworkElement result = GetParent(fe, typeof(DataGridCell));
                if (result != null)
                {
                    DataGridCell cell = (DataGridCell)result;

                    cell.Foreground = new SolidColorBrush(Colors.Blue);
                }
            }
        }

        private FrameworkElement GetParent(FrameworkElement child, Type targetType)
        {
            object parent = child.Parent;
            if (parent != null)
            {
                if (parent.GetType() == targetType)
                {
                    return (FrameworkElement)parent;
                }
                else
                {
                    return GetParent((FrameworkElement)parent, targetType);
                }
            }
            return null;
        }

very nice [:)] it helped me too. thanks Amanda Wang

Re: Change the style of cell within datagrid

Hello Amanda Wang!

I have read your code and I have used it.It is very good!

But,with your code,I can only change the Foreground of a Cell and I can't change the Background of a Cell.

So,can you show me the way which I can use to change the Background of a Cell ?

I wrote : cell.Background = new SolidColorBrush(Colors.Red);

The code line runs but the Background isn't changed !

Thank you very much !

SilverlightOIS

Re: Re: Change the style of cell within datagrid

When the data in cell is changed, I need change Foreground again, How can I do this?

Ask question again in http://silverlight.net/forums/p/63281/156483.aspx

Re: Re: Change the style of cell within datagrid

Hello,

I am in a similar situation, whereby I need to style a datagrid cell based on it's contents, either altering the foreground/background based on the value of a 'Decimal' field, setting the justification for date fields and making the date display as a short date and setting colour and justification on text fields.

The datagrid is bound to a data table and is dynamically created from various SQL calls (being a 'common' datagrid).

The contents of e.row are a datarow.rowview and contain the row details as expected.

The problem is, with the above code, the following line always returns a null, as does any attempt to get the cellcontent

FrameworkElement fe = column.GetCellContent(e.Row);

If I apply a 'restyle' via a function from a button click, it works once, but then crashes if I try to perform the restyle again. It also loses the styling if the datagrid is sortged by clicking on the columnheader and any attempt to re-apply the style fails. Another stange action is, once the grid has been dynamically created, if I then call the function to apply the style, the grid is dislayed *without* the modified style. The button on my form calls the exact same function and does nothing else, but this *does* apply the style. It almost seems to me that though the grid is built, because it has not been displayed, the style isn't "known".

If there is a way code wise, or somehow via a style on the datagridcell which could react to the column datatype to call an approriate converter, I'd be very grateful for some pointers as countless hours searching the web has not revealed any answers.

I am presuming this is actually do-able of course as unfortunately most of the example I find relating to converters and styling assume the datagrid has the columns hard-set in the XAML. Given that a grid where the explicit column is affected by a converter retains it's styling when the grid is resorted on different columns, I am hoping it is possible.

Re: Re: Change the style of cell within datagrid

I am having the same problem with column.GetCellContent(e.Row). It always returns null. So why do people keep saying that it works? It doesn't work. And I spent most my day searching online for the solution to this problem. Very annoying...

I am trying to replace values in the row as it is loaded. For example, if a value equals "-100", I want it to display as blank.

Re: Re: Change the style of cell within datagrid

John,

I gave up in the end, I went this route instead...

http://wpf.codeplex.com/Thread/View.aspx?ThreadId=49605

Hope that helps you too.

Re: Re: Change the style of cell within datagrid

Try This it might help...

Thanks,

puneet

Re: Change the style of cell within datagrid

Hi, Amanda

Thanks for snippet, it worked for me... I was also trying the same thing and it worked

Bhagirath Patadia

Re: Change the style of cell within datagrid

Hi Amanda , Thanx but i got that ereror when my task is complete succefully so what is the problem "Object reference not set to an instance of an object". Thanx in Advance

Re: Re: Change the style of cell within datagrid

Hi can i check the cell value in this event...??

private void Grid1stQuad_LoadingRow(object sender, DataGridRowEventArgs e)

{

FrameworkElement fe = col.GetCellContent(e.Row);

FrameworkElement result = GetParent(fe, typeof(DataGridCell));

}

Re: Re: Change the style of cell within datagrid

you can try this

Private Sub Alert_RowLoaded(ByVal sender As Object, ByVal e As DataGridRowEventArgs)
Dim objCOl As ObservableCollection(Of BindableObject)
objCOl = CType(CType(sender, DataGrid).ItemsSource, ObservableCollection(Of BindableObject))
Dim dr As DataRow

dr = objCOl(e.Row.GetIndex).DataRow

'dr(0) is your cell value

If dr(0).ToString.Contains("Pending") Then
e.Row.Background = New SolidColorBrush(Colors.Red)
End If
End Sub

Re: Change the style of cell within datagrid

Hi All, FrameworkElement result = GetParent(fe, typeof(DataGridCell)); Who can tell me the GetParent(,) method of the above code which come from where in silverlight. Thanks, -Andy Chen