写了个数据访问的

Question

但不知道怎么把记录集转化为一个List<CityBase>
代码如下public List<CityBase> ExecuteBySql(string sql)
        {
            List<CityBase> city;
            con = new OracleConnection();
            con.ConnectionString = CONNECTION_STRING;
            try
            {
                con.Open();
            }
            catch(Exception ex)
            {
                throw ex;
            }            cmd = con.CreateCommand();
            cmd.CommandText = sql;
            cmd.Connection = con;
            cmd.CommandType = CommandType.Text;
            da = new OracleDataAdapter();
            da.SelectCommand = cmd;
            try
            {
                da.Fill(city);    //  【就这里】
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return city;
        }

Answer 1

 public virtual List<TBArea> TBAreas(int PageIndex, int PageSize, string queryString)
        {
            List<TBArea> values = new List<TBArea>();
            string tableName = "TBArea";
            string orderBy = "ID";
            using (IDataReader dr = Gateway.Default.Select(tableName, PageIndex, PageSize, queryString, orderBy, true))
            {
                while (dr.Read())
                    values.Add(PopulateTBArea(dr) as TBArea);
            }            return values;
        }
        protected object PopulateTBArea(IDataReader dr)
        {
            TBArea entity = new TBArea();
            if (!Convert.IsDBNull(dr["ID"])) entity.ID = Convert.ToInt32(dr["ID"]);//编号
            if (!Convert.IsDBNull(dr["Name"])) entity.Name = Convert.ToString(dr["Name"]);//名称
            if (!Convert.IsDBNull(dr["Description"])) entity.Description = Convert.ToString(dr["Description"]);//描述            return entity;
        }

Answer 2

你已经定义了泛型List <CityBase> 你还需要有一个CityBase的实体类，数据库每条记录生成一个CityBase对应的实体类,例如CityBase的实体类就是CityBase
CityBase CB=new CityBase(这里用SqldataReader读取数据库的每条记录的各个字段，填充到实体类)List <CityBase> CBList=new List <CityBase>()
CBList.Add(CB)
最后把你要绑定的控件的DataSource等于CBList

Answer 3

你去msdn看看泛型的知识就会了