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("欢迎进入登录界面"); } }}