public List <Budget_Categories_Banner> SelectAll() { List <Budget_Categories_Banner> Categories_BannerList = null; try { string sSQL = "SELECT * FROM Categories_Banner"; DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL); if (ds.Tables[0].Rows.Count > 0) { Categories_BannerList = new List <Budget_Categories_Banner>(); Budget_Categories_Banner categories = null; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { categories = new Budget_Categories_Banner(); categories.CategoriesCode = ds.Tables[0].Rows[i]["CategoriesCode"].ToString(); categories.CategoriesName = ds.Tables[0].Rows[i]["CategoriesName"].ToString(); Categories_BannerList.Add(categories); } } } catch (Exception ex) { } return(Categories_BannerList); }
public Budget_Categories_Banner SelectByCode(string CategoriesCode) { Budget_Categories_Banner categories = null; try { string sSQL = "SELECT * FROM Categories_Banner WHERE CategoriesCode=@CategoriesCode"; SqlParameter[] sqlParam = new SqlParameter[1]; sqlParam[0] = new SqlParameter("@CategoriesCode", SqlDbType.NVarChar); sqlParam[0].Value = CategoriesCode; DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL, sqlParam); if (ds.Tables[0].Rows.Count > 0) { categories = new Budget_Categories_Banner(); categories.CategoriesCode = Convert.ToString(ds.Tables[0].Rows[0]["CategoriesCode"]); categories.CategoriesName = Convert.ToString(ds.Tables[0].Rows[0]["CategoriesName"]); } } catch (Exception ex) { } return(categories); }