NET连接SQL数据库代码大全

　　一、SQL Server 连接代码示例

　　ODBC 

　　 Standard Security:

　　"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;" 

　　 Trusted connection:

　　"Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes;" 

　　 Prompt for username and password:

　　oConn.Properties("Prompt") = adPromptAlways
　　oConn.Open "Driver={SQL Server};Server=Aron1;DataBase=pubs;" 

　　OLEDB, OleDbConnection (.NET) 

　　Standard Security:

　　"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;" 

　　Trusted Connection:

　　"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"
　　(use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)
　　Prompt for username and password:
　　oConn.Provider = "sqloledb"
　　oConn.Properties("Prompt") = adPromptAlways
　　oConn.Open "Data Source=Aron1;Initial Catalog=pubs;"

　　Connect via an IP address:

　　"Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
　　(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))
　　 SqlConnection (.NET) 

　　 Standard Security:

　　"Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"

　　Trusted Connection:

　　"Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"
(use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)

　　Connect via an IP address:

　　"Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
　　(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))
　　 Declare the SqlConnection:

　　二、C#连接代码实例

　　using System.Data.SqlClient;
　　SqlConnection oSQLConn = new SqlConnection();
　　oSQLConn.ConnectionString="my connectionstring";
　　oSQLConn.Open();

　　三、VB.NET连接SQL数据库代码实例

　　Imports System.Data.SqlClient
　　Dim oSQLConn As SqlConnection = New SqlConnection()
　　oSQLConn.ConnectionString="my connectionstring"
　　oSQLConn.Open()

转载于:https://www.cnblogs.com/eric_lin/archive/2010/11/11/1874753.html