网站首页  汉语字词  英语词汇  考试资料  写作素材  旧版资料

请输入您要查询的范文:

 

标题 asp.net上传execl文件后,在页面上加载显示
范文
    本篇文章主要是对asp.net上传execl文件后,在页面上加载显示(示例代码)进行了介绍,需要的朋友可以过来参考下,希望对大家有所帮助
    代码如下:
    #region 上传Execl文件
    protected void Button1_Click(object sender, EventArgs e)
    {
    if (FileUpload1.HasFile)
    {
    string NewFileName = string.Empty;
    string ErrorMess = UpLoadFile(FileUpload1, ".xls|.xlsx", 1024 * 5, Server.MapPath("/Report/SocialApply/"), 1, out NewFileName);
    if (string.IsNullOrEmpty(ErrorMess))
    {
    Label1.Text = "√文件上传成功";
    ViewState["UpLoadFile"] = "/Report/SocialApply/" + NewFileName;
    try
    {
    FileStream file = new FileStream
    (Server.MapPath(ViewState["UpLoadFile"] as string),
    FileMode.Open, FileAccess.Read,
    FileShare.ReadWrite);
    DataTable dt1 = FairHR.Util.XmlExcelReport.ReadExcelToDataTable(file, 0, 0);
    ViewState.Add("ViewDT", dt1);
    GridView1.DataSource = ViewState["ViewDT"] as DataTable;
    GridView1.DataBind();
    file.Close();
    //Maticsoft.Common.MessageBox.ResponseScript(Page, "$.messager.alert('系统提示', '操作成功!', 'info');");
    }
    catch
    {
    Maticsoft.Common.MessageBox.ResponseScript(Page, "$.messager.alert('系统提示', '请重新上传Execl文件再操作', 'warning');");
    }
    }
    else
    {
    Label1.Text = "×文件上传失败";
    }
    }
    else
    {
    Label1.Text = "×请先选择上传文件";
    }
    ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "idAlert1", "closeLoad();", true);
    }
    #endregion
    #region 上传文件
    /// <summary>
    /// 上传文件
    /// </summary>
    /// <param name="fu">上传文件</param>
    /// <param name="type">上传文件类型,例如.jpg|.gif|.bmp</param>
    /// <param name="size">限制上传文件大小,单位为k</param>
    /// <param name="path">上传路径,需使用server.mappath</param>
    /// <param name="nametype">1为自动命名,0用原名</param>
    /// <returns></returns>
    public static string UpLoadFile(FileUpload fu, string type, int size, string path, int nametype, out string newFileName)
    {
    newFileName = null;
    string erorr = null;
    int Size = fu.PostedFile.ContentLength / 1024;
    if (Size > size)
    {
    erorr = "上传文件太大!";
    return erorr;
    }
    string Type = fu.FileName;
    if (Type.IndexOf(".") == -1) { erorr = "上传文件类型有误!"; return erorr; }
    Type = Type.Substring(Type.LastIndexOf(".")).ToUpper();
    type = type.ToUpper();
    if (type.IndexOf(Type) == -1) { erorr = "上传文件类型有误!"; return erorr; }
    string filename = "";
    if (nametype == 1)
    {
    string nowdate = DateTime.Now.ToString();
    nowdate = nowdate.Replace(":", "").Replace(" ", "").Replace("-", "").Trim();
    Random r = new Random();
    int a = r.Next(1000);
    filename = nowdate + a.ToString() + Type;
    newFileName = filename;
    }
    else
    {
    filename = fu.FileName;
    if (System.IO.File.Exists(path + filename)) { erorr = "此文件名已经存在!"; return erorr; }
    }
    fu.SaveAs(path + filename);
    return erorr;//返回有错的错误信息,没有错误返回null
    }
    #endregion
随便看

 

在线学习网范文大全提供好词好句、学习总结、工作总结、演讲稿等写作素材及范文模板,是学习及工作的有利工具。

 

Copyright © 2002-2024 cuapp.net All Rights Reserved
更新时间:2025/5/14 5:57:52