foreach (var dataRow in dr)
{
filtre.ImportRow(dataRow);
}
Of what use is your foreach statement since you are just returning a row ? Are you trying to get the columns in the row because
dr is already a datarow. You can use this to just add the retrieved row
if (dr != null)
{
filtre.ImportRow(dr);
}