SfDataGrid Column Sorting by Time

[Nic]

Hi All,

Using VB.net and Syncfusion 18.1.0.42

Could someone please tell/show me how to sort a column in the SfDataGrid by time (HH:mm:ss)  only, i have an observable collection which includes a DateTime property but no matter what i try i cannot get the column to auto sort by time when an item is updated, the data is updated in the SfDataGrid but it will not sort, it does if click the column header but then when the data is updated it no longer sorts correctly.

i have tried with DateTimeColumn and a Text column with the DateTime both as a DateTime and DateTime to string but have the same issue.

i have also tried the various formats options for the column as in Longtime, Shorttime and also Custom with HH:mm:ss set.

If i use the Microsoft datagrid that comes with visual studio it all works as expected.

Thanks for any help 

Regards

Nic

[Susmitha Sundar]

Hi Nic, 

 

Thank you for using Syncfusion controls. 

 

You can update the sorting and filtering while update data in SfDataGrid by using the LiveDataUpdateMode property as AllowDataShaping. 

 

UG link: https://help.syncfusion.com/windowsforms/datagrid/datamanipulation 

 

Please let us know if you need further assistance on this. 

 

Regards, 

Susmitha S 

[Nic]

Hi Susmitha,

Thank you for your reply, I have AllowDataShaping enabled already but still have the sorting issue, I think it could be because my data is updated on a timer every 30 seconds and then i do SfDataGrid refresh to see the changes and it seem this is not supported by SfDataGrid.

Can you think of any other way i can get this to be able to sort automatically as i SfDataGrid works really well otherwise.

Kind Regards

Nic 

[Susmitha Sundar]

Hi Nic, 

 

Thank you for your update. 

 

We have prepared the sample based on your requirement. While we are updating the values by Timer.Tick event, Time column sorting works fine. 

 

Sample link: https://www.syncfusion.com/downloads/support/forum/153629/ze/DataGrid_WF-1739062051 

 

Please check the sample and let us know if you still facing the same issue? If not, please modify the sample based on your scenario and revert us back with the following details, 

 

·       Issue reproducing video (if possible) 

·       Syncfusion update version 

 

It will be helpful for us to check on it and provide you the solution at the earliest.   

 

Regards, 

Susmitha S 

[Nic]

Hi Susmitha,

Thank you for the sample i have since changed to using a dataset/datatable and sorting is working as expected.

I do however have a new issue where if i group by a column then when the data is updated every 10 seconds if i have a row selected various rows are highlighted/flashing one at a time as they are updated and  the selected row is then unselected is there a way i can stop this from happening?

Kind Regards

Nic

[Susmitha Sundar]

Hi Nic,  

  

Thank you for your update.  

  

We have prepared the sample based on your requirement “Update the data in Timer tick with grouping”. Selected items maintained properly.  

  

Sample link: https://www.syncfusion.com/downloads/support/forum/153900/ze/DataGrid_DataupdatedWithGrouping-827941504 

  

Please check the sample and let us know if you still facing the same issue? If not, please modify the sample based on your scenario and revert us back with the following details,  

  

·       Issue reproducing video (if possible)  

·       Syncfusion update version  

  

It will be helpful for us to check on it and provide you the solution at the earliest.    

  

Regards,  

Susmitha S  

 

 

[Nic]

Hi Susmitha,

I have attached a sample video showing what is happening if i have a row selected and the data is refreshed at 10 second interval, you will notice the rows highlight as they are updated and the selected row has then lost focus. i am using VB.net with SfDataGrid.WinForms version 18.1460.0.42

Regards

Nic

Attachment: row_selection_20200508_134212672_82f13724.rar

[Susmitha Sundar]

Hi Nic, 

Thank you for providing the details. 

We have checked the reported issue with mentioned version. But unfortunately, we unable to replicate this case. We need some time to analyzing this. We will update the details on May 12, 2020. 

We appreciate your patience until then. 

Regards, 

Susmitha S 

[Susmitha Sundar]

Hi Nic, 

  

We have created a new incident under your Direct trac account. We suggest you to follow up with the incident for further updates. Please log in using the below link.  

  

https://www.syncfusion.com/account/login  

  

Regards, 

Susmitha S