在vb.net中聚合数据集上的函数 [英] Aggregate functions on dataset in vb.net

问题描述

我们可以在数据集上使用聚合函数吗？例如，我有10个科目的数据，每个科目有超过200个学生数据。希望获得得分超过50分的学生数量。



类似



< pre lang =SQL> 选择 subject，count（*）来自 data_set（ table1）其中​​标记> = 50 group subject order 按主题。

，结果将类似

 SUBJECT-1  20  
 SUBJECT-2  30  
 SUBJECT -3  44  

等等。



任何人都可以给我类似的数据集语法吗？



Anand

解决方案

Undering Code会帮助你......





昏暗的连接作为SqlConnection =新的sqlconnection（）

connection.ConnectionString =你的连接字符串

connection.Open（）

Dim adp As SqlDataAdapter = New SqlDataAdapter（选择主题，计数（*） from data_set（table1）其中mark> = 50按主题顺序按主题顺序，连接

Dim ds As DataSet = New DataSet（）

adp。填充（ds）

DataGridView1.DataSource = ds.Tables（0）

Hi,

Can we use aggregate functions on data set. For example, I have data of 10 subjects with each subject having more than 200 students data. Want to get subject wise number of students who scored more than 50 marks.

Something like

Select subject,count(*) from data_set("table1") where marks >=50 group by subject order by subject.

and result will be something like

SUBJECT-1   20
SUBJECT-2   30
SUBJECT-3   44

and so on.

Can anyone give me similar syntax which works on data set?

Anand

解决方案

Belowing Code will help you......


Dim connection As SqlConnection = New sqlconnection()
connection.ConnectionString = "Your Connection String"
connection.Open()
Dim adp As SqlDataAdapter = New SqlDataAdapter("Select subject,count(*) from data_set("table1") where marks >=50 group by subject order by subject", connection)
Dim ds As DataSet = New DataSet()
adp.Fill(ds)
DataGridView1.DataSource = ds.Tables(0)

这篇关于在vb.net中聚合数据集上的函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！