iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
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
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.
Hi,
It works.
Pretty simple with the RootTable.CreateFormula() Method.
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.
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname