范型List初體驗

參考自PetShop4.0

protected List<DataAccess.Model.Category> GetCategorIEs(string strWhere)
    {
        List<DataAccess.Model.Category> categorIEs = new List<DataAccess.Model.Category>();
        StringBuilder strSql = new StringBuilder();
        strSql.Append("select CategoryId,CategoryName,ParentId,Description,AddedDate from Category ");
        if (strWhere.Trim() != "")
        {
            strSql.Append(" where " 

$False$

LOR: #000000">+ strWhere);
        }
        strSql.Append(" order by CategoryID ");
        SqlDataReader rdr = DataAccess.SQLServerDAL.DbHelperSQL.ExecuteReader(strSql.ToString());
        while (rdr.Read())
        {
            DataAccess.Model.Category cat =
                new DataAccess.Model.Category(int.Parse(rdr[0].ToString()),
                rdr[1].ToString(),
                int.Parse(rdr[2].ToString()),
                rdr[3].ToString(),
                DateTime.Parse(rdr[4].ToString()));
  

       categorIEs.Add(cat);
        }
        return categorIEs;
    }

綁定數據
List<DataAccess.Model.Category> categories = GetCategorIEs("ParentID=0");
 Response.Write(newcat.CategoryName);
 this.GridView1.DataSource = categorIEs;
 this.GridVIEw1.DataBind();

查找數據
DataAccess.Model.Category newcat = categorIEs.Find(
delegate(DataAccess.Model.Category model)
 {
        return model.CategoryName == "Packaging Materials"; 
 });