示例#1
0
        private static List<decimal> AllStartTimes(int crn)
        {
            FlyballDB db = new FlyballDB();
            StoredProcedure sp = db.Dog_StartDogTimesWithStart();
            sp.Command.AddParameter("@crn", crn,DbType.Int64);
            sp.Execute();
            IDataReader rdr = sp.ExecuteReader();

            List<decimal> times = new List<decimal>();

            while (rdr.Read())
            {
                if(rdr[1] != DBNull.Value)
                {
                    times.Add(Convert.ToDecimal(rdr[1]));
                }
            }
            return times;
        }