c# winform datagridview

Question

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";
这是列名

Answer 1

dataGridView1.Columns.Add("columnName","headerText");
dataGridView1.AutoGenerateColumns = false;
或AutoGenerateColumns =true;

Answer 2

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

Answer 3

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