vb.net里这样连接数据库

[opet_zhu]

那位兄弟姐妹有vb.net连接数据库的实例，请给我寄一个
谢谢！！
[e-mail]
或那位可以教小弟一下，这么连接。简单一些就可以
我用服务器资源管理
小弟在线等待谢谢！

[孟子E章]

http://www.csdn.net/Develop/read_article.asp?id=16437

[opet_zhu]

老兄有没有具体的例子

[sunbob]

Private strConnection As String
Dim cn As SqlClient.SqlConnection

strConnection = "Persist Security Info=False;User ID=sa;password=123;database=workdatabase;server=server2000;Connect Timeout=30" '"Server=founder;Database=base;User Id=sa;Password=123;"


'first,establish the connection
cn = New SqlClient.SqlConnection()
'获得连接字符
cn.ConnectionString = strConnection
cn.Open()

[opet_zhu]

打开数据库后这么连？？

[michael3769]

Dim connstr As String = "server=localhost;uid=sa;pwd=aa;database=aaaa"
Dim conn As SqlConnection = New SqlConnection(connstr)
Dim Cmd, cmd1 As SqlCommand
Dim reader As SqlDataReader
Dim sSQL As String
Dim server_pass As String

server_pass = Application("server_pass")

sSQL = "Select gcbm ,gclb ,tzze From datatablename)"
' 建立数据库链接
conn = New SqlConnection("data source=localhost;initial catalog=jianguan;persist security info=True;user id=sa;password=" + server_pass + ";workstation id=win2000;packet size=4096")
conn.Open()
'用SQL语句建立一个Command对象

Cmd = New SqlCommand(sSQL, conn)
reader = Cmd.ExecuteReader()