SoFunction
Updated on 2025-04-13

Parameterized query of ACCESS, attached to VBSCRIPT (ASP) and C# functions, page 2/2


using System;
using ;
using ;
using ;
using ;
namespace acc_select
{
    /// <summary>
Summary of accelect
    /// </summary>
    public class accselect
    {
    //"Provider=.4.0; Data Source=d:\dq\"
        private string conn = ["tsingConnectionString"].ToString();
        public string sql = ;
        public int t = 4;
        public object v = null;
        public accselect()
        {
        }
        /// <summary>
/// Constructor, passing ACC parameter query statement
        /// </summary>
/// <param name="strsql">strsql character type</param>
        public accselect(string strsql)
        {
            sql = strsql;
        }
        /// <summary>
/// Constructor, passing ACC parameter query statement
        /// </summary>
/// <param name="strsql">parameter query statement</param>
/// <param name="total">bytes</param>
        public accselect(string strsql, int total)
        {
            sql = strsql;
            t = total;
        }
        /// <summary>
/// Constructor
        /// </summary>
/// <param name="strsql">parameter query statement</param>
/// <param name="total">bytes</param>
/// <param name="value">OBJECT value</param>
        public accselect(string strsql, int total, object value)
        {
            sql = strsql;
            t = total;
            v = value;
        }
        /// <summary>
///             ///                                               �
        /// </summary>
/// <param name="odt">Define OleDbType Type</param>
        /// <returns></returns>
        public OleDbDataReader getOdd(OleDbType odt)
        {
            OleDbConnection conns = new OleDbConnection();
            OleDbCommand cmd = new OleDbCommand(, conns);
            OleDbParameter parm = new OleDbParameter("temp", odt, );
             = ;
            (parm);
            [0].Value = ;
            ();
            OleDbDataReader oda = ();
            ();
            return oda;
        }
        string Sql
        {
            get
            {
                return sql;
            }
            set
            {
                sql = value;
            }
        }
        int T
        {
            get
            {
                return t;
            }
            set
            {
                t = value;
            }
        }
        object V
        {
            get
            {
                return v;
            }
            set
            {
                v = value;
            }
        }
    }
}
//Calling method
//accselect acc = new accselect();
// = "select * from dtt where d_id=?";
// = 10;
// = 1;
//OleDbDataReader oda = ();
// = oda;
//();