コード例 #1
0
        public static DataSet GetDataSetStatic(string storedProcedureName, List <SqlParameter> parameters, ref int returnValue)
        {
            DBLayer dbLayer = new DBLayer();
            DataSet result  = dbLayer.GetDataSet(storedProcedureName, parameters, ref returnValue);

            dbLayer.Dispose();
            return(result);
        }
コード例 #2
0
        internal static List <T> CreateObjectListFromDataSet <T>(DataSet ds, object objectToFill)
        {
            List <T> result = new List <T>();

            // also have to maintain count to expand and copy
            if (DBLayer.ValidateHasRows(ds))
            {
                foreach (DataRow row in ds.Tables[0].Rows)
                {
                    result.Add(CreateObjectFromDataRow <T>(row, objectToFill));
                }
            }

            return(result);
        }