Intersoft Community - WebGrid Enterprise - How do I Calculate a NoEdit, Not Bound WebGridColumn?

How do I Calculate a NoEdit, Not Bound WebGridColumn?

yudi — Tue, 16 Mar 2010 21:36:37 GMT

Glad to hear that CreateFormula() method suit with your scenario.

Should you need further assistance or run into any problems regarding our controls, feel free to post it into our forum. We would be happy to assist you again.

How do I Calculate a NoEdit, Not Bound WebGridColumn?

DJBadin — Tue, 16 Mar 2010 16:45:42 GMT

Hi,

It works.

Pretty simple with the RootTable.CreateFormula() Method.

Thanks,

Doug

How do I Calculate a NoEdit, Not Bound WebGridColumn?

yudi — Thu, 11 Mar 2010 20:50:57 GMT

I enclosed one simple sample of WebGrid that has an unbound column with no edit. The grid is bind to “Order Details” table of Northwind database.

An unbound column named “SubTotal” added on InitializeLayout server side event. This column also has DataFormatString set and its EditType is set to “NoEdit”.

On InitializeRow server side event, there is a calculation to count the amount of subtotal based on [UnitPrice], [Quantity], and [Discount] column. This calculation is made to give initial value on [SubTotal] column.

OnInitialize client side event of WebGrid, a formula is added to [SubTotal] column by using CreateFormula() method.

For more detail information, please check the attached sample.

How do I Calculate a NoEdit, Not Bound WebGridColumn?

DJBadin — Wed, 10 Mar 2010 19:50:44 GMT

1. How do I Calculate a NoEdit, Not Bound WebGridColumn?

I followed instructions in the following link, but if the EditType is NoEdit it does not work.

http://support.intersoftpt.com/docs/webgrid/5.0.7200/Calculate%20a%20cell%20after%20a%20value%20is%20filled.html

I have attached a sample I am using.

The Calculated Cell is Total_WebGridColumn.

The ExitEditMode Client Side Event is OrderDetails_WebGrid_OnExitEditMode.

2. Also is there a way to format the cell per the DataFormatString? i.e. DataFormatString="$#,###.00"

3. What is the best Client Event to Calculate the WebGridColumn on an Initial Load or Refresh?

4. What is the best Client Event to Calculate the WebGridColumn on an Add New Row?

Thanks,

Doug