public static DataSet GetAll(string StartDate, string EndDate) { using (DataManager oDm = new DataManager()) { oDm.Add("@pStartDate", SqlDbType.DateTime, Convert.ToDateTime(StartDate)); oDm.Add("@pEndDate", SqlDbType.DateTime, Convert.ToDateTime(EndDate)); oDm.CommandType = CommandType.StoredProcedure; DataSet ds = new DataSet(); return(oDm.GetDataSet("usp_PotatoRate_GetAll", ref ds, "Table1")); } }