以下代码报错,提示
public List<IDictionary> GetList(string SearchKey)
{
DataTable dt;
string connStr = ConfigurationManager.ConnectionStrings["udDJerpConnStr"].ConnectionString;
string sqlStr = "select * from ut_OrderDeliveryDetail where materialCodeCustomer like '%" + SearchKey + "%'";
using (SqlConnection con = new SqlConnection(connStr))
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter(sqlStr, con);
dt = new DataTable();
da.Fill(dt);
}
var result= (from c in dt.AsEnumerable()
select new
{
Id = c.Field<int>("Id"),
CustomerName = c.Field<string>("CustomerName"),
MaterialCodeCustomer = c.Field<string>("MaterialCodeCustomer")
}).ToList();
return result.ToList<IDictionary>();
}
以下代码可运行:
private List<IDictionary> ConvertToDictionary(DataTable dtObject)
{
var columns = dtObject.Columns.Cast<DataColumn>();
var dictionaryList = dtObject.AsEnumerable()
.Select(dataRow => columns
.Select(column =>
new { Column = column.ColumnName, Value = dataRow[column] })
.ToDictionary(data => data.Column, data => data.Value)).ToList().ToArray();
return dictionaryList.ToList<IDictionary>();
}