The row data of sfdatagrid is not displayed.

Question

I am using sfdatagrid.It is processed normally, but sometimes rowdata is not displayed.I want to share my code, but I can't because the code is long.How can I check if the rowdata is displayed properly?If it is not displayed properly, try to solve it by displaying it again.Is it possible to solve it with refresh()?

Vijayarasan Sivanandham · Accepted Answer

Hi Nam ki hun,Thanks for the update.Based on provided information the data received in your is coming from another thread context than the UI thread, and that's the reason you see this error. You can resolve the reported error by set the SfDataGrid.DataSource RunWorkerCompleted event in BackgroundWorker. Please refer the below code snippet, 




backgroundWorker1.DoWork += backgroundWorker1_DoWork; 
backgroundWorker1.RunWorkerCompleted += BackgroundWorker1_RunWorkerCompleted; 
 
private void BackgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) 
{ 
            //set the result value to SfDataGrid.DataSource 
            sfDataGrid1.DataSource = e.Result; 
            if (e.Error != null) 
            { 
                MessageBox.Show(e.Error.Message, "Error"); 
                return; 
            } 
} 
 
private void backgroundWorker1_DoWork(object sender, System.ComponentModel.DoWorkEventArgs e) 
{             
            using (DataSet ds = (DataSet)e.Argument) 
            { 
                //set the datasoure to result 
                e.Result = ds.Tables[0]; 
                ds.Tables[0].Dispose(); 
                ds.Dispose(); 
            } 
} 
Sample Link: https://www.syncfusion.com/downloads/support/forum/166178/ze/Sample-1108511599 
MSDN Link: https://docs.microsoft.com/en-us/dotnet/desktop/winforms/controls/how-to-make-thread-safe-calls-to-windows-forms-controls?view=netframeworkdesktop-4.8#example-use-a-backgroundworker-event-handlerStack Overflow Link: https://stackoverflow.com/questions/10775367/cross-thread-operation-not-valid-control-textbox1-accessed-from-a-thread-othehttps://stackoverflow.com/questions/6481304/how-to-use-a-backgroundworker 
if you are still facing the same issue? If yes, please modify the sample based on your scenario. 
Can you please share us below things?         
        1. Provide the replication procedure with video illustration of the reported issue 
It will be helpful for us to check on it and provide you the solution at the earliest.Regards,Vijayarasan S

Vijayarasan Sivanandham · Answer

Hi nam ki hun, 

Thank you for contacting Syncfusion Support. 

Based on provided information we have checked the reported issue “The row data of sfdatagrid is not displayed.” and unable to replicate the issue from our end. It is working fine as expected. Please find the tested sample and video demo from our end in the link below, 

Sample link: https://www.syncfusion.com/downloads/support/forum/166178/ze/Sample629117607Video Link: https://www.syncfusion.com/downloads/support/forum/166178/ze/RowData-1331636418Can you please share us below things?         
        1. Provide the replication procedure with video illustration of the reported issue 
if you are still facing the same issue? If yes, please modify the sample based on your scenario. 

It will be helpful for us to check on it and provide you the solution at the earliest. 

Regards, 
Vijayarasan S

nam ki hun · Answer

normal.abnormal.This happens intermittently in the same code.I want to control it with events.But I don't know the sequence of events in sfdatagrid.Is there any way to solve this problem?Or can you tell me the sequence of events in sfdatagrid?

Vijayarasan Sivanandham · Answer

Hi nam ki hun,Thanks for the update.We are little unclear with your scenario. Can you please provide the more information related to your queries? 

Can you please share us below things?   
                
        1. Can you please confirm the reported problem occurs while SfDataGrid loading case or Scrolling the SfDataGrid 
        2. Provide code snippet related to SfDataGrid settings 
        3. Can you please confirm in your SfDataGrid column generated manually or autogenerated?        4. Provided the details or code snippet related to type of DataSource and DataSource binding in SfDataGrid        5. Provide replication procedure with video illustration of the reported problem 
        6. If possible, kindly provide a simple issue reproducible 
It will be helpful for us to check on it and provide you the solution at the earliest. 
Regards, 
Vijayarasan S

nam ki hun · Answer

HiI'm still analyzing to fix this issue.Here is my code snippet:private void backgroundWorker_DoWork(object sender, DoWorkEventArgs e)        {            using (DataSet ds = (DataSet)e.Argument)            {                sfDataGrid.DataSource = ds.Tables[0];                ds.Tables[0].Dispose();                ds.Dispose();            }        }private void backgroundWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)        {            if (e.Error != null)            {                MessageBox.Show(e.Error.Message, "Error");                return;            }        }As you can see I am using backgroundWorker.I checked e.Error. Sometimes it works normally, and sometimes an error occurs like this.But the code is the same.My feeling is that this problem occurred when I used a large DataSet.Using a small DataSet reduces this problem.I need your help.Regards,Ki Hun.

nam ki hun · Answer

Thank you.I solved the problem in two ways.1. Don't use BackgroundWorker.2. Using your code snippet.Both methods were successful.Thank you very much for your help.Regards,Ki Hun

Vijayarasan Sivanandham · Answer

Hi Nam ki hun,Thanks for the update.We are glad to know that the reported problem has been resolved at your end. Please let us know if you have any further queries on this. We are happy to help you😊.Regards,Vijayarasan S