Go homepage(回首页) Upload pictures (上传图片) Write articles (发文字帖)
The author:(作者)delvpublished in(发表于) 2014/1/10 6:32:53 用gridview显示来自excel表格里的数据_[Asp.Net教程]
在asp.net 2.0中,如何用gridview显示来自建立好的EXCEL文件的内容呢,其实是很简单的,下面给出简单代码片断
protected void Page_Load(object sender, EventArgs e){ OleDbConnection DBConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath("~/App_Data/demo1.xls") + ";" + "Extended Properties=\"Excel 8.0;HDR=Yes\""); DBConnection.Open(); string SQLString = "SELECT * FROM [Sheet1]"; OleDbCommand DBCommand = new OleDbCommand(SQLString, DBConnection); IDataReader DBReader = DBCommand.ExecuteReader(); GridView1.DataSource = DBReader; GridView1.DataBind(); DBReader.Close(); DBConnection.Close();} 其中,把demo1.xls放在app_data目录下,这里用select * from [Sheet1]来将sheet1的内容取出来。
来源:网络
赞