与网格视图相关的查询 [英] 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屋!