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)