asp.net读取excel中的数据并绑定在gridview_

1、读取excel中的数据并绑定在gridview_ 这篇文章主要介绍了读取excel中的数据并绑定在gridview上的方法,需要的伴侣可以参考下 前台label，DropDownList，gridview控件 aspx.cs核心代码： 代码如下: using System.Data.OleDb;/需要引入命名 public void Excel_Click(object sender, EventArgs e) if (this.AttachmentFile.Value = this.Label1.Text = DropDownList2.SelectedValue = ) Response.

2、Write(scriptwindow.alert(请选择要导入的文件)/script); if (this.AttachmentFile.Value != this.DropDownList2.SelectedValue = ) HttpFileCollection files = HttpContext.Current.Request.Files; HttpPostedFile postedFile = files0; fileName = System.IO.Path.GetFileName(postedFile.FileName); if (fileName != ) postedFil

3、e.SaveAs(文件夹 + fileName); string strConn; strConn = Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + 文件夹 + fileName + ;Extended Properties=Excel 8.0;/this.AttachmentFile.Value.ToString() OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); DataTable sheetNames = conn.GetOleDbSchemaTable(

4、System.Data.OleDb.OleDbSchemaGuid.Tables, new object null, null, null, TABLE ); foreach (DataRow dr in sheetNames.Rows) DropDownList2.Items.Add(dr2.ToString(); this.Label1.Text = 文件夹 + fileName;/this.AttachmentFile.Value.ToString(); conn.Close(); if (this.Label1.Text.ToString() != this.DropDownList2

5、.SelectedValue != )/ this.DropDownList1.SelectedValue.ToString() != 全部 /绑定到gridview GridView1.DataSource = createDataSource(DropDownList2.SelectedValue.ToString(), this.Label1.Text.ToString();/, this.DropDownList1.SelectedValue.ToString() GridView1.DataBind(); /以Excel为数据源猎取数据集 private DataSet create

6、DataSource(string select, string lable) string strCon = Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + lable + ;Extended Properties=Excel 8.0; string strsql = select 登记号码,姓名,日期,签到时间,签退时间,部门 from + select + order by 部门,日期,姓名;/excel表格的字段 OleDbConnection conn = new OleDbConnection(strCon); OleDbDataAdapter da = new OleDbDataAdapter(strsql, conn); try conn.Open(); DataSet ds = new DataSet(); da.Fill(ds); conn.Close(); return ds; catch (Exception e) Response.Write(scriptwindow.alert(没有数据,或者 + e.Message + )/script); return null; 以上是插入07以前版本excel 假如07版本以后只需要做小小修改 代码如下: string strCon