using
System.Data.OleDb;//需要引入命名
p
ublic void Excel_Click(object sender, Event
args e)
{
if (this.AttachmentFile.Value
== ""
&& this.Label1.Text == "" &
amp;& DropDownList2.SelectedValue == "")
{
Response.Wr
ITe("<script>window.alert('请选择要导入的文件')</script>");
}
if (this.AttachmentFile.Value != "" && this.DropDownList2.SelectedValue == "")
{
HttpFileCollection files = HttpContext.
current.Request.Files;
HttpPoste
DFile 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 Pro
PErties=Excel 8.0;";//this.AttachmentFile.Value.ToString()
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
DataTable sheet
names = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
for
each (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 str
SQL = "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;
}
}