C#操作SQL Server中的Image类型数据

冷不防 2022-01-05 05:45 350阅读 0赞

该例子是一个对SQL Server数据类型的一个操作例子，具有写入、读取功能。

1：准备数据库

> 1）创建数据库 Test
> 
> 2）创建表 Table\_1 （分别有2个字段：id(Int)、photo(Image)）

如图：

![2011120321222184.gif][]

2：用C\#进行读写操作，完整代码如下：

using System;  
    using System.Collections.Generic;  
    using System.ComponentModel;  
    using System.Data;  
    using System.Drawing;  
    using System.Linq;  
    using System.Text;  
    using System.Windows.Forms;  
    using System.Data.SqlClient;  
    using System.IO;  
    
    namespace imageTest  
    {  
    public partial class Form1 : Form  
        {  
    public Form1()  
            {  
                InitializeComponent();  
            }  
    
    private void btn_brewse_Click(object sender, EventArgs e)  
            {  
                OpenFileDialog op = new OpenFileDialog();  
                op.Title = "浏览图像文件";  
                op.Filter = "图像文件(*.jpg)|*.jpg";  
                op.ShowDialog();  
                txt_ImageAddress.Text = op.FileName;  
            }  
    
    private void btn_Insert_Click(object sender, EventArgs e)  
            {  
                FileStream fs = new FileStream(txt_ImageAddress.Text,FileMode.Open,FileAccess.Read);  
    byte[] byteArray = new byte[fs.Length];  
                fs.Read(byteArray,0,Convert.ToInt32(fs.Length));  
                fs.Close();  
    
    string connectionStr = "Server=.;Database=Test;Uid=sa;Pwd=123456";  
                SqlConnection conn = new SqlConnection(connectionStr);  
                conn.Open();  
                SqlCommand cmd = new SqlCommand("INSERT INTO Table_1(photo) VALUES(@photo)",conn);  
                SqlParameter parmeter = new SqlParameter("@photo", SqlDbType.Image);  
                parmeter.Value = byteArray;  
                cmd.Parameters.Add(parmeter);  
    int result = cmd.ExecuteNonQuery();  
    if (result > 0)  
                    MessageBox.Show("插入成功");  
                conn.Close();  
            }  
    
    private void btn_ReadImage_Click(object sender, EventArgs e)  
            {  
    string connectionStr = "Server=.;Database=Test;Uid=sa;Pwd=123456";  
                SqlConnection conn = new SqlConnection(connectionStr);  
                conn.Open();  
                SqlCommand cmd = new SqlCommand("SELECT * FROM Table_1",conn);  
                SqlDataReader dr = cmd.ExecuteReader();  
                dr.Read();  
    byte[] image = (byte[])dr["photo"];  
                conn.Close();  
    if (image.Length == 0)  
    return;  
    string photoUrl = Environment.CurrentDirectory + "\\1.jpg";  
                FileStream fs = new FileStream(photoUrl, FileMode.OpenOrCreate, FileAccess.Write);  
                BinaryWriter bw = new BinaryWriter(fs);  
                bw.BaseStream.Write(image, 0, image.Length);  
                bw.Flush();  
                bw.Close();  
    
                picbox_image.ImageLocation = photoUrl;  
            }  
    
        }  
    }

效果如图：

![2011120321243488.gif][]

完整项目（包含数据库文件）：[点击下载][Link 1]

参考：[http://www.wxzzz.com/?id=47][http_www.wxzzz.com_id_47]

转载于:https://www.cnblogs.com/andrew-blog/archive/2011/12/03/CSharp\_SQL\_Image.html

[2011120321222184.gif]: /images/20211229/4792cb6d70d64158acd50613c7c4e0a1.png
[2011120321243488.gif]: /images/20211229/8cd7e5c3183844cab47821c0cc24dda5.png
[Link 1]: http://files.cnblogs.com/andrew-blog/CSharp%E6%93%8D%E4%BD%9CSQL%E4%B8%AD%E7%9A%84Image%E7%B1%BB%E5%9E%8B%E6%95%B0%E6%8D%AE.rar
[http_www.wxzzz.com_id_47]: http://www.wxzzz.com/?id=47