写了个数据访问的

[aby913]

但不知道怎么把记录集转化为一个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;
}

[windsea123]

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;
}

[一天到晚游泳的鱼2016]

你已经定义了泛型List <CityBase>

你还需要有一个CityBase的实体类，数据库每条记录生成一个CityBase对应的实体类,例如CityBase的实体类就是CityBase
CityBase CB=new CityBase(这里用SqldataReader读取数据库的每条记录的各个字段，填充到实体类)

List <CityBase> CBList=new List <CityBase>()
CBList.Add(CB)
最后把你要绑定的控件的DataSource等于CBList

[一天到晚游泳的鱼2016]

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