Ejemplo n.º 1
0
        /*************************************************************************/

        public List <Dictionary <string, string> > SelectDct(string Sql)
        {
            OdbcConnection Conn = getConnection();
            OdbcCommand    cmd;
            OdbcDataReader DaRd;
            int            i   = 0;
            int            col = 0;
            string         str;
            List <Dictionary <string, string> > ListDct = new List <Dictionary <string, string> >();

            try
            {
                cmd = new OdbcCommand(Sql, Conn);
                cmd.CommandTimeout = 6000;
                DaRd = cmd.ExecuteReader();
                col  = DaRd.FieldCount;
                while (DaRd.Read())
                {
                    Dictionary <string, string> DctStr = new Dictionary <string, string>();
                    for (i = 0; i < col; i++)
                    {
                        str = DaRd.IsDBNull(i) ? "" : DaRd.GetValue(i).ToString();
                        DctStr.Add(DaRd.GetName(i), str);
                    }
                    ListDct.Add(DctStr);
                }
            }
            catch (Exception)
            {
                ListDct = new List <Dictionary <string, string> >();
            }
            Conn.Close();
            return(ListDct);
        }
Ejemplo n.º 2
0
        public ArrayList SelectAry(string Sql)
        {
            OdbcConnection Conn = getConnection();
            OdbcCommand    cmd;
            OdbcDataReader DaRd;
            int            i   = 0;
            int            col = 0;
            string         str;

            ArrStr = new ArrayList();
            TotCnt = 0;
            ActCnt = 0;
            RtnCnt = 0;
            try
            {
                cmd = new OdbcCommand(Sql, Conn);
                cmd.CommandTimeout = 6000;
                DaRd = cmd.ExecuteReader();
                col  = DaRd.FieldCount;
                string cnm = "";
                for (i = 0; i < col; i++)
                {
                    cnm += DaRd.GetName(i) + ",";
                }
                while (DaRd.Read())
                {
                    TotCnt++;
                    if (TotCnt >= FstCnt)
                    {
                        ActCnt++;
                        if ((SelCnt != 0) && (ActCnt > SelCnt))
                        {
                            break;
                        }
                        str = "";
                        try
                        {
                            for (i = 0; i < col; i++)
                            {
                                if (DaRd.GetValue(i) == null)
                                {
                                    str += "^";
                                }
                                else
                                {
                                    str += DaRd.GetValue(i).ToString().Replace("^", "") + "^";
                                }
                            }
                            ArrStr.Add(str);
                        }
                        catch (Exception) { }
                    }
                }
                DaRd.Close();
                cmd.Cancel();
            }
            catch (Exception)
            {
                ArrStr = new ArrayList();
            }

            Conn.Close();
            DaRd = null;
            cmd  = null;
            Conn = null;

            return(ArrStr);
        }