Пример #1
0
        public static List <type_> get()
        {
            string r = "select * from type_ ";

            SqlConnection conn = null;

            SqlDataReader SDR = sql_code.run_query(r, ref conn
                                                   );

            List <type_> types = new List <business.type_>();

            for (; SDR.Read();
                 )
            {
                type_ type = get(SDR);

                types.Add(type);
            }

            SDR.Close();

            SDR.Dispose();

            conn.Close();

            conn.Dispose();

            return(types);
        }
Пример #2
0
        public static type_ get(int ID
                                )
        {
            string r = "select * from type_ " + "where " +
                       "ID = " + ID;

            SqlConnection conn = null;


            SqlDataReader SDR = sql_code.run_query(r, ref conn
                                                   );
            type_ type = null;

            if (SDR.Read()
                )
            {
                type = get(SDR);
            }

            SDR.Close();

            SDR.Dispose();

            conn.Close();

            conn.Dispose();

            return(type);
        }