public DataTable getDataSQLByID() { //same model call but using LINQ to filter DataTable dt = model.getDataSQL(); var dataRow = dt.AsEnumerable().Where(x => x.Field <string>("facidnum") == "498"); DataTable boundTable = dataRow.CopyToDataTable <DataRow>(); return(boundTable); }