using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;


using System.Collections;

using System.Data.SqlClient;
using System.Data.OleDb;


using System.Xml.Serialization;


public class mieprocedure: System.Web.UI.Page
{
    // # 0
    public void uploadDataByQuery(string query)
    {
        String connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("mdb-database/miodb.mdb");
        OleDbConnection cn = new OleDbConnection(connString);
        // Apro la connessione
        cn.Open();

        OleDbCommand cmd = new OleDbCommand(query, cn);
        cmd.ExecuteNonQuery();
        
    }
    // # 1
    public OleDbDataReader recuperaDataByQuery(string query)
    {
        OleDbDataReader aReader = null;
        String connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("mdb-database/miodb.mdb");
        OleDbConnection cn = new OleDbConnection(connString);
        try
        {
            cn.Open();        
            OleDbCommand cmd = new OleDbCommand(query, cn);        
            aReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            
        }
        catch (Exception ex)
        {
            
        }
        
        return aReader;
        cn.Close();    
    }    
}