如何将Excel里的数据显示到界面上

来源:互联网 发布:监控网络流量软件 编辑:程序博客网 时间:2024/06/11 05:45
DataTable dt = new DataTable(); try { string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C://Documents and Settings//Administrator//桌面//user.xls;Extended Properties=Excel 8.0"; System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(" select * from [sheet1$] ", strCon); da.Fill(dt); } catch (Exception ex) { Response.Write(ex.Message); } this.GridView1.DataSource = dt; this.GridView1.DataBind();
原创粉丝点击