OleDB_dotNET 1.2.0

Example: using OleDB;

class Program { static void Main(string[] args) { string server = "Microsoft.Jet.OLEDB.4.0"; string dbName = "database.mdb"; string database = AppDomain.CurrentDomain.BaseDirectory + "App_Data\" + dbName; string password = "GO34dsD"; string connectionString = "Provider=" + server + ";" + "Data Source=" + database + ";" + "Jet OLEDB:Database " + "Password=" + password;

	using (DBConnection db_conn = new DBConnection(connectionString))
	{
		Console.WriteLine("IsConnected: " + db_conn.IsConnected());
		if (db_conn == null || !db_conn.IsConnected())
		{
			Console.WriteLine("Connessione non valida.");
			return;
		}

		string sql = "SELECT Id, Application FROM pwdmanager ORDER BY Updatetd_at DESC;";
		DataTable dtLogs = db_conn.SelectTable(sql);

		if (dtLogs == null || dtLogs.Rows.Count == 0)
			return;

		// Loop with the foreach keyword.
		foreach (DataRow dr in dtLogs.Rows)
		{
			Console.WriteLine("Application: " + dr["Application"].ToString().Trim());
		}
	}

	InserisciLibro(connectionString);
}

private static bool InserisciLibro(string connectionString)
{
	bool isSuccess = false;
	using (DBConnection db_conn = new DBConnection(connectionString))
	{
		string sql = @"INSERT INTO book (Application, Type) VALUES ('Test', 'Social');";
		if (db_conn.sql_query(sql))
		{
			int insertedID = db_conn.GetLastInsertedRowID();
			Console.WriteLine("GetLastInsertedRowID: " + insertedID);

			int recordsAffected = db_conn.GetNumRecordsAffected();
			Console.WriteLine("GetNumRecordsAffected: " + recordsAffected);
		}
	}
	return isSuccess;
}

}