.net文件上传的各种操作及创建文件夹和删除上传的文件方法！

 

http://www.cnblogs.com/angelfeather/archive/2008/02/02/1062173.html比较全面的文件操作

创建文件夹上传文件以及删除文件(.net)

作者: shinevi   发表日期: 2008-03-27 14:35  点击数: 405

aspx中
        <tr>
          <td align="left" colspan="2" style="height: 27px">
          <input id="myFile" name="myFile" style="width:441px; height:23px;" type="file" runat="server"/>
          <asp:Button ID="btnupload" runat="server" Text="上传" OnClick="upload_Click" Height="23px" Width="57px"/>
          </td>
        </tr>
        <tr>
          <td style="width: 250px; height: 21px; text-align: left" rowspan="4">
          <asp:GridView ID="GridView1" runat="server" DataKeyNames="id" OnRowDeleting="GridView1_RowDeleting"
            Width="250px" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" Font-Size="Small" ShowHeader="false">
            <Columns>
                <asp:BoundField DataField="id" SortExpression="id" Visible="False">
                </asp:BoundField>
                <asp:BoundField DataField="filename" SortExpression="filename" />
                <asp:CommandField ShowDeleteButton="True" />
            </Columns>
          </asp:GridView>
          </td>
        </tr>
        <tr>
          <td colspan="2">
          <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TocProjectConnectionString1 %>"
            SelectCommand="SELECT [id],[filename] FROM [upfile] where projectid=@projectid ORDER BY [id]" DeleteCommand="DELETE FROM upfile WHERE (id = @id)" >
            <DeleteParameters>
              <asp:ControlParameter ControlID="GridView1" Name="id" PropertyName="SelectedValue"/>
            </DeleteParameters>
            <SelectParameters>
              <asp:ControlParameter ControlID="TextBox1" Name="projectid" PropertyName="Text" />
            </SelectParameters>
          </asp:SqlDataSource>
          </td>
        </tr>
