// All namespaces used in the import program
Using system;
Using system. Data. oledb;
Class oledbtest {
Public static void main (){
String strconnect = "provider = sqloledb.1; persist Security info = false; user id = sa; initial catalog = xsgl; Data Source = czdy1 ";
// Establish a connection to the database
Oledbconnection aconnection = new oledbconnection (strconnect );
// Design the content of the dataset to be returned
Oledbcommand acommand = new oledbcommand ("select * From xsk", aconnection );
Try {
// Open the connection to the database
Aconnection. open ();
// Return the required dataset content
OleDbDataReader aReader = aCommand. ExecuteReader ();
Console. WriteLine ("The following is all the content of a field in the opened dataset! ");
// Display all content of the first field of the dataset. If you want the second field to change "0" to "1"
While (aReader. Read ()){
Console. WriteLine (aReader. GetString (0 ));
}
// Close the dataset
AReader. Close ();
// Close the connection to the database
AConnection. Close ();
}
Catch (OleDbException e)
{
// If an error occurs, the error message is output.
Console. writeline ("Error Type:", E. errors [0]. Message );
}
}
}
[Note] the main differences between the code used to access SQL Server and the code used to access acess are as follows:
1. The selected database engine is different. To access a connection to a database from SQL Server, use the following statement:
String strconnect = "provider = sqloledb.1; persist Security info = false; user id = sa; initial catalog = xsgl; Data Source = czdy1 "; "Initial catalog" is the name of the database to be selected. "Data Source" is the name of the server that provides database services.
2. Do not import the system .. windows. Forms namespace because the remote database is accessed and the application class is not required.