vb.net 2008 query Datatable and display result into Datagridview

Which database will you be using ? MS SQL ?

hi
i use mysql

Oh ok ! Than, you will have to choose which Library you will use to connect to the mysql server. I presume you can do one yourself, but there is free ones around.

I've found an example which provide you a good Library and a really good tutorial on how to do what you need : Connecting VB.NET to a MySQL database.

http://www.vbmysql.com/articles/vbnet-mysql-tutorials/the-vbnet-mysql-tutorial-part-3

Hi djon2003,

i already connect to mysql and do query. now i need to query datatable and display result into Datagridview

Which library do you use to connect to mysql through VB.NET ?

Isn't there a ExecuteQuery or something like method within the MySqlAdapter or MySqlCommand ?

I use MySqlAdapter.
i already have data in dataset. now i need to quiry dataset and display result into datagridview