C#关于sqlserver中读取image类型

最新推荐文章于 2024-05-31 15:34:18 发布

原创最新推荐文章于 2024-05-31 15:34:18 发布 · 1w 阅读

6 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#sqlserver #image #c# #dataset #string

C#技术专栏收录该内容

10 篇文章

订阅专栏

本文介绍了如何在SQL Server中使用C#进行图像数据的存储、检索及展示。包括将图像文件插入数据库、从数据库中读取图像并在DataGridView中显示等步骤。

今天在网上找了许久关于sqlserver中存储image类型和读取image的方法，可是都是那么一点，故在此罗列一下，希望可以帮助大家。

首先是关于dataGridView的绑定。代码见下

private void button_show_Click(object sender, EventArgs e) { string sqlText = "server=localhost;initial catalog=Test; integrated security=true"; string sqlstr="select * from tast"; SqlConnection conn=new SqlConnection (sqlText); conn.Open(); SqlCommand comm = new SqlCommand(sqlstr, conn); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = comm; da.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; conn.Close(); }

下面是插入图像到数据库，代码如下：

private void button_connect_Click(object sender, EventArgs e) { string sqlText = "server=localhost;initial catalog=Test; integrated security=true"; string sqlstr = "insert into tast(photo) values(@image) "; SqlConnection conn = new SqlConnection(sqlText); conn.Open(); SqlCommand comm = new SqlCommand(sqlstr, conn); comm.Parameters.Add("@image", SqlDbType.Image).Value = GetPhoto("DSC_6126.JPG"); comm.ExecuteNonQuery(); conn.Close(); } public byte[] GetPhoto(string str1) { string str = str1; FileStream file = new FileStream(str, FileMode.Open, FileAccess.Read); byte[]photo=new byte[file.Length]; file.Read(photo,0,photo.Length); file.Close(); return photo; }

下面就是读取图片了

private void button_showimg_Click(object sender, EventArgs e) { string sqlText = "server=localhost;initial catalog=Test; integrated security=true"; string sqlstr = "select *from tast where whf=1"; SqlConnection conn = new SqlConnection(sqlText); conn.Open(); SqlCommand comm = new SqlCommand(sqlstr, conn); SqlDataAdapter da=new SqlDataAdapter (); da.SelectCommand=comm; DataSet ds=new DataSet (); da.Fill(ds); MemoryStream ms = new MemoryStream((byte[])ds.Tables[0].Rows[0][1]); Image i = Image.FromStream(ms,true); pictureBox1.Image = i; }