Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Public Class Form1
- Dim db As IDbConnection = New MySqlConnection("Server=localhost;Database=mydb;Uid=root;Pwd=myPass;Port=3306;")
- Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
- Try
- Dim sql As String = "select * from Customers"
- Dim lCustomer As List(Of Customer) = db.Query(Of Customer)(sql, Nothing)
- grid.DataSource = lCustomer
- Catch ex As Exception
- Debug.Print(ex.Message)
- End Try
- End Sub
- End Class
- Public Class City
- Public ID As String
- Public Name As String
- End Class
- Public Class Customer
- Public id As String
- Public name As String
- Public address As String
- End Class
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement