C#实现DataTable转换成IList的方法

2019-12-26 18:10:46丽君

namespace TBToListTest
{
  //实体
  public class Person
  {
    public int ID
    {
      set;
      get;
    }
    public string Name
    {
      set;
      get;
    }
    public string Age
    {
      set;
      get;
    }
    public string Lover
    {
      set;
      get;
    }
  }
}


using System;
using System.Data;
namespace TBToListTest
{
  class Program
  {
    static void Main(string[] args)
    {
      TBToList<Person> tol = new TBToList<Person>();
      Console.WriteLine();
      DataTable dt = GetTable();
      tol.ToList(dt);
      Console.Read();
    }
    public static DataTable GetTable()
    {
      DataTable dt = new DataTable();
      dt.Columns.Add("ID");
      dt.Columns.Add("Age");
      dt.Columns.Add("Lover");
      dt.Columns.Add("Name");
      DataRow dr = dt.NewRow();
      dr["ID"] = 1;
      dr["Age"] = "Age1";
      dr["Lover"] = "Lover1";
      dr["Name"] = "Name1";
      dt.Rows.Add(dr);
      DataRow dr1 = dt.NewRow();
      dr1["ID"] = 2;
      dr1["Age"] = "Age2";
      dr1["Lover"] = "Lover2";
      dr1["Name"] = "Name2";
      dt.Rows.Add(dr1);
      return dt;
    }
  }
}
 

注:相关教程知识阅读请移步到c#教程频道。