Question

我已利用这一法典链接数据库。正在显示错误。连接财产尚未启动。

Dim sConnString As String = "user id=" + sUserID + ";password=" + sPwd + ";initial catalog=" + sDatabase + ";Connect    Timeout = 30" + ";Pooling=true;Max Pool Size=" + MaxPoolSize + ";Min Pool Size=" + MinPoolSize + ";"

            Dim Conn As New SqlConnection()
            Dim cmd As New SqlCommand()
            cmd.CommandText = "INSERT INTO NEC_Customer_Mst(Customer_Code,Customer_Name) VALUES(Customercode,Customername)"
            cmd.Connection = Conn
            Conn.Open()
            cmd.ExecuteNonQuery()
            Conn.Close()

任何建议?

Answer 1

我将修改你的代码,以便你使用<条码>,使用。这样,它就可以在资源完成后清理。

Dim sConnString As String = "user id=" + sUserID + ";password=" + sPwd + ";initial catalog=" + sDatabase + ";Connect Timeout=30;Pooling=true;Max Pool Size=" + MaxPoolSize + ";Min Pool Size=" + MinPoolSize + ";"              

Using Conn As New SqlConnection(sConnString)
    Using cmd As New SqlCommand()             
        cmd.CommandText = "INSERT INTO NEC_Customer_Mst(Customer_Code,Customer_Name) VALUES(Customercode,Customername)"             
        cmd.Connection = Conn             
        Conn.Open()             
        cmd.ExecuteNonQuery() 
    End Using
End Using

Answer 2

您宣布了<代码>ConnString的链接,但希望通过链接到SqlConnection(:

Dim Conn As New SqlConnection(sConnString)
Conn.Open()

Answer 3

其实,它还没有开始:

Dim Conn As New SqlConnection(sConnString)
Conn.Open()

Answer 4

连接不动产联系未申报/续延时,总是发生错误。

解决办法简单

dim con as new SqlConnection 
con.connectionString = "Provide your SQL connection"
con.open
 write code or action you want to perform
con.close

Hope it helps.

友情链接