读写sql数据库中的图片

最新推荐文章于 2024-09-14 19:55:29 发布

hfbw

最新推荐文章于 2024-09-14 19:55:29 发布

阅读量631

点赞数

分类专栏：技术文章文章标签：数据库 sql image byte insert cmd

本文链接：https://blog.csdn.net/hfbw/article/details/132648

版权

技术文章专栏收录该内容

0 篇文章 0 订阅

订阅专栏

把图片读到pictureBox，再写入数据库
    SqlConnection conn=new SqlConnection(@"data source=chenyuming2004/VSdotNET;uid=sa;pwd=cym;database=lhf");
    conn.Open();
    SqlCommand cmd=new SqlCommand("insert into fuser values ('1a','1b',@i)",conn);
    byte[] ib=new Byte[60000];
    FileStream fs=new FileStream(@"D:/windows temp/temp/1.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();

-------------------------------------------------------
从数据库读图片到picturebox

    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;