类型转换出错了
以下代码不能将查询结果显示到dataGridView1,dataGridView1.DataSource = query.ToList; 有错误,请赐教。
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace WindowsFormsApp1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt.Columns.Add("Id", typeof(int));
dt.Columns.Add("Name", typeof(string));
dt.Columns.Add("Dept", typeof(string));
DataRow dr = dt.NewRow();
dr["Id"] = 8866;
dr["Name"] = "Jack";
dr["Dept"] = "技术部";
dt.Rows.Add(dr);
var query = from r in dt.AsEnumerable()
select new
{
name = r["Name"].ToString(),
dept = r["Dept"].ToString()
};
foreach (var item in query)
{
richTextBox1.Text += "姓名:" + item.name + "部门:" + item.dept + "\n";
}
dataGridView1.DataSource = query.ToList; //这里出错了
}
}
}
CS0428 无法将方法组“ToList”转换为非委托类型“object”