Linq query to DataTable
-
How do I convert a Linq Query to a DataTable. Code Follows ? using (EmployeeDataContext empCtx = new EmployeeDataContext(GlobalMethods.SqlConnectionString)) { var rsEmp = from emp in empCtx.Employees join payp in empCtx.PayPeriods on emp.PayperiodID equals payp.PayPeriodID join rst in empCtx.Rosters on emp.RosterID equals rst.RosterID join dep in empCtx.Departments on emp.DepartmentID equals dep.DepartmentID join div in empCtx.Divisions on emp.DivisionID equals div.DivisionID join cst in empCtx.CostCentres on emp.CostCentreID equals cst.CostCentreID join grp in empCtx.Groups on emp.GroupID equals grp.GroupID where emp.OrganizationID == UserClass.OrganizationID orderby emp.EmployeeNumber select new { emp.EmployeeID, emp.EmployeeNumber, emp.EmployeeName, emp.Surname, emp.BadgeNumber, payp.PayPeriodName, rst.RosterName, div.DivisionName, dep.DepartmentName, cst.CostCentreName, grp.GroupName, emp.EmploymentStatus, emp.EndOfEmployment }; DataTable myTable = (DataTable)rsEmp; DataView filteredData = new DataView(myTable); dataGridView1.DataSource = filteredData; //Or //OR DataTable myTable = rsEmp.CopyToDataTable(); dataGridView1.DataSource = myTable ; }
-
How do I convert a Linq Query to a DataTable. Code Follows ? using (EmployeeDataContext empCtx = new EmployeeDataContext(GlobalMethods.SqlConnectionString)) { var rsEmp = from emp in empCtx.Employees join payp in empCtx.PayPeriods on emp.PayperiodID equals payp.PayPeriodID join rst in empCtx.Rosters on emp.RosterID equals rst.RosterID join dep in empCtx.Departments on emp.DepartmentID equals dep.DepartmentID join div in empCtx.Divisions on emp.DivisionID equals div.DivisionID join cst in empCtx.CostCentres on emp.CostCentreID equals cst.CostCentreID join grp in empCtx.Groups on emp.GroupID equals grp.GroupID where emp.OrganizationID == UserClass.OrganizationID orderby emp.EmployeeNumber select new { emp.EmployeeID, emp.EmployeeNumber, emp.EmployeeName, emp.Surname, emp.BadgeNumber, payp.PayPeriodName, rst.RosterName, div.DivisionName, dep.DepartmentName, cst.CostCentreName, grp.GroupName, emp.EmploymentStatus, emp.EndOfEmployment }; DataTable myTable = (DataTable)rsEmp; DataView filteredData = new DataView(myTable); dataGridView1.DataSource = filteredData; //Or //OR DataTable myTable = rsEmp.CopyToDataTable(); dataGridView1.DataSource = myTable ; }
-
Have you tried this method ? I get an error on PropertyInfo[] oProps = null; Where is this created ?