与网格视图相关的查询 [英] Queries related to grid view

问题描述

我有一个网页表格，我必须根据特定日期计算销售总额，如今今销售的商品A的x单位和今天销售的商品B的单位，那么今天的总销售额应显示为网格视图中的x + y单位。加入5到6张桌子后，如何获得销售量。







Thanx thursunamy具体我想问一下，在我的数据库中有两个字段名称qty已发出和qty，并且两者都分配了一个id分别为1和2。这些值应单独计算，并应显示在网格视图的第一行中。我已经计算了值，但无法在网格视图的第一行显示总值。我怎么能这样做？ Thanx提前尽快恢复。早期的回复将被赞赏...

I have a web form in which i have to calculate the total of sales according to particular date like if x unit of item A is sold today and y unit of item B is sold today then total sales of today should be displayed as x+y units in grid view. How will I do that as quantities of sales are obtained after joining around 5 to 6 tables.



Thanx thursunamy being specific I want to ask that there are two fields name qty issued and qty received in my database and both have an id assigned to that as 1 and 2 respectively. The values for these are to be calculated separately and should be shown in the first row of the grid view. I have calculated the values but not able to show the total value in the first row of the grid view. How can i be able to do so?? Thanx in advance rply as soon as possible. An early response will be appreciated...

推荐答案

我理解正确，你有三个A，B，C列，你想要显示A + B的总和在C列中，如果是这样，则将C列作为tempalte字段并获取标签并在ROWDATABOUND事件上为C分配值。计算ROWDATABOUND事件中的C值。

I am understand correctly, you have three column A, B, C and you want to show sum of A+B in C column, if this, then take C column as tempalte field and take a label and assign values of C to label on ROWDATABOUND event. Calculate values of C on ROWDATABOUND event.

这篇关于与网格视图相关的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！