SoPathetic
New member
i have already connected to MySQL database and was also able to list the databases i have in a combox in vb, but i got stuck up in listing tables from mysql database into a listview in vb.net
here are my codes:
sql = "show tables from " & dbName
mycommand.connection = conn
mycommand.commandtext = sql
myadpter.selectcommand = mycommand
dim bld as mysqlcommandbuilder = new mysqlcommandbuilder(myadpter)
myadpater.fill(dataset)
listview1.items(0)= dataset.tables(0).rows(0).item(Ctype(1,String)) // i'm always getting error on this part..
can somebody help please..
here are my codes:
sql = "show tables from " & dbName
mycommand.connection = conn
mycommand.commandtext = sql
myadpter.selectcommand = mycommand
dim bld as mysqlcommandbuilder = new mysqlcommandbuilder(myadpter)
myadpater.fill(dataset)
listview1.items(0)= dataset.tables(0).rows(0).item(Ctype(1,String)) // i'm always getting error on this part..
can somebody help please..