62,050
社区成员
发帖
与我相关
我的任务
分享
//上传文件
FileUpload1.PostedFile.SaveAs(Server.MapPath("../../Project/files/" + filename));
DataSet ds = DataBaseAccess.ExecuteSql4Ds("select * from OPENROWSET('MICROSOFT.ACE.OLEDB.12.0','Excel 8.0;HDR=YES;DATABASE=" + Server.MapPath("../../Project/files/" + filename) + ";IMEX=1;',[材料导入$])");
DataView dvdetail = ds.Tables[0].DefaultView;
GridView1.DataSource = dvdetail;
GridView1.DataBind();