mysql db List

hi all im trying to get a list of my database of my mysql server but im stuck and cannot figure it out

can any one help

i can open my connection but thats were i get stuck

Code:

---

Dim connStr As String = "Data Source=" & Vlocalhost.Text & ";" & "User Id=" & Vadmin.Text & ";Password=" & Vpass.Text
        Dim connection As New MySqlConnection(connStr)
       
connection.open

---

use this command to view all your databases

Code:

---

SHOW DATABASES;

---

ok im stuck

Code:

---

Dim command As New MySqlCommand("SHOW DATABASES;", connection)
        main.group.Items.Add(command.ExecuteNonQuery)

---

hi
i have come up with somthing like below but will not do what i want a list of databases

Code:

---

Dim connStr As String = "Databases="";" & "Data Source=" & Vlocalhost.Text & ";" & "User Id=" & Vadmin.Text & ";Password=" & Vpass.Text
        Dim connection As New MySqlConnection(connStr)

        Dim command As New MySqlCommand("SHOW DATABASES", connection)
        connection.Open()
        Dim reader = command.ExecuteReader()
        While reader.Read()
            main.group.Items.Add(reader(1).ToString())
        End While
        connection.Close()

---

can someone please help me with this. im stuck

hi i did it im now able to get the total list of databases

THANKS MOTIL FOR THE TIPS

Code:

---

Dim connStr As String = "Database=" & VDbase.Text & ";" & "Data Source=" & Vlocalhost.Text & ";" & "User Id=" & Vadmin.Text & ";Password=" & Vpass.Text
        Dim connection As New MySqlConnection(connStr)
     
        Dim command As New MySqlCommand("SHOW DATABASES;", connection)
        connection.Open()
        Dim reader = command.ExecuteReader()
        While reader.Read()
            main.group.Items.Add(reader(0).ToString())
        End While
        connection.Close()

---

i did pickup on my reading that if you change "show database;" to "show tables;" you get the tables of the database

Code:

---

Dim command As New MySqlCommand("SHOW tables;", connection)

---