且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

编辑连接字符串时出错

更新时间:2022-05-03 05:21:33

您确定dbSQLServerTestDataSet1.tblContact是一个类吗?它看起来更像是具有属性(tblContact)的实例(dbSQLServerTestDataSet1).

New需要一个类名,而不是一个实例.
Are you sure that dbSQLServerTestDataSet1.tblContact is a class? It looks a lot more like an instance (dbSQLServerTestDataSet1) with a property (tblContact).

New requires a class name, not an instance.


在名称空间中添加
Add in the namespace
Imports System.Data.SqlClient


然后使用以下代码:


then use following code:

Dim ds As dsTestCon

        Me.taTestCon.Fill(Me.DsTestCon.tblTest)
        MsgBox(DsTestCon.tblTest.Rows(0).Item(1))

        MsgBox(taTestCon.Connection.ConnectionString)


        Dim adapter As New dsTestConTableAdapters.tblTestTableAdapter
        Dim conn As New SqlConnection()
        Dim vrCompName As String = My.Computer.Name
        conn.ConnectionString = "Data Source=" & vrCompName & "\SQLEXPRESS;AttachDbFilename=e:\dbTest.mdf;Integrated Security=True;User Instance=True"
        adapter.Connection = conn
        Dim table As DataTable = adapter.GetData()
        MsgBox(adapter.Connection.ConnectionString)

        ds = New dsTestCon()
        adapter.Fill(ds.tblTest)

        MsgBox(ds.tblTest.Rows(0).Item(1))