DataTavble 使用Linq查询数据

定义一个数据实体
Public class QjcxAlll1
{
	public string fpdm{get;set;}
	public string fphm{get;set;}
	public string sdfphm{get;set;}
	public string gxzt{get;set;}
	public string sbny{get;set;}
	public bool isselect{get;set;}
	public QjcxAlll1(DataRow row){
	    Initial(row);
	}
    private void Initial(DataRow row){
		fpdm=row.Table.Columns.Contains("fpdm")?row["fpdm"].Tostring():"";
		fphm=row.Table.Columns.Contains("fphm")?row["fphm"].Tostring():"";
		sdfphm=row.Table.Columns.Contains("sdfphm")?row["sdfphm"].Tostring():"";
		gxzt=row.Table.Columns.Contains("gxzt")?row["gxzt"].Tostring():"";
		sbny=row.Table.Columns.Contains("sbny")?row["sbny"].Tostring():"";
		isselect=row.Table.Columns.Contains("isselect")?Convert.ToBoolean(row["isselect"].Tostring()):false;
	}
}

新建DataTable
DataTable dt1=new DataTable();
dt1.Columns.Add("fpdm");
dt1.Columns.Add("fphm");
dt1.Columns.Add("sdfphm");
dt1.Columns.Add("gxzt");
dt1.Columns.Add("isselect");
dt1.Columns.Add("sbny");

DataRow dr=dt1.NewRow();
dr["fpdm"]="1";
dr["fphm"]="2";
dr["sdfphm"]="3";
dr["gxzt"]="1";
dr["sbny"]="202301";
dr["isselect"]=true;

DataRow dr1=dt1.NewRow();
dr["fpdm"]="4";
dr["fphm"]="5";
dr["sdfphm"]="6";
dr["gxzt"]="1";
dr["sbny"]="202301";
dr["isselect"]=true;

DataRow dr2=dt1.NewRow();
dr["fpdm"]="7";
dr["fphm"]="8";
dr["sdfphm"]="9";
dr["gxzt"]="2";
dr["sbny"]="202302";
dr["isselect"]=true;

DataRow dr3=dt1.NewRow();
dr["fpdm"]="10";
dr["fphm"]="11";
dr["sdfphm"]="12";
dr["gxzt"]="3";
dr["sbny"]="202303";
dr["isselect"]=false;

var salts=dt1.AsEnumerable().Select(x=>QjcxAlll1(x)).ToList();
//salts得到的值是List<QjcxAlll1> ,可以计算Count和遍历具体对象。