Hi Team,
I am trying to filter excel column "Filter Flag" with the value "Y" , using Data Table option for this but the code giving this kind of error.
outData = new DataTable();
if(inData.Rows.Count > 0)
{
var result = inData.AsEnumerable().Where(row=>row["Filter Flag"].ToString() == FilterFlag.ToString());
outData = inData.Clone();
foreach(var rowItem in result)
{
outData.ImportRow(rowItem);
}
}
I am trying to filter excel column "Filter Flag" with the value "Y" , using Data Table option for this but the code giving this kind of error.
outData = new DataTable();
if(inData.Rows.Count > 0)
{
var result = inData.AsEnumerable().Where(row=>row["Filter Flag"].ToString() == FilterFlag.ToString());
outData = inData.Clone();
foreach(var rowItem in result)
{
outData.ImportRow(rowItem);
}
}