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

Restore the lost focus of Auto post back controls in asp.net update Panel control

Disable backspace key using Jquery

Angular User Session Timeout example step by step

Add Comma automatically while entering amounts in textbox using Javascript

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

Implement Nlog in .Net core MVC application part 1

Clone a generic list in C# using extension method

Send bulk Email in asp.net using excel file

Devexpress Datebox date formatting in angular 6 with example