Datagridview绑定dataset数据

Datagridview绑定dataset数据

(2013-05-01 21:56:56)

转载▼

 分类： 编程

 this.dataGridView1.AutoGenerateColumns = true;  //设置自动生成列，必须写在InitializeComponent（）里

 

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];

分享：

喜欢

阅读┊评论 ┊收藏┊转载┊喜欢▼┊打印┊举报

加载中，请稍候......

前一篇：VS2010不能添加System.Web.dll引用

后一篇：Loadrunner中IP欺骗