C # Connect to an Access database

1. Data sources

Export from SQL Server, select Microsoft Jet database engine when exporting to select a target server, otherwise data will be unreadable

2. Database connection

Oledbconnection,oledbcommand,oledbdataadapter,

If you are in the console, you can use OleDbDataReader.

3. Typical code

String AppPath = System.Windows.Forms.Application.StartupPath//Get entire file path name

AppPath = @ "\student1.mdb";

String Strcon = "Provider = microsoft.jet.oledb.4.0;data Source =" +apppath;

OleDbConnection oleconn = new OleDbConnection (Strcon);

Try
{
Oleconn.open ();
String strquery = "SELECT * from Student_scyx";
OleDbDataAdapter Oleda = new OleDbDataAdapter (strquery, oleconn);
Oleda. Fill (ds, "datastudent");
return DS;
}
catch (Exception ee)
{
Console.WriteLine (EE. Message.tostring ());
throw (EE);
}
Finally
{
Oleconn.close ();
}

4, the interface method call.