Control Spreesheet DataSource

[Hector Mamani]

Hello, I have the following problems:

1. As the DataSourse is updated after pressing a button, you have a list of data and when you press the button you want to change the list of data, in my case you are using DataManager with Web Adapter.

2. When a list of more than 50 records is retrieved and it is displayed in the Spreadsheet, it is repeated from the first record, since all the records are not the same.

[Janakiraman Sakthivel]

Hi Hector Mamani,  

 

Thank you for contacting Syncfusion support. 

We have checked your reported query. We have prepared the simple sample based on your requirement. 

 

Sample Link: https://www.syncfusion.com/downloads/support/forum/168854/ze/SyncfusionASPNETApplication3_5d5d3b071938464186 

 

Before we proceed further, we would like to let you know the following details. 

1. Please share the codes, if you have done any customization in sample level. 

2. If possible, please share reproduce the reported issue in provided sample or more details regarding this issue. 

4. If possible, please share us the video demonstration of this issue. 

Could you please get back to us with the above requested information, based on that we will check and provide you a better solution quickly. 

  

Regards, 

Janakiraman S. 

[Hector Mamani]

Hi Janakiraman Sakthivel,

Thanks, I send some images of the problem, there is a method to recover data 50 records, with 40 columns approximately and that happens.

.....

I attach code.

Attachment: ros_RosterDetalle_579c8204.rar

[Janakiraman Sakthivel]

Hi Hector Mamani,  

  

Thank you for your update.  

  

We have checked your reported issue and we need to validate more on this. So, we will update you the further details on September 29^th, 2021. We appreciate your patience until then.  

  

Regards,  

Janakiraman S.  

[Janakiraman Sakthivel]

Hi Hector Mamani, 

 

Thank you for your patience. 

 

We have checked your reported query and ensured many test cases. It is working fine from our side. we suspect that you have done too many customizations in your end. we need some more clarification regarding this. So before we proceed further, please share with us the loading data from your end, or if you import the excel file, please share it with us. 

 

For your convenience, we have prepared the sample for this. Please find the link below. 

 

Sample Link: https://www.syncfusion.com/downloads/support/forum/168854/ze/SyncfusionASPNETApplication3_5d5d3b071938464186-2095224322 

 

So please share us the following details to proceed further. 

 

1.  Provide more details regarding if you have done any customization in sample level? If yes please share more information regarding this. 

2.  If possible, please replicate your issue in the above sample or please share us the issue reproducible sample. 

3. If possible, please share the video demonstration for this issue. 

 

Could you please share with us the above details because we need some more clarification regarding this? Based on that, we will check and provide you with a better solution quickly. 

  

Regards,  

Janakiraman S.  

[Hector Mamani]

Thanks for the reply.

1. Use the code provided, now I have the query, how can I use batchChanges () in javascript ?, make modifications and tests, I cannot perform this operation?

I send the code that I am testing.

Attachment: SyncfusionASPNETApplication3_6157e6cf.rar

[Janakiraman Sakthivel]

Hi Hector Mamani,  

  

Thank you for your update.  

  

We have checked your reported query and we need to validate more on this. So, we will update you the further details on October 13^th, 2021. We appreciate your patience until then.  

  

Regards,  

Janakiraman S.  

[Hector Mamani]

Hello Janakiraman Sakthivel,

Is there an alternative solution to what is indicated above?

Thanks

[Janakiraman Sakthivel]

Hi Hector Mamani, 

  

Thank you for your patience. 

 

We have checked your reported query and we are able to use batchChanges with the DataManager as like as below. 

 

Code Example: 

 

<input type="button" value="Actualizar" id="AddInformacion" onclick="updateActualizar()" /> 

 

<div> 

    <ej:DataManager ID="dataManager" runat="server" URL="http://js.syncfusion.com/demos/ejServices/Wcf/Northwind.svc/Orders/"/> 

</div> 

 

 

<ej:Spreadsheet ID="FlatSpreadsheet" ShowRibbon="false" runat="server"> 

                <Sheets> 

         <ej:Sheet DataManagerID="dataManager" Query="ej.Query().take(50).select(['OrderID', 'CustomerID', 'EmployeeID', 'ShipName', 'ShipAddress',])" PrimaryKey="OrderID"> 

         </ej:Sheet> 

   </Sheets> 

</ej:Spreadsheet>

function updateActualizar() { 

                                var xlObj = $('#<%=FlatSpreadsheet.ClientID%>').data("ejSpreadsheet"); 

                                changes = xlObj.getSheet(xlObj.getActiveSheetIndex()).batchChanges.changed; 

                                if (changes.length) { 

                                                alert("Se tiene datos modificados !!!"); 

                                } 

                } 

 

 

For your convenience, we have modified the sample based on your requirement. Please find the link below. 

 

Sample Link: https://www.syncfusion.com/downloads/support/forum/168854/ze/SyncfusionASPNETApplication3_5d5d3b07193846418668257715 

 

Could you please check the above details and get back to us, if you need any further assistance on this. 

  

Regards,  

Janakiraman S.