protected void Button1_Click(object sender, EventArgs e)
{
//上传图片
string connection = WebConfigurationManager.ConnectionStrings["ConnectionString 1"].ConnectionString;
SqlConnection conn = new SqlConnection(connection); string path = Server.MapPath("~/Picture");
string filepath = FileUpload1.PostedFile.FileName; string name = filepath.Substring(https://www.doczj.com/doc/7210949439.html,stIndexOf("\\")+1);//获取文件名
string Extend = filepath.Substring(https://www.doczj.com/doc/7210949439.html,stIndexOf(".")+1);//获取格式名
if (Extend == "jpg" || Extend == "gif" || Extend == "bmp")
{
FileUpload1.SaveAs(path + "\\" + name);
string filepath1 = "~/Picture/" + name;
conn.Open();
string sql = "insert into Picture values('" + filepath1 + "')";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
Response.Write("");
}
else
{
Response.Write("");
}
}
protected void Button2_Click(object sender, EventArgs e) {
//显示图片
string connection = WebConfigurationManager.ConnectionStrings["ConnectionString 1"].ConnectionString;
SqlConnection conn = new SqlConnection(connection); conn.Open();
string select = "select * from picture";
DataSet dt = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter(select,conn); sda.Fill(dt);
Image2.ImageUrl = dt.Tables[0].Rows[0]["Picture"].ToString();
}
二进制保存图片
protected void Button1_Click(object sender, EventArgs e)
{
//上传图片
string connection = WebConfigurationManager.ConnectionStrings["ConnectionString 1"].ConnectionString;
SqlConnection conn = new SqlConnection(connection); conn.Open();
string sql = "insert into Picture values(@Picture)"; SqlCommand cmd = new SqlCommand(sql,conn);
cmd.Parameters.Add("@Picture",System.Data.SqlDbType.Image). Value =FileUpload1.FileBytes;
cmd.ExecuteNonQuery();
Response.Write("");
}
protected void Button2_Click(object sender, EventArgs e) {
//显示图片
string connection = WebConfigurationManager.ConnectionStrings["ConnectionString 1"].ConnectionString;
SqlConnection conn = new SqlConnection(connection); conn.Open();
string sql1 = "select * from Picture";
SqlCommand cmd = new SqlCommand(sql1,conn);
SqlDataReader sdr = cmd.ExecuteReader();
sdr.Read();
MemoryStream ms = new MemoryStream((Byte[])sdr["Picture"]);
Bitmap image = new Bitmap(ms);
string path = Server.MapPath("~/Picture");
DirectoryInfo dir = new DirectoryInfo(path); string imagename = path + ".jpg";
image.Save(imagename);
sdr.Close();
Image2.ImageUrl = "~/Picture"+".jpg";
}
}
js实现图片上传前的预览,实现完美兼容Firefox3,IE6,IE7,IE8和IE9的显示问题 1、脚本,把下面代码加到
与之间 Js代码 1.