linq to sql绑定到datagridview控件的问题
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
string connection = "address = king001 ; initial catalog = STUDENTDB ; trusted_connection = true";
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
DataContext db = new DataContext(connection);
Table<Course_info> couTable = db.GetTable<Course_info>();
var result =from c in couTable
where c.course_id < 10
select c;
dataGridView1.DataSource = result;
//dataGridView1.DataSource = result.ToList();
}
}
}
如题,linq to sql的方式查询出来的结果想要绑定到winform应用程序的dataGridView中,上面的代码语法没有问题,但是数据就是显示不出来,打断点调试发现result中是有数据的,就是绑定这里没数据。在网上也找了很多说要ToList()后再绑,一样没用,走投无路了,只能求大神解答了