数据库查询后结果是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类型了