asp.net上传文件 VS2008版

来源：互联网发布：淘宝优5元惠券制作编辑：程序博客网时间：2024/05/16 17:04

在VS2008中，使用<asp:UploadFile控件

前台页面

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="FileUpload.aspx.cs" Inherits="WebApplication1.FileUpload" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" ><head runat="server">    <title>无标题</title>    <script type="text/javascript">        function checkType() {            //得到上传文件的值            var fileName = document.getElementById('FileUpLoad1').value;            //返回String对象中字符串最后出现的位置。            var seat = fileName.lastIndexOf(".");            //返回位于String对象中指定位置的子字符串并转换为小写            var extension = fileName.substring(seat).toLowerCase();            var allowed = [".xls", ".xlsx"];            for (var i = 0; i < allowed.length; i++) {                if (!(allowed[i] != extension)) {                    return true;                }            }            alert("不支持" + extension + "格式");            return false;        }    </script></head><body>    <form id="form1" runat="server">    <div>        <asp:FileUpload ID="FileUpLoad1" runat="server" />        <br />        <asp:Button ID="btnFileUpload" runat="server"             Text="文件上传" OnClientClick="return checkType()"             onclick="btnFileUpload_Click" />        <asp:Label ID="lblMessage" runat="server"></asp:Label>    </div>    </form></body></html>

后台代码：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;
using System.Data;

namespace WebApplication1
{
    public partial class FileUpload : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

}

        protected void btnFileUpload_Click(object sender, EventArgs e)
        {
            if (FileUpLoad1.HasFile)
            {
                //判断文件是否小于4MB
                if (FileUpLoad1.PostedFile.ContentLength < 4194304)
                {

                   HttpPostedFile file = FileUpLoad1.PostedFile;
                   string str=file.FileName;
                   string filename2 = str.Substring(str.LastIndexOf(".")).ToString().Trim();
                   string filename1 = DateTime.Now.Ticks.ToString()+filename2;
                   file.SaveAs(Server.MapPath("./upload/"+filename1));//将用户上传的文件保存到服务器上.

string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("./upload/"+filename1) + ";Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1\"";
                    OleDbConnection Oleconn = new OleDbConnection(strConn);
                    string strExcel = "";
                    OleDbDataAdapter excelCommand = null;
                    DataSet excel_ds = new DataSet();
                    strExcel = "select * from [sheet1$]";
                    try
                    {
                        Oleconn.Open();
                        excelCommand = new OleDbDataAdapter(strExcel, Oleconn);
                        excelCommand.Fill(excel_ds, "exdtSource");//得到dataset
                        lblMessage.Text = "上传成功!";
                    }
                    catch (Exception ex)
                    {
                        lblMessage.Text = "出现异常，无法上传!";
                    }
                    finally
                    {
                        Oleconn.Close();
                        Oleconn.Dispose();
                    }

                }
                else
                {
                    lblMessage.Text = "上传文件不能大于10MB!";
                }
            }
            else
            {
                lblMessage.Text = "尚未选择文件!";
            }

        }
    }
}