数据网格中的行数 [英] row count in datagrid

问题描述

您好我有一个数据表，看起来像：

Hi i have a datatable which looks like:

Modulecode      AdminNo
EG1001          111411H
                111380Y
                192029B
EG1002          110970R
                102938X
...

填充dgv。



如何获得：

populated in a dgv.

How to i get:

Modulecode   NumofStudents    AdminNo
EG1001       3                111411H
                              111380Y
                              192029B
<<<<<<<<<<Blank>>>>>>>>>>>>>>>>>>>>>>
EG1002       2                110970R
                              102938X
<<<<<<<<<blank>>>>>>>>>>>>>>>>>>>>>>>
.
.
.

我的代码是：

My codes are:

''Connections
       Dim connect As String
       connect = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" & Application.StartupPath & "\segdata.accdb"
       Dim conn As New OleDbConnection(connect)
       Dim cmd As OleDbCommand = New OleDbCommand
       cmd.Connection = conn



       conn.Open()
       'cmd.CommandText = "SELECT DISTINCT ModuleCode, AdminNo, count() FROM(SEGDATA)ORDER BY ModuleCode ASC, AdminNo ASC"
       cmd.CommandText = "SELECT ModuleCode, COUNT(AdminNo) as numberofstudents,AdminNo FROM (SEGDATA) GROUP BY ModuleCode, AdminNo"

       Dim dt As New DataTable
       dt.Load(cmd.ExecuteReader)


       With dgvmodstud
           .AutoGenerateColumns = True
           .DataSource = dt

       End With



       Dim currentModuleCode As String = String.Empty
       For i = 0 To dgvmodstud.Rows.Count - 1
           If dgvmodstud.Rows(i).Cells(0).Value = currentModuleCode Then
               dgvmodstud.Rows(i).Cells(0).Value = String.Empty
           Else
               currentModuleCode = dgvmodstud.Rows(i).Cells(0).Value
           End If

       Next

但是，学生人数不起作用。

整个栏目的编号相同）：



有人帮我解决了这些问题谢谢！

However, the number of students doesnt work.
it has the same number throughout the whole column ):

someone help me out with the codes thanks!

推荐答案

您可以使用以下链接，



http://stackoverflow.com/questions/7517190/insert-blank -row-between-groups-of-rows-by-id-in-sql [ ^ ]

You can use following link,

http://stackoverflow.com/questions/7517190/insert-blank-row-between-groups-of-rows-and-sorted-by-id-in-sql[^]

这篇关于数据网格中的行数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！