Monday, December 7, 2009

Aggregates in Grid Views

Learn how to enable aggregates in applications created with Web Site Factory code generation project and Code OnTime Designer. Aggregates deliver business intelligence and work with adaptive filtering.

Aggregates in ASP.NET/AJAX Web Applications

Here is a snippet of Products data controller that enables aggregates for grid1 view as shown in video.

<view id="grid1" type="Grid" commandId="command1" label="Products">
  <headerText>This is a list of products. </headerText>
  <dataFields>
    <dataField fieldName="ProductName" columns="40" />
    <dataField fieldName="SupplierID" aliasFieldName="SupplierCompanyName" aggregate="Count"/>
    <dataField fieldName="CategoryID" aliasFieldName="CategoryCategoryName" />
    <dataField fieldName="QuantityPerUnit" columns="20" />
    <dataField fieldName="UnitPrice" dataFormatString="c" columns="15" aggregate="Average"/>
    <dataField fieldName="UnitsInStock" columns="15" aggregate="Sum"/>
    <dataField fieldName="UnitsOnOrder" columns="15" />
    <dataField fieldName="ReorderLevel" columns="15" />
    <dataField fieldName="Discontinued" />
  </dataFields>
</view>

3 comments:

hi said...

I have a requirement in ASP.NET, How can we handle printer functions (Who is printing, What is printing, when is printing,)..... the printers will be in different location in the network(Printers connected to System and Network printer) and we have to update the printer functions in a DB... and show the information in a Web enabled Solution..... For updating the info into DB shall be in any language.... the main issue here is i should install the service in only in one system that system should pass all the printer info to DB. Is it Possible..... Please any one can advise me.........

hi said...

I have a requirement in ASP.NET, How can we handle printer functions (Who is printing, What is printing, when is printing,)..... the printers will be in different location in the network(Printers connected to System and Network printer) and we have to update the printer functions in a DB... and show the information in a Web enabled Solution..... For updating the info into DB shall be in any language.... the main issue here is i should install the service in only in one system that system should pass all the printer info to DB. Is it Possible..... Please any one can advise me.........

Customer Service said...

We are not sure we understand your question.

Please submit your detailed requirements at http://codeontime.com/contactus.aspx.

You can find more about Code OnTime Generator, Data Aquarium Framework, and other great products here.


© 2010 Code OnTime LLC. Intelligent code generation software for ASP.NET. Visit us at http://codeontime.com