DataTable列过滤不拉入值

// 获取DataTable对象
DataTable dataTable = GetDataTable();

// 确定要进行过滤的列
DataColumn[] filterColumns = new DataColumn[] { dataTable.Columns["ColumnName1"], dataTable.Columns["ColumnName2"] };

// 筛选条件
string filterExpression = "ColumnName1 = 'Value1' AND ColumnName2 > 10";

// 过滤列数据
DataRow[] filteredRows = dataTable.Select(filterExpression);

// 创建新的DataTable对象用于存储过滤后的列数据
DataTable filteredDataTable = dataTable.Clone();

// 将过滤后的列数据复制到新的DataTable对象中
foreach (DataRow row in filteredRows)
{
    DataRow newRow = filteredDataTable.NewRow();
    foreach (DataColumn column in filterColumns)
    {
        newRow[column.ColumnName] = row[column.ColumnName];
    }
    filteredDataTable.Rows.Add(newRow);
}

// 进行后续操作，如显示过滤后的列数据
DisplayFilteredData(filteredDataTable);