aspx.cs中
  protected void Page_Load(object sender, EventArgs e)
  {
    if (!IsPostBack)
    {
        //带出填表人
        string uid = HttpContext.Current.Session["userid"].ToString();
        TextBox4.Text = uid;        
        GetUsername();
        //带出当前年月为申请日期
        TextBox3.Text = DateTime.Now.ToString("yyyyMMdd");
        //当前庶务单单号--年月日加4位流水号,并自动递增
        string yms0 = "", ids0 = "", yms1 = "", ids1 = "";
        string kids = "";
        yms1 = DateTime.Now.ToString("yyyyMMdd");
        ids1 = "0001";
        ProjectSer proser = new ProjectSer();
        string checksql = "select top 1 projectid from projectmain order by projectid desc";
        kids = proser.specfval_find(checksql, "projectid");

        if (!string.IsNullOrEmpty(kids))
        {
          yms0 = kids.Substring(0, 8); ids0 = kids.Substring(8, 4);
        }

        if (yms0 == yms1)
        {
          int idi = Convert.ToInt32(ids0) + 1;
          if (idi < 10) ids1 = "000" + idi.ToString();
          if ((idi >= 10) && (idi < 100)) ids1 = "00" + idi.ToString();
          if ((idi >= 100) && (idi < 1000)) ids1 = "0" + idi.ToString();
        }
        TextBox1.Text = yms1 + ids1;
        //提交前提示附件是否上传完整
        Button1.Attributes.Add("onclick", "javascript:return confirm('请确定附件上传完整! 执行点击[确定];取消操作点击[取消]')");
    }
  }
  protected void upload_Click(object sender, EventArgs e)
  {
    if (myFile.PostedFile != null)
    {
        string filename = myFile.PostedFile.FileName;
        int i = filename.LastIndexOf(".");
        string newext;
        if (i < 0)
        {
          Label3.Text = "请选择上传文件!";
        }
        else
        {
          newext = filename.Substring(i);
          if (newext != ".jpg" && newext != ".gif" && newext != ".bmp" && newext != ".txt" && newext != ".doc" && newext != ".xls" && newext != ".pdf")
            Label3.Text = "文件格式不对,格式只能为.jpg,.gif,.bmp,.txt,.doc,.xls,.pdf!";
          else
          {
            string projectid = TextBox1.Text;
            string path = Server.MapPath(".//upLoadfile//" + projectid);
            //判断文件夹是否存在
            //if (!Directory.Exists(path))
            Directory.CreateDirectory(path);
            //else
            //{
            //   Directory.Delete(path, true);
            //   Directory.CreateDirectory(path);
            //}

            //保存上传文件
            string newname = Path.GetFileName(filename);
            myFile.PostedFile.SaveAs(path + "//" + newname);

            ProjectSer proser = new ProjectSer();
            //判断数据库中是否已存在该上传文件
            string sql = "select filename from upfile where projectid='{0}' and filename='{1}'";
            sql = string.Format(sql, projectid,newname);
            string name=proser.specfval_find(sql,"filename");
            //将上传的文件写入数据库
            if (name == "")
            {
                string sqlstr = "insert into upfile values('{0}','{1}')";
                proser.ExecuteNonQuery(string.Format(sqlstr, projectid, newname));
                gv_reflsh();
            }
            else
            {
                string sqlstr = "update upfile set filename='{0}' where projectid='{1}' and filename='{2}'";
                proser.ExecuteNonQuery(string.Format(sqlstr, newname, projectid, newname));
                gv_reflsh();
            }
          }
        }
    }
  }
  //删除附件
  protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
  {
    //删除服务器上的附件
    ProjectSer proj = new ProjectSer();
    string filename=GridView1.Rows[e.RowIndex].Cells[1].Text;
    string projectid = TextBox1.Text;
    string path = Server.MapPath(".//upLoadfile//" + projectid + "//" + filename);
    File.Delete(path);
    //删除数据库中的资料
    string SqlStr = "delete from upfile where id = " + GridView1.SelectedIndex;
    string ConnStr = ConfigurationManager.ConnectionStrings["TocProjectConnectionString"].ConnectionString;
    SqlConnection conn = new SqlConnection(ConnStr);
    conn.Open();
    SqlCommand comm = new SqlCommand(SqlStr, conn);
    comm.ExecuteNonQuery();
    gv_reflsh();
  }
  //GridView异动后刷新
  protected void gv_reflsh()
  {
    string proid = TextBox1.Text;
    SqlDataSource1.SelectCommand = string.Format("select id,filename from upfile where projectid='{0}' order by id",proid);
    SqlDataSource1.DataSourceMode = SqlDataSourceMode.DataSet;
    SqlDataSource1.Select(DataSourceSelectArguments.Empty);
  }
类中
  public int ExecuteNonQuery(string cmdText)
  {
    string connString = System.Configuration.ConfigurationManager.AppSettings["dbconnstr"];

    using (OleDbConnection connection = new OleDbConnection(connString))
    {
        connection.Open();
        OleDbCommand cmd = new OleDbCommand(cmdText, connection);
        int val = cmd.ExecuteNonQuery();
        connection.Close();
        return val;        
    }

  }
  public string specfval_find(string sqlstr,string specf)
  {
    string connectionString = System.Configuration.ConfigurationManager.AppSettings["dbconnstr"];
    string resultstr = "";
    string queryString = "";
    queryString = sqlstr;

    using (OleDbConnection connection = new OleDbConnection(connectionString))
    {
        OleDbCommand command = new OleDbCommand(queryString, connection);
        connection.Open();
        OleDbDataReader Reader = command.ExecuteReader();
        if (Reader.HasRows)
        {
          Reader.Read();
          resultstr = Reader[specf].ToString();
          //resultstr = Reader.GetString(0);
        }

        Reader.Close();
    }
    return resultstr;
  }