OleDB_dotNET 1.1.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;

	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 book 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;
}

}