Get LINQ to SQL results into a DataTable in asp.net

Linq to sql is a microsofts powerful tool to develop critical application faster.In Linq to sql the query result is in Generic list of generic  ienumerable type.


 If you want result set in DataTable you need to convert this generic list result into datatable. To convert LINQ to SQL results into a DataTable use following Code


 DataClassesDataContext dc=new DataClassesDataContext();
        var results = dc.products.ToList();

        DataTable dt = new DataTable();
        List<product> lst = results;
        PropertyInfo[] props= typeof(product).GetProperties();
        foreach (var prop in props)
        {
            dt.Columns.Add(prop.Name);
        }
        foreach (var item in lst)
        {
            var rowa = new object[props.Length];

            for (int i = 0; i < props.Length; i++) 
            {
                rowa[i] = props[i].GetValue(item, null);
            
            }

            dt.Rows.Add(rowa);
        
        
        }

     
        GridView1.DataSource = dt;
       
        GridView1.DataBind();

Comments

  1. Wow, What an Excellent post. I really found this to much informative. It is what I was searching for. I would like to suggest you that please keep sharing such type of info. free classifieds ads in south africa

    ReplyDelete

Post a Comment

Popular posts from this blog

Implement Logging in CSV file using Nlog in .net core MVC application- part 2

Implement Nlog in .Net core MVC application part 1

Angular User Session Timeout example step by step

Devexpress Datebox date formatting in angular 6 with example

Disable backspace key using Jquery