Datagridview绑定dataset数据

Datagridview绑定dataset数据

this.dataGridView1.AutoGenerateColumns = true; 

OleDbConnection con1 = data_con1.oleCon();
 string sql1 = "select      EmpolyInfo.EName,EmpolyInfo.ECard,EmpolyInfo.ETel,EmpolyInfo.EState,Department.Departname,PostInfo.PPostname from EmpolyInfo,PostInfo,Department where EmpolyInfo.DId=Department.DId and EmpolyInfo.PId=PostInfo.PId;"
           OleDbDataAdapter ad1 = new OleDbDataAdapter(sql1, con1);
DataSet ds1 = new DataSet();
  ad1.Fill(ds1);
  dataGridView1.DataSource = ds1.Tables[0];