如何将行从两个不同的DatagridView导出到VB.Net中的另一个DatagridView [英] How to export rows from two different DatagridView to another DatagridView in VB.Net

问题描述

嗨...



我是vb.net的新手。我需要帮助。



我的表单上有三个DataGridView。我将数据从csv导入datagridview1和datagridview2，并有5列，每列有不同的标题。现在我需要将第一行单元格calue从datagridview1和datagridview2复制到第一行的datagridview3。我该怎么办呢。



datagridview-1



Col-A：Col-B：Col -C

100 200 300

600 700 800





datagridview- 2



Col-D：Col-E：Col-F

1000 2000 3000

6000 7000 8000





datagridview-3



Col-A：Col-B ：Col-C：Col-D：Col-E：Col-F总计

100 200 300 1000 2000 3000（C + F）

600 700 800 6000 7000 8000 （C + F）





我用来将CSV文件导入DATAGRIDVIEW的代码。

Hi...

I am new to vb.net. I need a help.

I have three DataGridView on my form. And I am importing the data from the csv to datagridview1 and datagridview2 and have 5 columns each with different Header. Now I need to copy first row cell calues from datagridview1 and datagridview2 to datagridview3 in the first row only. How can i perform this.

datagridview-1

Col-A : Col-B : Col-C
100 200 300
600 700 800


datagridview-2

Col-D : Col-E : Col-F
1000 2000 3000
6000 7000 8000


datagridview-3

Col-A : Col-B : Col-C : Col-D : Col-E : Col-F Total
100 200 300 1000 2000 3000 (C+F)
600 700 800 6000 7000 8000 (C+F)


The code which I am using to import CSV file to DATAGRIDVIEW.

If System.IO.File.Exists(EquityReport) Then
    ReportListBox1.Items.AddRange(System.IO.File.ReadAllLines(EquityReport))
End If


''Code is responsible for updating the Filtered data to CSV
Dim myCoolWriter As New IO.StreamWriter(EquityReport)

For Each coolItem In ReportListBox1.Items
    myCoolWriter.WriteLine(coolItem)
Next

myCoolWriter.Close()

ReportListBox1.Update()


Dim dt As New DataTable


For Each line As String In System.IO.File.ReadAllLines("C:\TrendZ-Master\EquityReport.txt")

    DataGridView1.Rows.Add(line.Split(";"))
Next

For Each line As String In System.IO.File.ReadAllLines("C:\TrendZ-Master\EquityReport.txt")

    DataGridView2.Rows.Add(line.Split(";"))
Next

推荐答案

试试这个

Dim i As Integer = 0
        While i < DataGridView1.ColumnCount
            DataGridView3.Columns.Add(DataGridView1.Columns(i).HeaderText, DataGridView1.Columns(i).HeaderText)
            i += 1
        End While
        i = 0
        While i < DataGridView2.ColumnCount
            DataGridView3.Columns.Add(DataGridView1.Columns(i).HeaderText, DataGridView1.Columns(i).HeaderText)
            i += 1
        End While
        i = 0
        While i < DataGridView2.RowCount
            DataGridView3.Rows.Insert(DataGridView1.Item(0, i).Value, DataGridView1.Item(1, i).Value, DataGridView1.Item(2, i).Value, DataGridView2.Item(0, i).Value, DataGridView2.Item(1, i).Value, DataGridView2.Item(2, i).Value)
            i += 1
        End While

然后你可以执行你的添加

then you can perform your addition

这篇关于如何将行从两个不同的DatagridView导出到VB.Net中的另一个DatagridView的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！