C#

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Data.SqlClient;

namespace dbTest
{
    public partial class Form1 : Form
    {
        String conString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Temp\MasterInventory2.mdb";
        OleDbConnection con = new OleDbConnection();
        DataTable dtCardlist = new DataTable();
        DataTable dtTemp = new DataTable();
        OleDbDataAdapter daCardlist;

        public Form1()
        {
            InitializeComponent();
        }


        private void button1_Click(object sender, EventArgs e)
        {
            //Get the data from MasterInventory into my datagridview.
            con.ConnectionString = conString;
            daCardlist = new OleDbDataAdapter("Select * From Cardlist", con);
            daCardlist.Fill(dtCardlist);
            dataGridView1.DataSource = dtCardlist;           
            
        }

        private void button2_Click(object sender, EventArgs e)
        {
            //1. the InsertCommand
            con.Open();
            daCardlist.InsertCommand = con.CreateCommand();
            daCardlist.InsertCommand.CommandText = "INSERT INTO Cardlist "+
                "(Name, Set, Cost, Type, PowTgh, Rules, Rarity) "+
                "VALUES "+
                "(?,?,?,?,?,?,?)";
            daCardlist.InsertCommand.Connection = con;
            daCardlist.InsertCommand.Parameters.Add("Name", OleDbType.Char, 0, "Name");
            daCardlist.InsertCommand.Parameters.Add("Set", OleDbType.Char, 0, "Set");
            daCardlist.InsertCommand.Parameters.Add("Cost", OleDbType.Char, 0, "Cost");
            daCardlist.InsertCommand.Parameters.Add("Type", OleDbType.Char, 0, "Type");
            daCardlist.InsertCommand.Parameters.Add("PowTgh", OleDbType.Char, 0, "PowTgh");
            daCardlist.InsertCommand.Parameters.Add("Rules", OleDbType.Char, 0, "Rules");
            daCardlist.InsertCommand.Parameters.Add("Rarity", OleDbType.Char, 0, "Rarity");

            //1.1 Test the Insert command
            DataRow newRow = dtCardlist.NewRow();
            newRow["Name"] = "testCard2";
            newRow["Set"] = "TST";
            newRow["Cost"] = "Cost";
            newRow["Type"] = "Type";
            newRow["PowTgh"] = "PowTgh";
            newRow["Rules"] = "Rules";
            newRow["Rarity"] = "Rarity";

            dtCardlist.Rows.Add(newRow);
            daCardlist.Update(dtCardlist);
            con.Close();
            
            /*
            //WORKING VERSION USING MASTERINVENTORY.MDB  
            con.Open();
            daCardlist.InsertCommand = con.CreateCommand();
            daCardlist.InsertCommand.CommandText = "INSERT INTO Cardlist (Name, Cost, Type) VALUES (?,?,?)";
            daCardlist.InsertCommand.Connection = con;
            daCardlist.InsertCommand.Parameters.Add("Name", OleDbType.Char, 0, "Name");
            daCardlist.InsertCommand.Parameters.Add("Cost", OleDbType.Char, 0, "Cost");
            daCardlist.InsertCommand.Parameters.Add("Type", OleDbType.Char, 0, "Type");
            
            //1.1 Test the Insert command
            DataRow newRow = dtCardlist.NewRow();
            newRow["Name"] = "testCard3";
            newRow["Cost"] = "Cost";
            newRow["Type"] = "Type";

            dtCardlist.Rows.Add(newRow);
            daCardlist.Update(dtCardlist);
            con.Close();
            */

       }

    }
}