将数据集表转换为列表。 [英] Convert Dataset table to a List.
本文介绍了将数据集表转换为列表。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
您好,
尝试将数据集表格转换为列表。
无法解析符号''AsEnumerable''
谢谢!!
private void LoadAppointments()
{
var conn = new SqlConnection(ConnectionString);
var adapter = new SqlDataAdapter( LoadAppointment,conn);
var ds = new DataSet();
adapter.Fill(ds);
DataTable dataTable = ds.Tables [ 0 ];
var myData = ds.Tables [ 0 ]。AsEnumerable()。选择(r = > new
{
column1 = r.Field( column1),
column2 = r.Field( column2),
column3 = r.Field< decimal?> ( column3)
});
var list = myData.ToList();
}
解决方案
Quote:
你不能查询DataTable的Rows集合,因为DataRowCollection没有实现IEnumerable< t>。您需要使用DataTable的AsEnumerable()扩展
你需要每行地址 - 做这样的事情:
foreach(ds.Tables [0] .Rows中的DataRow行)
{
IEnumerable < 对象 > asEnumerable = row.ItemArray.AsEnumerable();
}
已添加参考
System.Data.DataExtensions;
Hello,
Trying to convert an Dataset table to a List.
Cannot Resolve Symbol ''AsEnumerable''
Thanks!!
[Edit - the code]
private void LoadAppointments()
{
var conn = new SqlConnection(ConnectionString);
var adapter = new SqlDataAdapter("LoadAppointment", conn);
var ds = new DataSet();
adapter.Fill(ds);
DataTable dataTable = ds.Tables[0];
var myData = ds.Tables[0].AsEnumerable().Select(r => new
{
column1 = r.Field("column1"),
column2 = r.Field("column2"),
column3 = r.Field<decimal?>("column3")
});
var list = myData.ToList();
}
解决方案
Quote:
You can''t query against the DataTable''s Rows collection, since DataRowCollection doesn''t implement IEnumerable<t>. You need to use the AsEnumerable() extension for DataTable
Please check the following links for solution:
Link 1[^]
Lİnk 2[^]
God luck,
OI
You need to address per row - do something like this:
foreach (DataRow row in ds.Tables[0].Rows) { IEnumerable<object> asEnumerable = row.ItemArray.AsEnumerable(); }
Added Reference
System.Data.DataExtensions;
这篇关于将数据集表转换为列表。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文