怎么取得bindingsorce筛选后的数据
代码示例:
sqlOpr sqlopr = new sqlOpr();
DataTable dt = sqlopr.GetTableBySql("select top 10 FName from Lis_lab_bill where FName is not null and FName <> ''", "LIS_TEST");
bindingSource1.DataSource = dt;
bindingSource1.Filter = "FName like '2018%'";
//方法一:直接用bindingsource.List
DataView dv = (DataView)bindingSource1.List;
DataTable table1 = dv.ToTable();
//方法二:手动构造
DataTable table = dt.Clone();
foreach (DataRowView drv in bindingSource1)
{
DataRow dr = table.NewRow();
dr["FName"] = drv["FName"].ToString();
table.Rows.Add(dr);
}