| 标题 | asp.net读取excel中的数据并绑定在gridview |
| 内容 | 这篇文章主要介绍了asp.net读取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.Write("<script>window.alert('请选择要导入的文件')</script>"); } if (this.AttachmentFile.Value != "" && this.DropDownList2.SelectedValue == "") { HttpFileCollection files = HttpContext.Current.Request.Files; HttpPostedFile postedFile = files[0]; fileName = System.IO.Path.GetFileName(postedFile.FileName); if (fileName != "") { postedFile.SaveAs("\\localhost\文件夹\" + fileName); } string strConn; strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + "\\localhost\文件夹\" + fileName + ";Extended Properties=Excel 8.0;";//this.AttachmentFile.Value.ToString() OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); DataTable sheetNames = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" }); foreach (DataRow dr in sheetNames.Rows) { DropDownList2.Items.Add(dr[2].ToString()); } this.Label1.Text = "\\localhost\文件夹\" + fileName;//this.AttachmentFile.Value.ToString(); conn.Close(); } if (this.Label1.Text.ToString() != "" && this.DropDownList2.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 createDataSource(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("<script>window.alert('没有数据,或者" + e.Message + "')</script>"); return null; } } 以上是插入07以前版本excel 如果07版本以后只需要做小小修改 代码如下: string strCon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + lable + ";Extended Properties=Excel 12.0;"; |
| 随便看 |
|
在线学习网考试资料包含高考、自考、专升本考试、人事考试、公务员考试、大学生村官考试、特岗教师招聘考试、事业单位招聘考试、企业人才招聘、银行招聘、教师招聘、农村信用社招聘、各类资格证书考试等各类考试资料。