我用VB.net做了个注册表连接到SQL的数据库,可是有问题说conn.open()打不开,谁能帮我解决一下,急急急 …

代码如下: Protected Sub btnRegist_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnRegist.Click Dim conn As New SqlConnection conn.ConnectionString = "Data Source =.;Initial Catalog=buy; Integrated Security = true " conn.Open() Dim ds As New DataSet Dim sql As String sql = "select * from userinfo" Dim da As New SqlDataAdapter(sql, conn) da.Fill(ds, "userinfo") Dim dt As DataTable dt = ds.Tables("userinfo") Dim dr As DataRow dr = dt.NewRow() dr("username") = Txtname.Text dr("userpassw") = txtPwd.Text If rblGender.SelectedValue = "男" Then dr("sex") = "男" Else dr("sex") = "女" End If dt.Rows.Add(dr) Dim cb As SqlCommandBuilder cb = New SqlCommandBuilder(da) da.InsertCommand = cb.GetInsertCommand da.Update(ds, "userinfo") ds.AcceptChanges() End Sub
2026年09月19日 03:25
有4个网友回答
网友(1):

你这明显是与数据库连接出的错!
1.确认数据库名是否是buy?
2.将连接字符串中的Data Source改为127.0.0.1或者local。
3.去掉 Integrated Security = true 这句,加入user=用户名; pwd=密码; 。

网友(2):

conn.ConnectionString = "Data Source =.;Initial Catalog=buy; Integrated Security = true "
仔细检查,数据库路径和数据库名,如果正确,一定可以打开

网友(3):

你用ADO试试,那个更方便,给你参考代码供调试:
Public Cnn As New ADODB.Connection
Cnn.ConnectionString = "Driver={SQLServer};Server=ZIYA\ZSSDBA;Database=db_Mtjk;Uid=sa;Pwd=sa"
Cnn.Open
这个我多年来都这么用,没错!

网友(4):

驱动没弄好,按这个格式,结合你具体的情况弄一下就行了
dbURL = "jdbc:sqlserver://localhost:1433;DatabaseName=text";