ADODB.NET - 1.0

public static void CommandSample()
    {
        /// Create a Connection object
        Connection conn = new Connection();
        conn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Northwind.mdb");
        // Create a Command object
        _Command cmd = new Command();
        cmd.ActiveConnection = conn;

        // Specify the SQL command to execute
        cmd.CommandText = "INSERT INTO Employees (FirstName, LastName, Title) VALUES (?, ?, ?)";

        // Add parameters to the command
        cmd.Parameters.Append(cmd.CreateParameter("FirstName", DataTypeEnum.adVarChar, ParameterDirectionEnum.adParamInput, 10, "John"));
        cmd.Parameters.Append(cmd.CreateParameter("LastName", DataTypeEnum.adVarChar, ParameterDirectionEnum.adParamInput, 20, "Smith"));
        cmd.Parameters.Append(cmd.CreateParameter("Title", DataTypeEnum.adVarChar, ParameterDirectionEnum.adParamInput, 30, "Manager"));

        // Execute the command
        object recordsAffected;
        object missing = Type.Missing;
        cmd.Execute(out recordsAffected, ref missing, (int)ExecuteOptionEnum.adExecuteNoRecords);

        Console.WriteLine("Record inserted successfully. Records affected: " + recordsAffected);
    }

static void UpdateBatchSample()
    {
        string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Northwind.mdb;";
        Connection connection = new Connection();
        Recordset rsTitles = new Recordset();

        // Open connection
        connection.Open(connectionString);

        // Open titles table.
        rsTitles.Open("select * from shippers", connection, CursorTypeEnum.adOpenKeyset, LockTypeEnum.adLockBatchOptimistic, -1);

        // Move to the first record
        rsTitles.MoveFirst();

        // Loop through recordset
        while (!rsTitles.EOF)
        {
            string name = rsTitles.Fields["CompanyName"].Value.ToString();
            if (name == "Speedy Express")
            {
                
                char chKey = Console.ReadKey().KeyChar;
                if (char.ToUpper(chKey) == 'Y')
                {
                    // Change type to other value.
                    rsTitles.Fields["name"].Value = "SuperFast Express";
                }
            }
            rsTitles.MoveNext();
        }

        // UpdateBatch to commit changes
        rsTitles.UpdateBatch(AffectEnum.adAffectAll);
              
        // Close recordset and connection
        rsTitles.Close();
        connection.Close();
        
    
    }

static void Main()
    {
        string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Northwind.MDB;";

        // Create a Connection object
        Connection connection = new Connection();
        connection.Open(connectionString);

        // Create a new ADODB.Recordset
        Recordset recordset = new Recordset();
        recordset.ActiveConnection = connection;
        recordset.Source = "SELECT * FROM Products";
        recordset.Open();

        // Add a new field to the recordset
        Fields fields = recordset.Fields;
        fields.Append("NewField", DataTypeEnum.adVarChar, 50, FieldAttributeEnum.adFldUpdatable);

        // Update the recordset with the new field
        fields.Update();

        // Add a new record to the recordset with FieldList and Values parameters
        object fieldList = new object[] { "ProductName", "NewField" };
        object values = new object[] { "NewProduct", "NewValue" };

        recordset.AddNew(fieldList, values);
        recordset.Update();

        // Find a specific record by ProductName
        recordset.Find("ProductName = 'NewProduct'", 0, SearchDirectionEnum.adSearchForward, Type.Missing);

        // Close the connection
        connection.Close();

    }

static void FieldDeletionSample()
{
    // Initialize ADODB objects
    Connection conn = new Connection();
    Recordset rs = new Recordset();

    conn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Northwind.mdb");

    // Open a recordset for Region table
    rs.Open("SELECT * FROM Region", conn, CursorTypeEnum.adOpenDynamic, LockTypeEnum.adLockOptimistic, -1);

    Fields fields = rs.Fields;

    // Check if the recordset contains the "RegionDescription" and "Desc" fields
    if (fields["RegionDescription"] != null)
    {
        // Delete the Desc field
        fields.Delete("RegionDescription");

        // Update the recordset
        rs.Update();

    }
                
    // Clean up
    rs.Close();
    conn.Close();
            
 }

public static void ExecuteSample()
        {
            // Initialize ADODB objects
            Connection conn = new Connection();
            Recordset rs = new Recordset();

            try
            {
                // Execute SQL queries or commands
            string sqlQuery = "INSERT INTO Customers (ID, Name, Age) VALUES (1, 'Will', 35)";
            conn.Execute(sqlQuery);

            Console.WriteLine("Record inserted successfully.");

            // Update a record
            conn.Execute(sqlUpdates);
            }
            catch (Exception ex)
            {
                Console.WriteLine("Error: " + ex.Message);
            }
            finally
            {
                // Clean up
                rs.Close();
                conn.Close();
            }
        }