DataSet数据集转化为集合
/// /// 1step:定义实体类 ///
class PhoneNum {
int pId;
public int PId {
get { return pId; } set { pId = value; } }
int pTypeId;
public int PTypeId {
get { return pTypeId; } set { pTypeId = value; } }
string pName;
public string PName {
get { return pName; } set { pName = value; } }
string pCellPhone;
public string PCellPhone {
get { return pCellPhone; } set { pCellPhone = value; } }
string pHomePhone;
public string PHomePhone {
get { return pHomePhone; } set { pHomePhone = value; } } }
/// /// 2step:定义转化的⽅法 ///
/// ///
public static List GetPNList(DataTable dt) //定义静态⽅法，传递DataTable参数 {List pnlist = null; //定义⼀个list<实体类>集合为空if (dt.Rows.Count > 0) //判断获得的DataTable是否有数据，如果有，则实例化List<>集合，否则返回空集合 {
pnlist = new List(); } else {return pnlist; }
foreach (DataRow item in dt.Rows) // 遍历DataTable中的⾏ {
PhoneNum temp = new PhoneNum(); //将实体类实例化
temp.PId = (int)item[\"pid\"]; //将DataTable⾏中的对应字段数据赋值给实体属性 temp.PTypeId = (int)item[\"ptypeid\"];
temp.PName = item[\"pname\"].ToString();
temp.PCellPhone = item[\"pcellphone\"].ToString(); temp.PHomePhone = item[\"phomephone\"].ToString(); pnlist.Add(temp); //List<>集合添加赋值后的⾏ }
return pnlist; //返回赋值后的List<>集合 }
