public class Bd
{
private System.Data.OleDb.OleDbConnection Connection;
public void Open(string FileName)
{
Connection = new System.Data.OleDb.OleDbConnection();
Connection.ConnectionString = "Provider=microsoft.jet.oledb.4.0;Data Source=D:\\test.mdb;Jet OLEDB:System Database=system.mdw;User ID=Admin;Password=mot_passe";
Connection.Open();
}
public System.Data.DataTable GetTable(string Requete)
{
try
{
System.Data.DataSet DtSet = new System.Data.DataSet();
System.Data.OleDb.OleDbDataAdapter AdapTContact = new System.Data.OleDb.OleDbDataAdapter(Requete, Connection);
AdapTContact.Fill(DtSet, ((char)0).ToString());
return DtSet.Tables[0];
}
catch (Exception Err)
{
throw Err;
}
}
public void Close()
{
Connection.Close();
Connection.Dispose();
Connection = null;
}
}
Partager