how to create dataset in vb.net for mysql

Question

Please can some one help on how to create dataset in vb.net for mysql like you use the server explorer add a database connection to a vb project and drag and drop tables on the dataset . i have mysql database which i want a dataset for it please help.

Anel Hodzic · Answer

That is not the good habbit. Why dont you manually create the connection string ? And use datasets and dataadapters. Anyways did u installed MySQL Connector for visual studio ?

Raja T · Answer

Hi Please refer below URLs http://www.shotdev.com/aspnet/vbnet-mysql-data-mysqlclient/vbnet-mysqldatamysqlclient-dataset/ http://stackoverflow.com/questions/10709287/mysql-net-using-dataset http://www.codeproject.com/Tips/493133/Connecting-to-MySQL-databases-using-VB-NET