allbluekos 2015-06-16 06:42 采纳率: 88.5%
浏览 1545

从外部数据导入DATAGRIDVIEW,如何从第5行开始导入?

如题,怎么设置从第3行开始导入?如下代码该怎么改正,请各位指教。
图片说明
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim intColCount As Integer = 0
Dim blnFlag As Boolean = True
Dim mydt As New DataTable

    Dim mydc As DataColumn
    Dim mydr As DataRow

    Dim strpath As String = "E:\Computer Knit\PR20150611_0801.csv"
    Dim strline As String
    Dim aryline() As String

    Dim i As Integer
    Dim rowNum As Integer

    Dim mysr As System.IO.StreamReader = New System.IO.StreamReader(strpath, System.Text.Encoding.GetEncoding("GB2312"))
    strline = mysr.ReadLine()
    rowNum = 1
    While (strline <> Nothing)
        aryline = Split(strline, ",")
        If rowNum = 1 Then
            If (blnFlag = True) Then
                blnFlag = False
                intColCount = aryline.Length
                For i = 0 To aryline.Length - 1
                    mydc = New DataColumn(aryline(i))
                    mydt.Columns.Add(mydc)
                Next
            End If
        Else
            mydr = mydt.NewRow()
            For i = 0 To intColCount - 1
                mydr(i) = aryline(i)
            Next
            mydt.Rows.Add(mydr)
        End If
        strline = mysr.ReadLine()
        rowNum = rowNum + 1
    End While
    DataGridView1.DataSource = mydt
End Sub
  • 写回答

1条回答 默认 最新

  • 南天空 2015-06-24 03:18
    关注

    定义变量i,存储datagridview 的行索引,循环所有行,当索引号是你所要插入的行时,开始插入,否则什么也不做

    评论

报告相同问题?

悬赏问题

  • ¥30 vmware exsi重置后登不上
  • ¥15 易盾点选的cb参数怎么解啊
  • ¥15 MATLAB运行显示错误,如何解决?
  • ¥15 c++头文件不能识别CDialog
  • ¥15 Excel发现不可读取的内容
  • ¥15 关于#stm32#的问题:CANOpen的PDO同步传输问题
  • ¥20 yolov5自定义Prune报错,如何解决?
  • ¥15 电磁场的matlab仿真
  • ¥15 mars2d在vue3中的引入问题
  • ¥50 h5唤醒支付宝并跳转至向小荷包转账界面