mysql - 如何修复 vb.net 中的数据库连接？

Question

    Imports MySql.Data.MySqlClient
    Imports MySql.Data
    Public Class Form1
    Dim dbcon As New MySqlConnection("Data Source=VINCENT-PC\SQLEXPRESS;Initial Catalog=Group1;Integrated Security=True")
    Dim sqlcmd As String
    Dim mysqlcmd As MySqlCommand
    Dim dr As MySqlDataReader

Private Sub btnSearch_Click(sender As System.Object, e As System.EventArgs) Handles btnSearch.Click
    Try
        sqlcmd = "Select * from Sample1 where num=" + txtname.Text
        mysqlcmd = New MySqlCommand(sqlcmd, dbcon)
        dbcon.Open()
        dr = mysqlcmd.ExecuteReader
        While dr.Read
            txtfname = dr.Item("fname")
            txtlname = dr.Item("lname")
        End While
        dr.Close()
        dbcon.Close()
    Catch ex As Exception
        MsgBox("Error: " & vbCrLf & vbCrLf & vbCrLf & ex.Message)
    End Try
End Sub
    End Class

这是我编写的代码，但它似乎没有连接到我的数据库，请帮助我，并提前感谢您

Answer 1

尝试以下代码:

Imports System.Data.SqlClient

Dim Conn As SqlConnection
Dim sqlcmd As String
Dim mysqlcmd As SqlCommand
Dim dr As SqlDataReader

Private Sub btnSearch_Click(sender As System.Object, e As System.EventArgs) Handles btnSearch.Click
dim m_CurrConstr as String 
dim m_svrname as String 
dim m_Currentdbf as String
m_Srvname="VINCENT-PC\SQLEXPRESS"
m_Currentdbf ="[YourDBName]"
    Try
        m_CurrConStr = "Server=" & m_Srvname & ";Initial Catalog=" & m_Currentdbf & ";User ID=sa;Password=as;Trusted_Connection=False;"
        Conn = new Sqlconnection(m_currConstr)
        sqlcmd = "Select * from Sample1 where num=" + txtname.Text
        mysqlcmd = New SqlCommand(sqlcmd, Connn)
        Conn.Open()
        dr = mysqlcmd.ExecuteReader
        While dr.Read
            txtfname = dr.Item("fname")
            txtlname = dr.Item("lname")
        End While
        dr.Close()
        Conn.Close()
    Catch ex As Exception
        Messagebox.Show("Error: " & vbCrLf & vbCrLf & vbCrLf & ex.Message)
    End Try
End Sub

如果我回答了您的问题，则标记为答案