DataGridView数据显示问题 [英] DataGridView Data Display Problem
问题描述
表1：FeeMaster1
课程费用类型
我是JAN
我感觉
我是MAR
II JAN
II FEB
我APR
II BUSFEE
DGV HEADER的这个代码文本目的
Dim strSQL7 As String =SELECT * FROM FeeMaster1 WHERE Class ='' &安培; cboClass.Text& ''
Dim DaAp7 As New SqlDataAdapter（strSQL7，con）
Dim Dset7 As New DataTable
DaAp7.Fill（Dset7）
使用Me.DataGridView2
.Columns.Add（Regno，RegNo）
For i As Integer = 0 To Dset7.Rows.Count - 1
.Columns.Add（i，Dset7.Rows（i）.Item（FeeType））
下一页
结束
以上代码运作良好
之后我连接这个表2用于数据Diplay用途
TABLE2（FeeTrans）
REGNO FEETYPE AMOUNT付款类别
A100 JAN 500 IA
A200 JAN 750 II B
A100 FEB 150 IA
A300 JAN 222 I A
A100 MAR 120 IA
A100 AP R 54 IA
A200 BUSFEE 120 II B
我想要这样的DGV（支持我选择课程）我意味着）
''--------------- -
Regno JAN FEB MAR APR
''----------------
A100 500 150 120 54
A300 222 0 0 0
我正在使用此代码进行显示目的但是不要喔..请帮帮我......纠正COED ..
Dim strSQL10 As String =SELECT Regno，FeeType，AmountPaid FROM FeeTrans WHERE Class =''& cboClass.Text& ''
Dim DaAp10 As New SqlDataAdapter（strSQL10，con）
Dim DSet10 As New DataTable
DaAp10.Fill（DSet10）
每个博士作为DataRow在DSet10.Rows
Me.DataGridView2.Rows.Add（）
随着Me.DataGridView2.Rows（Me.DataGridView2.Rows.Count - 1）
.Cells（Regno）。Value = dr（Regno）
For i As Integer = 0 To DSet10.Rows.Count - 1
.Cells（Dset7.Rows（0）.Item（FeeType））。Value = dr（AmountPaid）
下一页
结束
下一步
TABLE 1 : FeeMaster1
Class FeeType
I JAN
I FEB
I MAR
II JAN
II FEB
I APR
II BUSFEE
THIS CODE FOR DGV HEADER TEXT PURPOSE
Dim strSQL7 As String = "SELECT * FROM FeeMaster1 WHERE Class=''" & cboClass.Text & "''"
Dim DaAp7 As New SqlDataAdapter(strSQL7, con)
Dim Dset7 As New DataTable
DaAp7.Fill(Dset7)
With Me.DataGridView2
.Columns.Add("Regno", "RegNo")
For i As Integer = 0 To Dset7.Rows.Count - 1
.Columns.Add(i, Dset7.Rows(i).Item("FeeType"))
Next
End With
Above Code Working Good
After That I Connect this Table2 For Data Diplay Purpose
TABLE2 (FeeTrans)
REGNO FEETYPE AMOUNT PAID CLASS SECTION
A100 JAN 500 I A
A200 JAN 750 II B
A100 FEB 150 I A
A300 JAN 222 I A
A100 MAR 120 I A
A100 APR 54 I A
A200 BUSFEE 120 II B
I WANT DGV LIKE THIS (SUPPOSE I SELECT CLASS I MEans)
''----------------
Regno JAN FEB MAR APR
''----------------
A100 500 150 120 54
A300 222 0 0 0
I Am USING THIS CODE FOR DISPLAY PURPOSE BUT IT NOT WOEKING .. Please Help me.. Correct COde..
Dim strSQL10 As String = "SELECT Regno, FeeType,AmountPaid FROM FeeTrans WHERE Class=''" & cboClass.Text & "''"
Dim DaAp10 As New SqlDataAdapter(strSQL10, con)
Dim DSet10 As New DataTable
DaAp10.Fill(DSet10)
For Each dr As DataRow In DSet10.Rows
Me.DataGridView2.Rows.Add()
With Me.DataGridView2.Rows(Me.DataGridView2.Rows.Count - 1)
.Cells("Regno").Value = dr("Regno")
For i As Integer = 0 To DSet10.Rows.Count - 1
.Cells(Dset7.Rows(0).Item("FeeType")).Value = dr("AmountPaid")
Next
End With
Next
推荐答案
再次，你需要阅读JOIN查询，现在你也需要阅读PIVOT。
Again, you need to read up on JOIN queries, and now you need to read up on PIVOT too.
这篇关于DataGridView数据显示问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
