convert generic list to datatable in Asp.Net C#,VB

convert generic list to datatable in Asp.Net C#,VB

Today, We want to share with you convert generic list to datatable in Asp.Net C#,VB.
In this post we will show you Converting Generic List into DataTable, hear for c# – How to convert a list into data table we will give you demo and example for implement.
In this post, we will learn about Converting Generic List into DataTable with an example.

Introduction

In this post, I will explain how you can convert generic list to DataTable. In the below example I am having a list of colors that I will convert to DataTable.

Example : Convert generic list to DataTable

 private void FillData()
  {
  List _ColorList = new List(); // List to be converted into DataTable
  _ColorList.Add("Red");
  _ColorList.Add("White");
  _ColorList.Add("Black");
  _ColorList.Add("Green");
  _ColorList.Add("Blue");
  DataTable _ResultDataTable = ConvertListToDataTable(_ColorList);
  }

 public static DataTable ConvertListToDataTable(IList p_ColorList)
  {
  DataTable _DataTable = new DataTable();
  if (typeof(T).IsValueType || typeof(T).Equals(typeof(string)))
  {
  DataColumn _DataColumn = new DataColumn("ColorList");
  _DataTable.Columns.Add(_DataColumn);

  foreach (T item in p_ColorList)
  {
  DataRow dr = _DataTable.NewRow();
  dr[0] = item;
  _DataTable.Rows.Add(dr);
  }
  }
  else
  {
  PropertyInfo[] _PropertyInfo = typeof(T).GetProperties();
  foreach (PropertyInfo pi in _PropertyInfo)
  {
  DataColumn dc = new DataColumn(pi.Name, pi.PropertyType);
  _DataTable.Columns.Add(dc);
  }

  for (int item = 0; item < p_ColorList.Count(); item++)
  {
  DataRow _DataRow = _DataTable.NewRow();
  for (int property = 0; property < _PropertyInfo.Length; property++)
  {
  _DataRow[property] = _PropertyInfo[property].GetValue(p_ColorList[item], null);
  }
  _DataTable.Rows.Add(_DataRow);
  }
  }
  _DataTable.AcceptChanges();
  return _DataTable;
  }

Read :

READ :  AngularJS AutoComplete Search Dynamic Data using Web API

Summary

You can also read about AngularJS, ASP.NET, VueJs, PHP.

I hope you get an idea about Converting Generic List into DataTable.
I would like to have feedback on my Infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.

We hope you get an idea about Converting Generic List into DataTable
We would like to have feedback on my Information blog .
Your valuable any feedback, Good question, Inspirational Quotes, or Motivational comments about this article are always welcome.
If you liked this post, Please don’t forget to share this as Well as Like FaceBook Page.

READ :  ASP.NET UpdateProgress control Tutorial with Examples

We hope This Post can help you…….Good Luck!.

Searches related to : Converting Generic List into DataTable

  • Converting Generic List into DataTable
  • List to Datatable Converter Using C#
  • Convert Generic List to Data Table
  • How to convert generic list to datatable
  • Convert a Generic List to a Datatable
  • C# Convert List to DataTable (DataGridView)
  • How to convert generic list to datatable in Asp.Net C#,VB

Add a Comment

Your email address will not be published. Required fields are marked *