VB.NEt数据库金额计算 [英] VB.NEt Database Amount Calculation

问题描述

请帮忙我正在使用VB.Net



我的表有这样的数据

Please Help to This i am using VB.Net

My Table Have Data Like this

RegNO   Name   PaidAmount Class Section 
A100	AAAA	500        I	A
A200	BBBB	750        I	A
A100	AAAA	150        I	A
A300	CCCC	400        I	A
A400	DDDD	300        I	A
A100	AAAA	100        I	A
A300	cccc	350        I	A
A400	DDDD	450        I	A		

我想要显示DataGridview喜欢这个

I Want Show DataGridview Like this

RegNO   Name   PaidAmount Class Section 
A100	AAAA	750       I	A
A200	BBBB	750       I	A
A300	CCCC	750       I	A
A400	DDDD	750       I	A

[edit]已添加代码块 - OriginalGriff [/ edit]

[edit]Code block added - OriginalGriff[/edit]

推荐答案

您需要的查询是：

The query you need is:

SELECT RegNO, Name, SUM(PaidAmount), Class, Section FROM myTable
GROUP BY RegNO, Name, Class, Section

这篇关于VB.NEt数据库金额计算的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！