OLEDB

Simple and compact class library for working with the MS OLE Database.

OLEDB = OLE DB = Object Linking + Embedding Database

Using

OlED db = new OlED();

Library features

• get count rows
• get rows values
• get rows and fetch for DataGridView
• delete
• insert
• only execute a query

Sample

string connections="provider=microsoft.jet.oledb.4.0;data source=database.mdb;jet oledb:Database Password=sample";
OlED db = new OlED();
OleDbConnection connection = new OleDbConnection(connections);
OleDbCommand command = new OleDbCommand("SELECT * from barcode",connection);
////////////////////////////////////////////////////////////////////////
MessageBox.Show("Count Rows : " + db.count(command,connection).ToString());
////////////////////////////////////////////////////////////////////////
dataGridView1.DataSource = db.get(command,connection).Tables[0];

In this case, the database file (database.mdb) should be located next to the executable file.