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; }