FileUpload上传控件1

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

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

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string name = FileUpload1.FileName;//上传文件名字
        string size = FileUpload1.PostedFile.ContentLength.ToString();
        string type = FileUpload1.PostedFile.ContentType;
        string type2 = name.Substring(name.LastIndexOf(".") + 1);
        string ipath = Server.MapPath("upimg") + "//" + name;
        string fpath = Server.MapPath("upfile") + "//" + name;
        string path="F://aaa//"+FileUpload1.FileName;
        string wpath = "upimg//" + name;
        if (type2 == "jpg" || type2 == "gif" || type2 == "bmp" || type2 == "png")
        {
            FileUpload1.SaveAs("F://aaa//"+FileUpload1.FileName);
           // Image1.ImageUrl="F://aaa//"+FileUpload1.FileName;
            Label1.Text = "你传图片的名字是" + name + "<br>文件大小为" + size + "<br>文件类型为" + type2 + "<br>文件路径为" + ipath;
        }
        
        SqlConnection cn = new SqlConnection("server=.;database=Northwind;uid=sa;pwd=sa");
        SqlCommand cmd = new SqlCommand("insert into Image(imageName,imagepath) values('" + name + "','" + path + "')", cn);
        cn.Open();
        cmd.ExecuteNonQuery();
        cn.Close();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {    SqlConnection cn = new SqlConnection("server=.;database=Northwind;uid=sa;pwd=sa");
    SqlCommand cmd = new SqlCommand("select imageName from Image where imageID='" + Convert.ToInt32(TextBox1.Text) + "'", cn);
    cn.Open();
    string a = cmd.ExecuteScalar().ToString();
    cn.Close();
    Image1.ImageUrl = "F://aaa//" + a;
     }
}