Administrator
VB.NET Forum Admin
- Joined
- Jun 3, 2004
- Messages
- 1,462
- Programming Experience
- 10+
Anyone done any work with MySQL as a backend for a .NET app? If so, what tools did you use, what was the experience, etc.?
Imports MySql.Data.MySqlClient
CONST CONNECTION_STRING As String = "Data Source=servername;database=dbName;user ID=username;password=password"
Private Function GetOrdersAndDetails() As DataSet
Try
Dim myConnection As New MySqlConnection(CONNECTION_STRING)
Dim myCommand As New MySqlCommand
Dim myAdapter As New MySqlDataAdapter
Dim myDS As New DataSet
myCommand.Connection = myConnection
myAdapter.SelectCommand = myCommand
myCommand.CommandText = "SELECT * FROM Customers"
myAdapter.Fill(myDS)
Return myDS
Catch ex As Exception
MessageBox.Show(ex.ToString)
End Try
End Function