继续编辑导入按钮:
protected void Button1_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile == false)//检查FileUpload是否有文件
{
Response.Write(" ");
return;
}
string IsXls = System.IO.Path.GetExtension(FileUpload1.FileName).ToString().ToLower();//获取文件扩展名
if (IsXls != ".xlsx")
{
Response.Write("");
return;
}
string filename = DateTime.Now.ToString("yyyymmddhhMMss") + FileUpload1.FileName; //获取Execle文件名 DateTime日期函数
string savePath = Server.MapPath(("~\\Files\\") + filename);//获得虚拟服务器相对路径(注:在项目中建立Files文件夹)
FileUpload1.SaveAs(savePath); //将上传文件保存
DataSet ds = ExecleDs(savePath, filename); //调用自定义方法
DataRow[] dr = ds.Tables[0].Select();
int rowsnum = ds.Tables[0].Rows.Count;
if (rowsnum == 0)
{
Response.Write("");
}
else
{
for (int i = 0; i < dr.Length; i++)
{
string name = dr[i]["姓名"].ToString();
string sex = dr[i]["性别"].ToString();
string age = dr[i]["年龄"].ToString();
//其中姓名,性别,年龄为Excel表头
//此处为添加数据库的insert into
}
Response.Write("");
}
}