Skip to content
/ OLEDB Public

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

License

Notifications You must be signed in to change notification settings

BaseMax/OLEDB

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 

Repository files navigation

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.