Question

怎样建立VB.NET与SQLSERVER2005的联系

怎样建立VB.NET与SQLSERVER2005的联系

Answer 1

Dim SqlConn As SqlConnection = New SqlConnection("Data Source=服务器名;Initial Catalog=DataBase;Persist Security Info=True;User ID=sa;Password=123")
Dim ds As SqlStr="select * from table"
Dim SqlDa As SqlDataAdapter = New SqlDataAdapter(SqlStr, SqlConn)
Dim ds As New DataSet
ds.Fill(ds)
dataDridview1.DataSource=ds.tables(0)
这样就可以在dataDridview1里面看到表table的数据了

Answer 2

你用用这个看看。strConn = "Driver={SQL Server}" & _
";UID=" & StrUse & _
";PWD=" & StrPWD & _
";DataBase=" & StrDB & _
";Server=" & StrServer

Answer 3

On Error GoTo ErrConnect
Dim Cn As New SqlConnection
If Cn.State = ConnectionState.Open Then Cn.Close()
Cn.ConnectionString = "Server=" & 服务器名& ";DataBase=" & 数据库名& ";User Id=" & sa & ";Pwd=" & 123456 & ""
Cn.Open()
Exit Sub
ErrConnect:
MsgBox("数据库连接错误," + Err.Description, vbExclamation, "信息")