using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;

namespace Query_Parametrica_OLEDB
{
    class Program
    {
        static void Main(string[] args)
        {
            OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\db1.mdb;User Id=admin;Password=;");
            OleDbCommand cmd = new OleDbCommand("qrySetStudent",cn);
            
            /* Definisco il Command Type */
            cmd.CommandType = System.Data.CommandType.StoredProcedure;

            /* Definisco i parametri di input */
            cmd.Parameters.Add("FirstName", OleDbType.VarChar, 10).Value = "Lorenzo";
            cmd.Parameters.Add("LastName", OleDbType.VarChar, 10).Value = "Benaglia";

            /* Apro la connessione ed eseguo la query */
            cmd.Connection.Open();
            cmd.ExecuteNonQuery();

            /* Pulizia */
            cn.Close();
        }
    }
}