C# DataTable表格类型转list类型

数据库查询后结果是DataTable类型，需要转换为list类型，代码如下

public List<dynamic> DatatoTable(DataTable dt)

        {

            List<dynamic> list = new List<dynamic>();

            for (int i = 0; i < dt.Rows.Count; i++)

            {

                Dynamic_Record one = new Dynamic_Record();

                foreach (DataColumn columeName in dt.Columns)

                {

                    one[columeName.ColumnName] = dt.Rows[i][columeName.ColumnName];

                }

                list.Add(one);

            }

            return list;

        }

string strSQL = "select * from SecurityGroup";

DataTable Company = DBHelper.ExecuteTable(CommandType.Text, strSQL, null);

var newList = DatatoTable(Company); //转list类型

成功将dataTable类型转换成list类型了