[询问]使用vb.net，MySQL的WPF datagrid [英] [ask]WPF datagrid with vb.net, mysql

问题描述

我被我的代码卡住了...
如何使用vb.net显示从mysql到wpf datagrid的查询?
我正在使用数据集.
这是我的代码:

i''m getting stuck with my code...
how to show query from mysql to wpf datagrid with vb.net?
i''m using dataset..
here''s my code:

Private Sub showDefaultGrid()
        'there's no problem in db connection
        konek(server, user, pass, db)
        Dim sewa As New MySql.Data.MySqlClient.MySqlCommand
        sewa.CommandType = CommandType.Text
        sewa.CommandText = "select * from data_sewa, pelanggan, petugas, kendaraan where data_sewa.id_pelanggan=pelanggan.id_pelanggan and data_sewa.id_kendaraan=kendaraan.id_kendaraan and data_sewa.id_petugas=petugas.id_petugas"
        sewa.Connection = conn
        Dim data As New MySql.Data.MySqlClient.MySqlDataAdapter(sewa)
        Dim table As New DataSet()
        'i'm getting stuck after this
        data.Fill(table)
        dataGridView.ItemsSource = data

    End Sub

需要您的帮助！

need your help!

推荐答案

您是否尝试使用数据表来代替数据集?

问候，
达山.

Hi,

Instead of using a dataset, did you try using datatable?

Regards,
Darshan.

这篇关于[询问]使用vb.net，MySQL的WPF datagrid的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！