最新文章专题视频专题问答1问答10问答100问答1000问答2000关键字专题1关键字专题50关键字专题500关键字专题1500TAG最新视频文章推荐1 推荐3 推荐5 推荐7 推荐9 推荐11 推荐13 推荐15 推荐17 推荐19 推荐21 推荐23 推荐25 推荐27 推荐29 推荐31 推荐33 推荐35 推荐37视频文章20视频文章30视频文章40视频文章50视频文章60 视频文章70视频文章80视频文章90视频文章100视频文章120视频文章140 视频2关键字专题关键字专题tag2tag3文章专题文章专题2文章索引1文章索引2文章索引3文章索引4文章索引5123456789101112131415文章专题3
当前位置: 首页 - 科技 - 知识百科 - 正文

asp.net上传execl文件后,在页面上加载显示(示例代码)

来源:动视网 责编:小采 时间:2020-11-27 22:40:09
文档

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(
推荐度:
导读asp.net上传execl文件后,在页面上加载显示(示例代码): 代码如下: #region 上传Execl文件 protected void Button1_Click(object sender, EventArgs e) { if (FileUpload1.HasFile) { string NewFileName = string.Empty; string ErrorMess = UpLoadFile(


代码如下:
    #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

文档

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(
推荐度:
  • 热门焦点

最新推荐

猜你喜欢

热门推荐

专题
Top