using System; using System.Data.OleDb; class Program { static void Main(string[] args) { string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\example.accdb"; using (OleDbConnection connection = new OleDbConnection(connectionString)) { connection.Open(); OleDbCommand command = new OleDbCommand("SELECT * FROM Table1", connection); using (OleDbDataReader reader = command.ExecuteReader()) { while (reader.Read()) { Console.WriteLine(reader.GetString(0) + ", " + reader.GetString(1)); } } } } }
using System; using System.Data.OleDb; class Program { static void Main(string[] args) { string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\example.accdb"; using (OleDbConnection connection = new OleDbConnection(connectionString)) { connection.Open(); OleDbCommand command = new OleDbCommand("INSERT INTO Table1 (Field1, Field2) VALUES ('Value1', 'Value2')", connection); int rowsAffected = command.ExecuteNonQuery(); Console.WriteLine(rowsAffected + " rows affected."); } } }In this example, a connection is made to an Access database file using an OleDbConnection object. An OleDbCommand object is created to execute an INSERT query against a table in the database, and the number of rows affected by the operation is output to the console. The package library for OleDbDataReader is System.Data.OleDb.