Beispiel #1
0
        public DataSet getDataSQLByID(string FACidnum)
        {
            //same model call but using LINQ to filter
            DataTable dt = model.getDataSQL();

            var dataRow = dt.AsEnumerable().Where(x => x.Field <string>("FACidnum") == FACidnum);

            if (dataRow.Count <DataRow>() > 0)
            {
                DataTable boundTable = dataRow.CopyToDataTable <DataRow>();
                DataSet   ds         = new DataSet();
                ds.Tables.Add(boundTable);

                return(ds);
            }

            return(rtnNoCoursesFound());
        }