Simple and compact class library for working with the MS OLE Database.
OLEDB = OLE DB = Object Linking + Embedding Database
OlED db = new OlED();
- get count rows
- get rows values
- get rows and fetch for DataGridView
- delete
- insert
- only execute a query
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.