1. Home
  2. Forum
  3. WinForms
  4. Flowlayoutpanel and 2 syncfusionDatagrid in it.

Flowlayoutpanel and 2 syncfusionDatagrid in it.

I have an issue with automatically arranging two different Datagrid after each other after 1150 rows for the first grid. I would like to achieve 2000 rows then the next grid can follow dynamically. My current code works with maximum rows of about 1150 before the next grid starts dynamically. but after that, it throws off the next datagrid under the first one.


28 Replies
LS Leke Salami April 30, 2024 10:54 AM UTC

Please check the video of the code attached. thanks


Attachment: Pb_SfGridIssue_6c9b28a9.rar

DD Dhivyabharathi Dakshinamurthy Syncfusion Team April 30, 2024 05:56 PM UTC

Hi Leke Salami,

Based on the provided information, we suspect that the issue occurs when the SfDataGrid contains 2000 rows, causing the second datagrid to be positioned improperly, overlapping the first datagrid at certain positions. If possible, could you please share a demo that reproduces the issue? This will help us to accurately replicate the reported scenario.


LS Leke Salami May 4, 2024 08:29 AM UTC

The demo can be found here, we are just looking for a solution that can be used for two different tables, whereby the tables will follow each other irrespective of the number of rows of the first table.

https://sendgb.com/v70uKGDyzNl

Thanks


DD Dhivyabharathi Dakshinamurthy Syncfusion Team May 6, 2024 11:14 AM UTC

Hi Leke Salami,


Thank you for the update. It appears that we are unable to access the link provided in your last update for the demo. Could you please share an accessible link or provide a runnable demo to further investigate the reported scenario.


LS Leke Salami May 6, 2024 11:36 AM UTC

The link is active, I just tried it now…


DD Dhivyabharathi Dakshinamurthy Syncfusion Team May 7, 2024 04:53 PM UTC

Hi Leke Salami,

We have successfully accessed the provided link for the sample and downloaded. We now require some time to analyze the reported scenario. We will provide further updates on or before May 09, 2024.


DD Dhivyabharathi Dakshinamurthy Syncfusion Team May 9, 2024 05:20 PM UTC

Hi Leke Salami,

After analyzing your sample and attempting to replicate the reported scenario, we observed that no data is loaded when retrieving data from the method GetSummarySheet().

We attempted to run the sample without the condition datas.Count > 0 in the button click, and we obtained the image as attached below.




LS Leke Salami May 9, 2024 05:24 PM UTC

Please use like December date not recent date. You can check the database under Pb_summarysheet for a valid date you can check. You have to use either Calculate button or view button. Better still use same date as used in the demo.


DD Dhivyabharathi Dakshinamurthy Syncfusion Team May 10, 2024 04:44 PM UTC

Hi Leke Salami,

In the provided sample, it appears that there is no database. We did not modify any date as you mentioned, and View button is not visible in the view. Without any data, we are unable to replicate the reported scenario in the provided sample.


Please review the image below, which shows that no data get from the GetSummaryMethod.


We have created a simple sample using a FlowLayoutPanel with two SfDataGrid controls in an attempt to replicate the reported scenario. However, we were unable to reproduce the issue on our end. We kindly request that you review this sample and if possible, attempt to replicate the reported issue. 


Attachment: SfDataGrid_acc7763c.zip

LS Leke Salami May 13, 2024 08:57 AM UTC

You can select any date from 1st of january 2024 to 9th of march 2024... then you can click calculate button if it is highlighted or click on VIEW button.



Thanks


DD Dhivyabharathi Dakshinamurthy Syncfusion Team May 15, 2024 04:36 AM UTC

Hi Leke Salami,

As per the date you mentioned, we used the date but there are no changes. The data is not loaded in the view. We have attached an video for your reference. Kindly check it. If possible, please share a video replicating the issue, as we still did not receive any data.



DD Dhivyabharathi Dakshinamurthy Syncfusion Team May 15, 2024 04:43 AM UTC

Hi Leke Salami,


Attached the video for your reference. Kindly look into this.


Attachment: Video_ec683a2d.zip

LS Leke Salami May 15, 2024 06:36 AM UTC

I tested both the debug exe and the code myself, it runs, it takes about 20 seconds to load from debug exe and about 30 seconds to load from code.... so just wait for 2 minutes max. if you are using a lower rating system.



Thanks


DD Dhivyabharathi Dakshinamurthy Syncfusion Team May 16, 2024 05:04 PM UTC

Hi Leke Salami,

We have successfully run the provided sample, and the data is loaded in the view. In response to your reported scenario, we tested the positioning of SfDataGrid2 in the ResizeDataGrid() method. According to your case, when rows exceed 1150, it offsets the next datagrid under the first one.

Upon reviewing the provided video, it seems that the second datagrid's position is lower than the height of the first datagrid. However, when attempting to replicate the scenario on our end, we did not encounter the same issue. The second datagrid's position is indeed greater than the height of the first datagrid.

It's possible that the discrepancy may be related to system resolution. Could you please share your system resolution and OS version so that we can attempt to replicate the issue on our side.


Kindly refer the attached image for your reference.



LS Leke Salami May 17, 2024 03:03 AM UTC

Can you send a screen shot of your demo after running it , cause the maximum row based on that database is about 1415 or approximately. Were you able to see it all? If you can’t see it then you should have a solution to automatically show second grid irrespective of the first gird length. 

This is not the of screen resolution, it has been tested on 13inches, 14”, 15” and 16 inches laptops same issue. And the OS is windows 10.


Thanks 



