//select mediaobj by GalleryID public List <MediaObject> selectbyGalleryID(int ID) { List <MediaObject> result; using (var db = new MainDB()) { var dt = (DataTable)db.CallStoredProcedure("CMS_Gallery_GetbyID", new object[] { ID }, new string[] { "@ID" }, true); result = MediaObject.DataTableTpObj(dt); } return(result); }