C#在SQl中存取图片image.docVIP

C#在SQl中存取图片image[原] Posted on 2008-07-30 11:54 桦林 阅读(659) 评论(0) ? 编辑 收藏 网摘 所属分类: A(C#) （1）控制台应用程序下演示插入图片 public void InsertIMG()??????? { ????????????//将需要存储的图片读取为数据流??????????? FileStream fs = new FileStream(@E:\c.jpg, FileMode.Open,FileAccess.Read);??????????? Byte[] btye2 = new byte[fs.Length];??????????? fs.Read(btye2 , 0, Convert.ToInt32(fs.Length));??????????? fs.Close();??????????? ??????????? using (SqlConnection conn = new SqlConnection(sqlconnstr))??????????? {??????????????? conn.Open();??????????????? SqlCommand cmd = new SqlCommand();??????????????? cmd.Connection = conn;??????????????? cmd.CommandText = insert into T_Img(imgfile) values(@imgfile);??????????????? SqlParameter par = new SqlParameter(@imgfile, SqlDbType.Image);??????????????? par.Value = bt;??????????????? cmd.Parameters.Add(par); ??????????????? int t=(int)(cmd.ExecuteNonQuery());??????????????? if (t 0)??????????????? {??????????????????? Console.WriteLine(插入成功);??????????????? }??????????????? conn.Close();??????????? }??????? } （2）控制台应用程序下读出并生成图片到物理位置 public void Read()??????? {??????????? byte[] MyData = new byte[0];??????????? using (SqlConnection conn = new SqlConnection(sqlconnstr))??????????? {??????????????? conn.Open();??????????????? SqlCommand cmd = new SqlCommand();??????????????? cmd.Connection = conn;??????????????? cmd.CommandText = select * from T_img;??????????????? SqlDataReader sdr = cmd.ExecuteReader();??????????????? sdr.Read();??????????????? MyData = (byte[])sdr[ImgFile];//读取第一个图片的位流??????????????? int ArraySize= MyData.GetUpperBound(0);//获得数据库中存储的位流数组的维度上限，用作读取流的上限 ??????????????? FileStream fs = new FileStream(@c:\00.jpg, FileMode.OpenOrCreate, FileAccess.Write);??????????????? fs.Write(MyData, 0, ArraySize);??????????????? fs.Close();?? //-- 写入到c:\00.jpg。??????????????? conn.Close();??????????????? Console.WriteLine(读取成功);//查看硬盘上的文件??????????? }??????? } （3）Web下picshow.aspx页将图片读取出来并写入到浏览器上呈现 ??? public voi