数据库连接问题？

[changei123]

在VB.NET 中怎么连接数据库呀，我怎么连不对呀，请帮帮忙，谢谢各位大哥大姐们！1

[hamadou]

Public Sub InsertRow(myConnectionString As String)
' If the connection string is null, use a default.
If myConnectionString = "" Then
myConnectionString = "Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;"
End If
Dim myConnection As New SqlConnection(myConnectionString)
Dim myInsertQuery As String = "INSERT INTO Customers (CustomerID, CompanyName) Values('NWIND', 'Northwind Traders')"
Dim myCommand As New SqlCommand(myInsertQuery)
myCommand.Connection = myConnection
myConnection.Open()
myCommand.ExecuteNonQuery()
myCommand.Connection.Close()
End Sub 'SelectSqlClientSrvRows

[hamadou]

建议以后不要这样的问题也来问啊！看看帮助，msdn！

[点点星灯]

Const ConnStr As String = "packet size=4096;user id=xxx;data source=192.168.0.2;
persist security info=True;initial catalog=DC;password=xxx"


If SqlConn Is Nothing Then
SqlConn = New SqlClient.SqlConnection(ConnStr)
End If
SqlCom = New SqlClient.SqlCommand(SqlStr, SqlConn)
SqlConn.Close()
SqlConn.Open()



....

[水如烟]

不能类型的数据库其连接字串有所不同。
具体你可以参考这个：
http://www.connectionstring.com/
http://blog.joycode.com/ghj/articles/15312.aspx

[hidejay]

oracle怎么连呢