还有 var result = from b in db.Book join bc in db.BookCategory on b.ID equals bc.BookID where bc.CategoryID == categoryID orderby b.PublishDate descending select b; 你确定这是C#的语法??
ShowData()这个函数没有执行 怎么解决?
使用DataGridView绑定数据库数据显示在页面上示例 private void Form1_Load(object sender, EventArgs e) { SqlDataAdapter sda = new SqlDataAdapter(//创建SqlDataAdapter对象 "select * from tb_student", "server=WRET-MOSY688YVW\\MRGLL;database=db_test;Trusted_Connection=true"); DataSet ds = new DataSet();//创建数据集DataSet对象 sda.Fill(ds);//调用SqlDataAdapter对象的Fill()方法填充数据集 dataGridView1.DataSource = ds.Tables[0];//将数据集绑定到DataGridView1控件 }
var result = from b in db.Book
join bc in db.BookCategory on b.ID equals bc.BookID
where bc.CategoryID == categoryID
orderby b.PublishDate descending
select b;
你确定这是C#的语法??
private void Form1_Load(object sender, EventArgs e)
{
SqlDataAdapter sda = new SqlDataAdapter(//创建SqlDataAdapter对象
"select * from tb_student",
"server=WRET-MOSY688YVW\\MRGLL;database=db_test;Trusted_Connection=true");
DataSet ds = new DataSet();//创建数据集DataSet对象
sda.Fill(ds);//调用SqlDataAdapter对象的Fill()方法填充数据集
dataGridView1.DataSource = ds.Tables[0];//将数据集绑定到DataGridView1控件
}