c# winform datagridview

ShanShanYouWen 2010-01-27 07:16:20

string s = "select exam_done.No,student.name,exam_done.Content,exam_done.Options,exam_answer.option_name,exam_done.test_time from exam_done,student,exam_answer,exam_paper where exam_done.StudentNo=student.stu_num and exam_done.No=exam_paper.exam_id and exam_paper.qid=exam_answer.qid and exam_done.StudentNo='" + Num + "' and exam_answer.answer='1' and exam_done.sid=1 or exam_done.sid=2";

我想将以上信息绑定到 datagridview控件上我用的是access数据库还请高手帮忙修改谢谢！！
OleDbDataAdapter adapter = new OleDbDataAdapter(s, dblink.conn);
OleDbCommandBuilder commandBuilder = new OleDbCommandBuilder(adapter);
DataTable table = new DataTable() ;
adapter.Fill(table);
this.dGrid.DataSource = table;
this.dGrid.Columns[0].HeaderText = "xxx";
this.dGrid.Columns[1].HeaderText = "xxx";
this.dGrid.Columns[2].HeaderText = "xxx";
this.dGrid.Columns[3].HeaderText = "xxx";
this.dGrid.Columns[4].HeaderText = "xxx";
this.dGrid.Columns[5].HeaderText = "xxx";
这是列名

...全文

84 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

hhhglj_hhhglj 2010-01-27

打赏
举报

顶

wuyq11 2010-01-27

打赏
举报

s单步看看在查询分析器执行看看

退一步海阔天空l忍一时风平浪静 2010-01-27

打赏
举报

[Quote=引用 1 楼 wuyq11 的回复:]
dataGridView1.Columns.Add("columnName","headerText");
dataGridView1.AutoGenerateColumns = false;
或AutoGenerateColumns =true;
[/Quote]

如梦每次都是代码一贴了事........汗........

Taiyangchen 2010-01-27

打赏
举报

[Quote=引用 3 楼 wtpmcheng 的回复:]
换成DataSet试试。。
DataSet ds = new DataSet();
adapter.Fill(ds);

[/Quote]

up

CqCoder 2010-01-27

打赏
举报

WTPMCheng 2010-01-27

打赏
举报

换成DataSet试试。。
DataSet ds = new DataSet();
adapter.Fill(ds);

ShanShanYouWen 2010-01-27

打赏
举报

[Quote=引用 1 楼 wuyq11 的回复:]
dataGridView1.Columns.Add("columnName","headerText");
dataGridView1.AutoGenerateColumns = false;
或AutoGenerateColumns =true;
[/Quote]

我想问一下为什么
adapter.Fill(table);
这一句会出现至少少一个参数的错误提示

wuyq11 2010-01-27