List<DataRow> result = new List<DataRow>();
/*
result = (from x in dt.AsEnumerable() where
(x.Field<string>("Code").ToLower().Contains(Value) ||
x.Field<string>("Description").ToLower().Contains(Value)) &&
(x.Field<bool>("Active") == true)
select x).ToList();
*/
result = (from x in dt.AsEnumerable() where x.Field<bool>("Active") == true select x).ToList();
if (result.Count >= 1)
{
dt = result.CopyToDataTable();
Bridge.InPut.Code = dt.Rows[0]["Code"].ToString().Trim();
Bridge.InPut.Description = dt.Rows[0]["Description"].ToString().Trim();
return;
}