Skip to content

Latest commit

 

History

History
32 lines (26 loc) · 1016 Bytes

README.md

File metadata and controls

32 lines (26 loc) · 1016 Bytes
Raw

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.