ado.net

Connection对象使用方法：

======= OledbConnection =======

【Visual Basic.net】
Dim myConnectionString As String
myConnectionString = "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI;"
Dim myConnection As New OleDbConnection(myConnectionString)
myConnection.Open()

【C#.net】
string myConnectionString;
myConnectionString = "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI;";
OleDbConnection MyConnection=new OleDbConnection(myConnectionString);
MyConnection.Open();

======= SqlConnection =======

【Visual Basic.net】
Dim myConnectionString As String
myConnection.ConnectionString = "Persist Security Info=False;Integrated
Security=SSPI;database=northwind;server=mySQLServer;Connect Timeout=30"
Dim myConnection As New SqlConnection()
myConnection.Open()

【C#.net】
string myConnectionString;
myConnectionString = "Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;";
SqlConnection myConnection=new SqlConnection(myConnectionString);
MyConnection.Open();

 

Command对象使用方法：

======= OledbConnection =======

【Visual Basic.net】

Dim mySelectQuery As String = "SELECT OrderID,CustomerID FROM Orders"
Dim myCommand As New OleDbCommand(mySelectQuery,MyConnection)

【C#.net】
string mySelectQuery = "SELECT OrderID,CustomerID FROM Orders";
OleDbCommand myCommand = New OleDbCommand(mySelectQuery,MyConnection);

======= SqlConnection =======

【Visual Basic.net】

Dim mySelectQuery As String = "SELECT OrderID,CustomerID FROM Orders"
Dim myCommand As New SqlCommand(mySelectQuery,MyConnection)

【C#.net】
string mySelectQuery = "SELECT OrderID,CustomerID FROM Orders";
SqlCommand myCommand = New SqlCommand(mySelectQuery,MyConnection)