private void button1_Click(object sender, System.EventArgs e)
{ --写入
SqlConnection conn=new SqlConnection(@"data source=.;uid=sa;pwd=;database=abc");
conn.Open();
SqlCommand cmd=new SqlCommand("insert into ImageInfo values (@i)",conn);
byte[] ib=new Byte[60000];
FileStream fs=new FileStream(@"c:/2.jpg",FileMode.Open ,FileAccess.Read );
fs.Read(ib,0,60000);
cmd.Parameters.Add("@i",SqlDbType.Image,(int)fs.Length);
cmd.Parameters["@i"].Value=ib;
cmd.ExecuteNonQuery();
conn.Close();
}
/* --读出
SqlConnection conn=new SqlConnection(@"data source=chenyuming2004/VSdotNET;uid=sa;pwd=cym;database=lhf");
conn.Open();
SqlCommand cmd=new SqlCommand("select 照片 from fuser where password='1b'",conn);
SqlDataReader reader=cmd.ExecuteReader();
reader.Read();
MemoryStream buf=new MemoryStream((byte[])reader[0]);
Image image=Image.FromStream(buf,true);
pictureBox1.Image=image;
*/
DataAccess.MapInfoDB mdb = new DataAccess.MapInfoDB();
SqlDataReader dr = mdb.GetSingleReader(mapID);
try
{
if(dr.Read())
{
MemoryStream streamImage = new MemoryStream((byte[])dr["MapContent"]);
System.Drawing.Image imageSource = System.Drawing.Image.FromStream(streamImage);
System.Drawing.Image.GetThumbnailImageAbort myCallBack =
new System.Drawing.Image.GetThumbnailImageAbort(ThumbnailCallback);
System.Drawing.Image newImage = imageSource.GetThumbnailImage(300, 200, myCallBack, IntPtr.Zero);
Response.Clear();
Response.ContentType = dr["MapType"].ToString();
Common.CommonClass cc = new Common.CommonClass();
System.Drawing.Imaging.ImageFormat ifm = cc.GetImageType(dr["MapType"].ToString());
MemoryStream outStream = new MemoryStream();
newImage.Save(outStream, ifm);
outStream.WriteTo(Response.OutputStream);
streamImage.Close();
outStream.Close();
}
}
catch(Exception ex)
{
String strMsg = ex.Message;
}
dr.Close();