访问mysql数据库并将其显示在gridview或表中

Question

我试图访问Mysql数据库并在。net中的Gridview中显示它我可以让它连接到DB，但它没有显示任何内容，并且在DB中有记录，这是我正在使用的代码。

Dim MysqlConn As MySqlConnection
Dim ContactsCommand As New MySqlCommand
Dim ContactsAdapter As New MySqlDataAdapter
Dim ContactsData As New DataTable
Dim SQL As String
Private Sub btnGrabData_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGrabData.Click
    MysqlConn = New MySqlConnection()
    SQL = "SELECT AffID FROM toutcome"
    MysqlConn.ConnectionString = "Server=localhost;Database=merrywoodtest;UID=MerryWoodTest;PWD=H0r$hamTest;"
    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()
    End Try
End Sub

Answer 1

请确保在分配数据源后调用DataGridView的DataBind()方法。

还可以设置ContactsCommand对象的Connection属性和ContactsAdapter对象的SelectCommand属性。