protected void btnSave_Click(object sender, EventArgs e)
{
// 上传的图片文件到Image
System.Drawing.Image img = System.Drawing.Image.FromFile(fileImg.PostedFile.FileName);
// 以Jpeg格式存到内存中
System.IO.MemoryStream ms =
new System.IO.MemoryStream();
img.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
using (SqlConnection con =
new SqlConnection("Data Source=.//SQLEXPRESS;AttachDbFilename=|DataDirectory|//Database.MDF;Integrated Security=True;User Instance=True"))
{
SqlCommand cmd =
new SqlCommand("spInsertImage", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ImageBinary", System.Data.SqlDbType.Image);
// 图片的二进制数据
cmd.Parameters["@ImageBinary"].Value = ms.ToArray();
con.Open();
try
{
// 调存储过程
cmd.ExecuteNonQuery();
Response.Write("ok");
}
catch
{
Response.Write("error");
}
}
img.Dispose();
ms.Dispose();
ms.Flush();
}