Re: Problems with DataSets! - SOLUTION

[Rizwan Kaif]

Finally I have figured out. Here is the solution to connect to a MySQL database using VB.NET

Dim mySQLDS As New DataSet
Dim connString As String = "server=localhost; user id=myUserInMySQL; password=myUsersPassword; database=mysql"
Dim qryMySQL As String = "SELECT user,password FROM user;"
Dim conn As New MySqlConnection

conn.ConnectionString = connString

Dim cmd As MySqlCommand = New MySqlCommand(qryMySQL)
Dim adapt As New MySqlDataAdapter
adapt.SelectCommand = New MySqlCommand(qryMySQL, conn)
adapt.Fill(mySQLDS)

'Code to display the records in a DataGrid
DataGrid1.DataSource = mySQLDS
DataGrid1.DataBind()


Thats all you have to do. Hope it Helps!

Rizwan Kaif