一聚教程网:一个值得你收藏的教程网站

热门教程

excel数据导入到dataset代码

时间:2022-06-25 05:07:40 编辑:袖梨 来源:一聚教程网

excel数据导入到dataset代码

public dataset execleds(string filenameurl, string table)
  {
  string strconn = "provider=microsoft.jet.oledb.4.0;" + "data source='" + filenameurl + "';extended properties='excel 8.0; hdr=yes; imex=1'";
  oledbconnection conn = new oledbconnection(strconn);
  conn.open();
  dataset ds = new dataset();
  oledbdataadapter odda = new oledbdataadapter("select * from [sheet1$]", conn);
  odda.fill(ds, table);
  return ds;
  }
  select * from opendatasource('microsoft.jet.oledb.4.0','user id=admin;password=;data source=filenameurl;extended properties=''excel 8.0;imex=1''')...sheet1$

 

热门栏目