LINQ查询数据表 [英] LINQ query datatable

问题描述

我想在数据表中使用此dq并且还希望在网格视图中绑定数据

I want to this dq in data table and also want bind data in grid view

code

code

  [WebMethod]
    public static string search_data(DateTime fromdate, DateTime todate,  
    string regiondrop)
    {
        try
        {   T1 ts = new T1();
            var dq = //here is LINQ query which is long so i cant paste  
            here.........  .ToList();
            GridView1.DataSource = dt;
            GridView1.DataBind();

        }
        catch (Exception)
        {
            GridView1.Visible = false;
            Label4.Text = ("No Data");
        }

任何解决方案

any solution

推荐答案

 var result = from c in objDataContext.Employees
                         where c.EmployeeAge >= 20
                         select c;                
            List<Employee> lstEmployee = result.ToList();
            gridviewEmp.DataSource = lstEmployee;
            gridviewEmp.DataBind();

这段代码不适合你？

This code work, not for you?

这篇关于LINQ查询数据表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！