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