Refresh QueryRowStyle

[Karim el Safadi]

Hey,

I am using QueryRowStyle to color some rows based on a property. Everything works fine.

However, I am calling some function after that which performs a calculation and changes some of the data. The colors should change accordingly.

Is there a way to trigger an event that will "refresh" the grid and therefore call the QueryRowStyle function again.

Thanks in advance!

[Karthikraja Kalaimani]

Hi Karim,

Your requirement can be achieved by calling the Refresh() method of SfDataGrid after your calculations done. Please refer the below code snippet.

Code snippet:

 

SfDataGrid.Refresh() 

Regards,
Karthik Raja

[Karim el Safadi]

Thanks so much, great support! Worked like a charm!

[Karthikraja Kalaimani]

Hi Karim,

Thank you for the update. We glad to know that your requirement has been achieved. Please let us know if you have any further queries on this. We are happy to help you.

Regards,
Karthik Raja 

[RAFAEL FELIPE SACOMANI]

hi, can i refresh a single row by index to force queryrowstyle?

[Karthikraja Kalaimani]

Hi Rafael,

Currently, we are validating your requirement. we will validate and update your further details on or before 13^th May 2020. We appreciate your patience until then.

Regards,
Karthik Raja 

[Karthikraja Kalaimani]

Hi Rafel,

Still we need some more to find a suitable workaround for your requirement. So, we will update further details on or before 15^th May 2020. We appreciate your patience until then.

Regards,
Karthik Raja

[Karthikraja Kalaimani]

Hi Rafael,

Your requirement can be achieved by calling the UpdateRowStyles method of DataRowBase class. Here we have called UpdateRowStyles method only when the RowData  is equal to the first data of the viewModel collection.

Code snippet :

 

for (int i = 0; i < this.textGrid.GetRowGenerator().Items.Count; i++) 

            { 

                if (this.textGrid.GetRowGenerator().Items[i].RowData != null) 

                { 

                    if (this.textGrid.GetRowGenerator().Items[i].RowData.Equals(viewModel.OrdersInfo[i-1])) 

                    { 

                        var row = (DataRowBase)this.textGrid.GetRowGenerator().Items[i]; 

                        this.textGrid.GetRowGenerator().Items[i].GetType().GetRuntimeMethods().FirstOrDefault(x => x.Name.Equals("UpdateRowStyles")).Invoke(row,null); 

                         

                        break; 

                    } 

                } 

            } 

Note :  We can only get visible rows from GetRowGenerator() method.

Regards,
Karthik Raja