Intersoft Community - WebGrid Enterprise - Cannot use VirtualGroupPaging with WebService and ADO.NET

Cannot use VirtualGroupPaging with WebService and ADO.NET

Sir_Xblack — Tue, 08 Mar 2011 23:56:24 GMT

Hi,

Thank for your help,

Huy

Cannot use VirtualGroupPaging with WebService and ADO.NET

Sir_Xblack — Mon, 07 Mar 2011 21:16:28 GMT

So How can I convert from untyped schema DataTable to ISDataTable? Can you show me a sample code? I tried but unsuccessful because lack of property in ISDataColumn, ISDataRow.

Thanks,

Huy

Cannot use VirtualGroupPaging with WebService and ADO.NET

handy@intersoftpt.com — Mon, 07 Mar 2011 05:06:48 GMT

Hello,

After discussed with our developer teams, unfortunately, this is a default behaviour by .Net.
DataSet/DataTable is not serializable using JSON.
For JSON-compatibale serialization, use ISDataTable or ISDataSet.

Regards,
Handy

Cannot use VirtualGroupPaging with WebService and ADO.NET

handy@intersoftpt.com — Sun, 06 Mar 2011 23:34:37 GMT

Hello,

I could not replicate the issue before because got a javascript error in the latest hotfixes. When downgrading the hotfixes, I can see your issue. I need a little time to discuss with our developer teams.

Regards,
Handy

Cannot use VirtualGroupPaging with WebService and ADO.NET

Sir_Xblack — Fri, 04 Mar 2011 03:00:00 GMT

Hi Handy,

It compile error because I remove all .dll in bin folder for uploading. I listed all dll file you need. Just add reference for them.

In web.config you should change the connection string to connect to correct database.

	<connectionStrings>
		<add name="BugTrackerConnectionString" connectionString="Data Source=HCQHUY\SQLEXPRESS;AttachDbFilename="C:\Program Files\Intersoft Solutions\Intersoft WebUI Studio 2010 R2\Samples\For ASP.NET\ISNet.WebUI.Samples\App_Data\BugTracker.mdf";Integrated Security=True" providerName="System.Data.SqlClient"/>
	</connectionStrings>

For example: you should change Data Source =Yourserver;AttachDbFilename="YourPath\BugTracker.mdf".

Another thing is remove this line in web.config:

<add path="ISChart.axd" verb="GET" type="ISNet.WebUI.WebGrid.Chart.ChartRequestHandler, ISNet.WebUI.WebGrid" validate="true"/>

I attached bin file to you. Please try example again and help me as soon as possible.

Thanks and Regards,

Huy

Cannot use VirtualGroupPaging with WebService and ADO.NET

handy@intersoftpt.com — Thu, 03 Mar 2011 23:22:51 GMT

Hello Huy,

Your sample raise an error. I could not see your real problem in here. However, during the first load, it might take 25s. If you have more than 10.000rows, you can also use paging to faster the load.

Regards,
Handy

Cannot use VirtualGroupPaging with WebService and ADO.NET

Sir_Xblack — Wed, 02 Mar 2011 23:15:36 GMT

Hi Intersoft,

I was tried to upgrade to WebGrid 7 and use virtual group paging feature. I used the sample in http://intersoftpt.wordpress.com/2010/02/10/virtual-group-paging-with-client-binding-in-depth/

and the new webservice file for not using LINQ in this link http://www.intersoftpt.com/Community/WebGrid/Lots-of-problems-using-WebGrid-Clientbinding-Batch-Update-and-Grouping/?1299125329539

but the example didn't work for me. When I try to expand a group, an exception appeared:

"Message":"A circular reference was detected while serializing an object of type \u0027System.Reflection.Module\u0027.","St...

I attached my sample to you.

I'm using ASP.NET 2.0 and VS2005 C#. I'm not using LINQ or ISNET LINQ DataSource, just only ADO.NET: DataSet and DataTable.

This is list dll I used in sample : Webgrid version is 7.0.7200.417 ; WebDesktop is 3.0.7200.322 ; WebCombo is 4.0.7200.232 ; System.Web.Extensions Version is 1.0.61025.0.

I'm not use ISNet.Data.Ling.dll

Another problem is the loading time for dataset with 500 rows. In my sample, I can see the progress icon loading take about 25s for just only 500 rows. Is this normal that loading webservice with 500 rows take about 25s? In my real application, I was faced to large data with more than 10.000 rows.

Please help me investigate why it couldn't run and is the webservice peformance too slow or not?

Thanks,

Huy