Hello again.
There is a problem:
Use paging and summary row.
How to calculate the totals for all rows in the data source.
Thank you for your reply.
Hello Sergey,
When paging is used only the rows that are present on the current page are available for calculation and the summary is calculated based on this data.
What you can do is to calculate your data in the Datasource and display the result on the grid footer - http://samples.infragistics.com/2009.2/WebFeatureBrowser/contents.aspx?showCode=true&t=WebGrid/ColumnFooters/ColumnFooters.aspx~srcview.aspx?path=../WebFeatureBrowserVB/WebGrid/ColumnFooters/ColumnFooters.src~srcview.aspx?path=WebGrid/ColumnFooters/ColumnFooters.src
The required by you option is added in our new “WebDataGrid” control and with it you can calculate the values automatically for all rows when paging is used - http://samples.infragistics.com/2010.3/WebFeatureBrowser/contents.aspx?showCode=true&t=WebDataGrid/SummaryRow/WebDataGrid_SummariesBasicFeatures.aspx~srcview.aspx?path=~srcview.aspx?path=WebDataGrid/SummaryRow/WebDataGrid_SummariesBasicFeatures.src
Let me know if you have further questions.
Hello. Thank you for your reply. The calculation of my data in the data source is not possible (use a filter). WebDataGrid do not use (not feature a multi-title). Will the implemented functionality of a multi-header in version 11.1?
The required by you functionality can be achieved mostly on Server-Side and with access to the Datasource like explained here in this thread - http://forums.infragistics.com/forums/p/27201/99968.aspx#99968
Multi-Column Header will be available for the “WebDataGrid” later this year, probably with version 11.2 of Infragistics ASP controls.
Let me know if you need further assistance with this question.
Hello. Thank you for your reply. All clear.
Good afternoon.Can I get sample code for the procedure http://forums.infragistics.com/forums/p/27201/99968.aspx # 99968. I would be very grateful.Thank you for your reply.
Hello.All clear.Please see question http://forums.infragistics.com/forums/t/56605.aspx.Thank you for your reply.
You can calculate the number of records (rows) in your DataSource by using SQL procedure or by “Count” property of the “DataSet”:
int intCount;
intCount = ds.Tables["myTable"].Rows.Count;
Then you can put the number in the “DataSet” itself by creating a new column and add it to the “DataTable”:
http://msdn.microsoft.com/en-us/library/hfx3s9wd.aspx
Or you can put this number to HTML Hidden Field and use it on the page:
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.hiddenfield(v=vs.85).aspx
If you choose first approach you will have to hide the created column and use only the value inserted in it - http://help.infragistics.com/Help/NetAdvantage/ASPNET/2010.3/CLR4.0/html/Infragistics4.WebUI.UltraWebGrid.v10.3~Infragistics.WebUI.UltraWebGrid.UltraGridColumn~Hidden.html
Let me know if you need additional assistance.