public List <CategoryRS> Get_CategoryDetails(string Name) { List <CategoryRS> lstcategoryRS = new List <CategoryRS>(); try { DataTable dt = new DataTable(); List <SqlParameter> sqlParameters = new List <SqlParameter>(); sqlParameters.Add(new SqlParameter("@CategoryName", Name)); dt = DBconnection.FillDataTable(SPNames.GetItemsByName, sqlParameters.ToArray()); for (int i = 0; i < dt.Rows.Count; i++) { CategoryRS categoryRS = new CategoryRS(); categoryRS.CategoryName = dt.Rows[i]["CategoryName"].ToString(); categoryRS.SubCategoryName = dt.Rows[i]["SubCategoryName"].ToString(); categoryRS.ItemName = dt.Rows[i]["ItemName"].ToString(); categoryRS.ItemDescription = dt.Rows[i]["Description"].ToString(); lstcategoryRS.Add(categoryRS); } } catch (Exception ex) { throw ex; } return(lstcategoryRS); }