Help Connecting To Mysql Database With Visual Basic?

1. Anonymous Says

   You have no SQL query.
   Try this method
   Imports System.Data.SqlClient
   Public Class Form1 Inherits System.Windows.Forms.Form
   Dim myConnection As SqlConnection
   Dim myCommand As SqlCommand
   Dim dr As New SqlDataReader()
   ‘declaring the objects
   Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)_
   Handles MyBase.Load
   myConnection = New SqlConnection(“server=localhost;uid=sa;p…
   ‘establishing connection. you need to provide password for sql server
   Try
   myConnection.Open()
   ‘opening the connection
   myCommand = New SqlCommand(“Select * from discounts”, myConnection)
   ‘executing the command and assigning it to connection
   dr = myCommand.ExecuteReader()
   While dr.Read()
   ‘reading from the datareader
   MessageBox.Show(“discounttype” & dr(0).ToString())
   MessageBox.Show(“stor_id” & dr(1).ToString())
   MessageBox.Show(“lowqty” & dr(2).ToString())
   MessageBox.Show(“highqty” & dr(3).ToString())
   MessageBox.Show(“discount” & dr(4).ToString())
   ‘displaying the data from the table
   End While
   dr.Close()
   myConnection.Close()
   Catch e As Exception
   End Try
   End Sub
   End Class

2. Gardner Says

   Step through the code in debug mode. If it’s throwing an error when you try to connect, you can put your mouse over the myerror var and see exactly what the problem is.

Leave a Reply

You must be logged in to post a comment.