DD Dhivyabharathi Dakshinamurthy Syncfusion Team May 17, 2024 05:52 PM UTC

Hi Leke Salami,

Based on the provided information, we were able to replicate the issue on our end. When the record count is increased to nearly 1170, the issue is reproduced, and the second DataGrid is not visible.


We are currently analyzing the cause of the reported issue. We need some time to validate this, and we will provide an update on or before May 21, 2024


LS Leke Salami May 21, 2024 04:57 PM UTC

I dont still get why nobody has responded, firstly it took you guys about 10 days to be able to just know how to download a demo code from a link you claimed has nothing on it... down to how to run it which was straight forward from the get go. Is it that syncfusion pays you for each request you reply to? I dont know why you guys make it seem to be a rocket science to do the least things. Because this means a business cant use your library once they have over 1170 rows?

Today is 21st of may you promised. You guys should do better, same with the other issue I had, you guys could not sort it out.


Best regards


DD Dhivyabharathi Dakshinamurthy Syncfusion Team May 22, 2024 02:20 PM UTC


Hi Leke Salami,

We deeply regret the inconvenience caused to you. Initially, we were unable to access the link to download the demo. After attempting to replicate the issue, you mentioned that we needed to select specific dates to load the data. This type of conversation took time to replicate the issue. Now, we have prepared a simple sample and the issue is replicated in this as well.  And, we have checked this case in Framework DataGrid also. In Framework DataGrid, second grid not displayed. Now, we are validating this issue to determine whether it should be considered a bug. We will provide an update on or before May 23, 2024.


LS Leke Salami May 24, 2024 10:38 AM UTC

Hello there, 


I’m wondering why there is no update from you guys up till now. You promised on or before on the. 23rd of may and now nothing has been said. If you think it is a bug then report it as one let’s know what we are doing about it.


SB Sweatha Bharathi Syncfusion Team May 24, 2024 02:25 PM UTC

Hi Leke Salami,


As per our further analysis, Initially, the position of the second DataGrid was correctly updated; however, during the rendering process, the location was assigned an incorrect value. Currently, we have consider this as a bug report.


We have checked the reported issue “SfDataGrids overlaps after certain row when the grids are within the FlowLayoutPanel” on our end and it is confirmed as a defect. And We have logged a bug. We will fix this issue and include it in our upcoming Nuget release Which is scheduled on June 25, 2024.


You can track the status of this report through the following feedback link,


Feedback Link:  SfDataGrids overlaps after certain row when the grids are within the FlowLayoutPanel in WinForms | Feedback Portal (syncfusion.com)


Note: The provided feedback link is private, and you need to log in to view this feedback.


We will let you know once it is released. We appreciate your patience until then.

Disclaimer: Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works reprioritization.


Note: Additionally, we have analyzed the same scenario and found that placing the Framework DataGrid within the FlowLayoutPanel results in some rendering problems. We suspect that the problem originates at the framework level. If it is indeed a framework-level issue, we will update you with the details.









LS Leke Salami May 26, 2024 12:22 PM UTC

Thanks for your response, is there a way we can break it to two when the number of rows is over 1000 so that we can have two grid. 1st one for 1000 rows exactly and the other grid would be for the remaining 1000 or less with the last grid where the summary is show at the bottom.



Thanks 


SG Santhosh Govindasamy Syncfusion Team May 27, 2024 02:31 PM UTC

Hi Leke Salami,

Based on the reported scenario, your requirement is to place the summary row at the bottom of the grid. Based on the GridTableSummaryRow position, the summary row will be maintained. Since your requirement is to maintain the summary row at the bottom of the grid, update the position of GridTableSummaryRow to "Bottom" and finally update the GridSummaryColumn.

For your reference, the attached UG link provides guidance on handling "Summaries."

UG Link-> https://help.syncfusion.com/windowsforms/datagrid/summaries


Please let us know if you need any other assistance. We will be happy to assist you.

Regards,

Santhosh.G



LS Leke Salami June 5, 2024 11:37 AM UTC

The above didnt work s expected, Please when would the bug fix be available?



thanks.



Leke Salami


DD Dhivyabharathi Dakshinamurthy Syncfusion Team June 6, 2024 04:29 PM UTC

Hi Leke Salami,

Your requirement is to split the datagrid if the number of records is greater than 1000. For all the grids, a consolidated summary row at the bottom is not possible.

As previously mentioned, the bug fix is promised for the upcoming NuGet release, which is scheduled for June 25, 2024.


LS Leke Salami June 24, 2024 06:38 AM UTC

Good day,

I would like to ask if the Nuget release schedule for tomorrow will cover the issue mentioned here and if it does cover, how will it be coded to solve the issue?


Thanks .



Leke Salami


MA Manikanda Akash Munisamy Syncfusion Team June 25, 2024 03:15 PM UTC

Hi Leke Salami,

We have analyzed the issue and found that the same painting problem occurs in the Framework DataGrid when placed within the FlowLayoutPanel.
We will provide an update once we receive a response.

Regards,
Manikanda Akash

LS Leke Salami July 8, 2024 01:45 PM UTC

Hello there,


I would like to know if there is any solution or update on the issue mentioned above?


Thanks


MA Manikanda Akash Munisamy Syncfusion Team July 9, 2024 02:31 PM UTC

Hi Leke Salami,

Regarding the rendering issue you reported, we've received an update from Microsoft's team suggesting that changing the layouts of the application might resolve the issue. Could you please test this on your side by changing the panel used and let us know?
If you have any further questions or need additional information, please don't hesitate to reach out.
 
Regards,
Manikanda Akash

Loader.
Up arrow icon