Member Avatar for cjoyce
cjoyce 0 Newbie Poster

hi guys... i can connect now to the mysql database and is able to display the database names (because i have 3 databases) in a combo box.. i was stuck up in displaying tables from mysql in a listview..
please help me solve this.. here are my codes:

Public Sub OpenDatabase(ByVal dbName As String)
        ' Try
        Sql = "Show tables from " & dbName
        myCommand.Connection = conn
        myCommand.CommandText = Sql
        myAdapter.SelectCommand = myCommand
        Dim bld As MySqlCommandBuilder = New MySqlCommandBuilder(myAdapter)
        myAdapter.Fill(dataset, dbName)
        Form8.ListView1.Items(0).Text = dataset.Tables.ToString

        MsgBox("...")

        '  Catch
        '    MsgBox("error")
        ' End Try

    End Sub

what displays in the list view is this: System.Data.DataTableCollection

Edited by peter_budo because: Keep It Clear - Do wrap your programming code blocks within [code] ... [/code] tags
  • 1 Contributor
  • 0 Replies
  • 396 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.