Preview:
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;
}
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter