在datagridview vb.net中添加一行

Question

我想在datagridView中向用户显示文章信息的来源(FAMILLE1或FAMILLE2(：

我的代码：

Dim dt1 As DataTable = New db_con().selectdata( _
              "SELECT famille1.ID, famille1.Article, famille1.quantité, famille1.prixch, famille1.prixvn, famille1.dateex FROM famille1;")
        Dim dt2 As DataTable = New db_con().selectdata( _
              "SELECT famille2.ID, famille2.Article, famille2.quantité, famille2.prixch, famille2.prixvn, famille2.dateex FROM famille2;")
        DataGridView1.Rows.Clear()
        For i As Integer = 0 To dt1.Rows.Count - 1
            DataGridView1.Rows.Add(i + 1, dt1.Rows(i)(0), dt1.Rows(i)(1), dt1.Rows(i)(2), dt1.Rows(i)(3), dt1.Rows(i)(4), dt1.Rows(i)(5))
        Next
        For i As Integer = 0 To dt2.Rows.Count - 1
            DataGridView1.Rows.Add(i + 1, dt2.Rows(i)(0), dt2.Rows(i)(1), dt2.Rows(i)(2), dt2.Rows(i)(3), dt2.Rows(i)(4), dt2.Rows(i)(5))
        Next

我认为代码应该是这样：

Dim dt1 As DataTable = New db_con().selectdata( _
              "SELECT famille1.ID, famille1.Article, famille1.quantité, famille1.prixch, famille1.prixvn, famille1.dateex FROM famille1;")
        Dim dt2 As DataTable = New db_con().selectdata( _
              "SELECT famille2.ID, famille2.Article, famille2.quantité, famille2.prixch, famille2.prixvn, famille2.dateex FROM famille2;")
        DataGridView1.Rows.Clear()
        For i As Integer = 0 To dt1.Rows.Count - 1
            DataGridView1.Rows.Add(i + 1, dt1.Rows("famille1"), dt1.Rows(i)(0), dt1.Rows(i)(1), dt1.Rows(i)(2), dt1.Rows(i)(3), dt1.Rows(i)(4), dt1.Rows(i)(5))
        Next
        For i As Integer = 0 To dt2.Rows.Count - 1
            DataGridView1.Rows.Add(i + 1, dt1.Rows("famille2"), dt2.Rows(i)(0), dt2.Rows(i)(1), dt2.Rows(i)(2), dt2.Rows(i)(3), dt2.Rows(i)(4), dt2.Rows(i)(5))
        Next

所以，我想在datagridview中的一行显示数据源(famille1或famille2(

希望很清楚：/

Answer 1

而不是运行此查询：

SELECT famille1.ID, famille1.Article, famille1.quantité, famille1.prixch, famille1.prixvn, famille1.dateex FROM famille1
UNION ALL
SELECT famille2.ID, famille2.Article, famille2.quantité, famille2.prixch, famille2.prixvn, famille2.dateex FROM famille2

由此产生的数据表，只需：

DataGridView1.DataSource = dt

Answer 2

尝试一下。

    MysqlConn = New MySqlConnection()
    SQL = "famille1.ID, famille1.Article, famille1.quantité,famille1.prixch, famille1.prixvn, famille1.dateex FROM famille1"
    MysqlConn.ConnectionString = "server=localhost; user id=root; database=DATABASENAME"
    Try
        MysqlConn.Open()
        ContactsCommand.Connection = MysqlConn
        ContactsCommand.CommandText = SQL
        ContactsAdapter.SelectCommand = ContactsCommand
        ContactsAdapter.Fill(ContactsData)
        DATAGRIDVIEW1.DataSource = ContactsData
    Catch myerror As MySqlException
        MessageBox.Show("Cannot connect to database: " & myerror.Message)
    Finally
        MysqlConn.Close()
        MysqlConn.Dispose()
    End Try