Skip to main content

Converting List to DataTable in C#

public static DataTable ConvertToDataTable<T>(IList<T> data)
        {
            PropertyDescriptorCollection properties =
               TypeDescriptor.GetProperties(typeof(T));
            DataTable table = new DataTable();
            foreach (PropertyDescriptor prop in properties)
                table.Columns.Add(prop.Name, Nullable.GetUnderlyingType(prop.PropertyType) ?? prop.PropertyType);
            foreach (T item in data)
            {
                DataRow row = table.NewRow();
                foreach (PropertyDescriptor prop in properties)
                    row[prop.Name] = prop.GetValue(item) ?? DBNull.Value;
                table.Rows.Add(row);
            }
            return table;

        }

Comments

Popular posts from this blog

Introducing SignalR

Introduction: Asp.net signalR is an open source library for asp.net developers.it is used to implement real time functionality in web application. requirements: signalR is not included in visual studio so far(vs 10 and vs 12) by default.It can be implemented in .net framework 4.0 and higher. so you need vs 2010 or vs 2012 to start taking the advantage of signalR. I will guide you trough the installation of signalR for your project . Lets get ready with the visual studio 2010 or 2012. I am going to use visual studio 2012 here. Firstly open up a new project. now open a Package Manager Console. if you didn't find it click View and go over to other window you find it there or go to Tools>Library Package Manager Console >Package Manager Console  make a command in console :Install-Package Microsoft.AspNet.signalR  Scroll down the generated text in console few files are downloaded which contains the asp.net server side  signaR and client side signalR ...