求高人帮忙vb.net如何与数据库连接
本帖最后由 jiuge0001 于 2010-06-24 16:30:08 编辑
[解决办法]
用ADO、ADO。NET、ODBC连接 SQLSERVER？
Dim cn As SqlConnection
Dim da As SqlDataAdapter
Dim ds As DataSet
Dim cnstr As String = "integrated security=SSPI;data source=(local);initial catalog=Northwind "
Dim dastr As String = "select * from Employees "
cn = New SqlConnection(cnstr)
da = New SqlDataAdapter(dastr, cn)
ds = New DataSet
da.Fill(ds)
Me.DataGrid1.DataSource = ds.Tables(0)

[解决办法]
直接使用 using System.Data.SqlClient

然后使用ADO.NET就行了。
MSDN中有例子。
[解决办法]
(connectionString) 格式
"Data Source=MSSQL1;Database=AdventureWorks;Integrated Security=true;"

using (SqlConnection connection = new SqlConnection(connectionString))
    {
        connection.Open();
        // Do work here; connection closed on following line.
    }

Private Sub OpenSqlConnection()
    Dim connectionString As String = GetConnectionString()
    Using connection As New SqlConnection(connectionString)
        connection.Open()
        Console.WriteLine("ServerVersion: {0}", connection.ServerVersion)
        Console.WriteLine("State: {0}", connection.State)
    End Using
End Sub