从datagridview添加表数据 [英] addtion of table data from datagridview

问题描述

hiii，
除了datagridview表中的整数并在第3个datagridview表中显示加法器之外，我还有问题.

我在datagridviews中添加了3行和3列，然后在行和列的单元格中输入值，然后想要添加两个表并获得结果.

但是我变得越来越错误，因为未为system.data.dataset的类型定义运算符+"
我是vb.net编码的新手，所以很困惑
请帮我...
感谢很多

hiii,
I have problem in addition of integers from datagridview table and displaying the additon in 3rd datagridview table.

I have added 3 rows and 3 columns in datagridviews then entering values in cells of rows and columns and then wanted to add two tables and getting result.

but i am getting eror as "Operator + is not defined for types of system.data.dataset"
i am new in vb.net coding so getting confused
please help me...
Thanx alot

Public Class Form1
    Private myDataSetMatA As DataSet
    Private myDataSetMatB As DataSet
    Private myDataSetMatC As DataSet
    Dim i As Integer
    Dim j As Integer
    Dim k As Integer
    Dim nummA As Integer = 3
    Dim numnA As Integer = 3
    Dim nummB As Integer = 3
    Dim numnB As Integer = 3
    Dim nummC As Integer = 3
    Dim numnC As Integer = 3
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
      

        Dim myDataTableA As DataTable = New DataTable("MatrizA")
        Dim mydatatableB As DataTable = New DataTable("MAtrixB")
        Dim myDataColumn As DataColumn
        Dim myDataRow As DataRow

        For i = 0 To nummA - 1
            myDataColumn = New DataColumn()
            myDataColumn.DataType = System.Type.GetType("System.Double")
            myDataColumn.ColumnName = i
            myDataColumn.ReadOnly = False

            myDataTableA.Columns.Add(myDataColumn)
        Next
        For j = 0 To numnA - 1
            myDataRow = myDataTableA.NewRow()
            For k = 0 To nummA - 1
                myDataRow(k) = 0
            Next

            myDataTableA.Rows.Add(myDataRow)
        Next


        For i = 0 To nummB - 1
            myDataColumn = New DataColumn()
            myDataColumn.DataType = System.Type.GetType("System.Double")
            myDataColumn.ColumnName = i
            myDataColumn.ReadOnly = False

            mydatatableB.Columns.Add(myDataColumn)
        Next
        For j = 0 To numnB - 1
            myDataRow = mydatatableB.NewRow()
            For k = 0 To nummB - 1
                myDataRow(k) = 0
            Next

            mydatatableB.Rows.Add(myDataRow)
        Next
        myDataSetMatA = New DataSet()
        myDataSetMatB = New DataSet()


        myDataSetMatA.Tables.Add(myDataTableA)
        myDataSetMatB.Tables.Add(mydatatableB)

        DataGridView1.DataSource = myDataTableA
        DataGridView2.DataSource = mydatatableB
    End Sub

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        Dim mydatatableC As DataTable = New DataTable("MatrixC")
        Dim Mydatacolumn As DataColumn
        Dim mydatarow As DataRow


        For i = 0 To nummC - 1
            Mydatacolumn = New DataColumn()
            Mydatacolumn.DataType = System.Type.GetType("System.Double")
            Mydatacolumn.ColumnName = i
            Mydatacolumn.ReadOnly = False

            mydatatableC.Columns.Add(Mydatacolumn)
        Next
        For j = 0 To numnA - 1
            mydatarow = mydatatableC.NewRow()
            For k = 0 To nummA - 1
                mydatarow(k) = 0
            Next

            mydatatableC.Rows.Add(mydatarow)
        Next
        myDataSetMatC = New DataSet()

        myDataSetMatC = myDataSetMatA + myDataSetMatB

myDataSetMatC.Tables.Add(myDataTableC)
DataGridView3.DataSource = myDataTableC

    End Sub

End Class

推荐答案

myDataSetMatC = myDataSetMatA + myDataSetMatB

您这样做并期望它能正常工作.错误本身明确指出没有为数据集定义运算符"+".

您不能使用"+"运算符添加两个数据集.

如果要添加两个数据集的数据，则必须为其编写自己的逻辑.

You do this and expect it to work. Error itself clearly specified that there is no operator ''+'' defined for datasets.

You cannot add two dataset using a ''+'' operator.

if you want to add data of two datasets, you have to write your own logic for it.

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