C# 以文件名存入数据库和读取

【实例简介】以文件名存入数据库和读取,实现了将图片存入数据库 并读取出来

内部有详细的注释，为的是能够帮助新人!大家一起加油

【实例截图】

【核心代码】

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.IO;

using System.Data.SqlClient;
using SpeechLib;

namespace writeandreadforsqlserver
{
    public partial class Form1 : Form
    {
        //string str = "server=.;database=DENGLU;uid=ycdz;pwd=youchuang@029";
        private string str = "server=.;database=DENGLU;Trusted_Connection=SSPI";
        public Form1()
        {
            InitializeComponent();
        }

        public static void Read_Image(OpenFileDialog openF, PictureBox MyImage)
        {
            openF.Filter = "*.jpg|*.jpg|*.bmp|*.bmp";
            if (openF.ShowDialog() == DialogResult.OK)

            {
                try
                {
                    MyImage.Image = System.Drawing.Image.FromFile(openF.FileName);

                }
                catch
                {
                    MessageBox.Show("您选择的图片不能被读取或文件类型不对！",//弹出消息对话框
                           "错误", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
            }
        }

        public int SaveImage(OpenFileDialog openF)
        {

            SqlConnection conn= new SqlConnection(str);

            string P_str = openF.FileName;//得到图片的所在路径
            FileStream fs = new FileStream(P_str, FileMode.Open, FileAccess.Read);//创建文件流对象
            BinaryReader br = new BinaryReader(fs);//创建二进制读取器
            byte[] imgBytesIn = br.ReadBytes((int)fs.Length);//将流读入到字节数组中

            conn.Open();//打开数据库连接
            string P_FileName = Path.GetFileNameWithoutExtension (P_str).Trim();
            //GetFileNameWithoutExtension不存储文件后缀名
            string sql = "insert into Photo (sphoto,name) values (@sphoto,'" P_FileName "')";
            SqlCommand cmd = new SqlCommand(sql , conn);//创建命令对象

            cmd.Parameters.Add("@sphoto", SqlDbType.Binary).Value = imgBytesIn;//添加参数
            int count=cmd.ExecuteNonQuery();//执行SQL命令
            conn.Close();//关闭数据库连接
            return count;
        }

        public void Get_Image(string sid, PictureBox pb)
        { try
            {
                //string str = "server=.;database=DENGLU;uid=ycdz;pwd=youchuang@029";
                SqlConnection conn = new SqlConnection(str);
                conn.Open();//打开数据库连接

                byte[] imagebytes = null;//声明字节数组变量
                string sql = "select sphoto from Photo where name='"   sid   "'";
                SqlCommand cmd = new SqlCommand(sql, conn);
                SqlDataReader dr = cmd.ExecuteReader();//执行SQl命令
                while (dr.Read())//读取数据库中的数据
                {
                    imagebytes = (byte[])dr.GetValue(0);//得到图象的字节数据
                    
                }
                dr.Close();//关闭数据读取器
                conn.Close();//关闭数据库连接
                MemoryStream ms = new MemoryStream(imagebytes);//创建内存流对象
                Bitmap bmpt = new Bitmap(ms);//得到BMP对象
                pb.Image = bmpt;//显示图像信息
            }
            catch
            {
                MessageBox.Show("数据库里面没有此数据");
            }
            }
       


        private void button1_Click(object sender, EventArgs e)
        {
            Read_Image(openFileDialog1 ,pictureBox1 );
        }

        private void button2_Click(object sender, EventArgs e)
        {
            if (SaveImage(openFileDialog1) == 1)
            {
                MessageBox.Show("成功");
            }
            else
            {
                MessageBox.Show("失败");
            }
        }

        private void button3_Click(object sender, EventArgs e)
        {
            Get_Image(textBox1.Text, pictureBox1);
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            pictureBox2.SizeMode = PictureBoxSizeMode.StretchImage;
            string b = @"Picture\1.jpg";
            string a = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, b);
            pictureBox2.Image = Image.FromFile(a);

            SpVoice voice = new SpVoice();
            voice.Rate = 1;
            voice.Voice = voice.GetVoices().Item(0);
            voice.Speak("欢迎进入登录界面");
        }
    }
}