using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.IO;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace 数据库存取图片
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
//定义缓冲区
byte[] b;
private void btnAddPhoto_Click(object sender, EventArgs e)
{
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
txtPath.Text = openFileDialog1.FileName;
}
FileStream fs = new FileStream(txtPath.Text, FileMode.Open, FileAccess.Read);
b = new byte[fs.Length];
fs.Read(b, 0, b.Length);
Stream s = new MemoryStream(b,0,b.Length);
pictureBox1.Image = Image.FromStream(s);
}
private void btnOK_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("server=.;database=pubs;uid=sa;pwd=123456");
string sql = "insert into userinfo values(@userName,@userPhoto)";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.Add("@userName",SqlDbType.VarChar,50);
cmd.Parameters[0].Value = txtUserName.Text;
cmd.Parameters.Add("@userPhoto", SqlDbType.Image);
cmd.Parameters["@userPhoto"].Value = b;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("添加完毕");
}
private void btnGet_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("server=.;database=pubs;uid=sa;pwd=123456");
string sql = "select * from userinfo where username [email==@username]=@username[/email]";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.Add("@username",SqlDbType.VarChar,50);
cmd.Parameters[0].Value = txtGetName.Text;
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if(!dr.HasRows)
{
MessageBox.Show("不存在该用户");
dr.Close();
con.Close();
return;
}
dr.Read();//游标下移
byte []photo =(byte[]) dr["userPhoto"];
Stream s = new MemoryStream(photo);
pictureBox2.Image = Image.FromStream(s);
con.Close();
MessageBox.Show("读取完毕");
}
}
}
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.IO;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace 数据库存取图片
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
//定义缓冲区
byte[] b;
private void btnAddPhoto_Click(object sender, EventArgs e)
{
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
txtPath.Text = openFileDialog1.FileName;
}
FileStream fs = new FileStream(txtPath.Text, FileMode.Open, FileAccess.Read);
b = new byte[fs.Length];
fs.Read(b, 0, b.Length);
Stream s = new MemoryStream(b,0,b.Length);
pictureBox1.Image = Image.FromStream(s);
}
private void btnOK_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("server=.;database=pubs;uid=sa;pwd=123456");
string sql = "insert into userinfo values(@userName,@userPhoto)";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.Add("@userName",SqlDbType.VarChar,50);
cmd.Parameters[0].Value = txtUserName.Text;
cmd.Parameters.Add("@userPhoto", SqlDbType.Image);
cmd.Parameters["@userPhoto"].Value = b;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("添加完毕");
}
private void btnGet_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("server=.;database=pubs;uid=sa;pwd=123456");
string sql = "select * from userinfo where username [email==@username]=@username[/email]";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.Add("@username",SqlDbType.VarChar,50);
cmd.Parameters[0].Value = txtGetName.Text;
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if(!dr.HasRows)
{
MessageBox.Show("不存在该用户");
dr.Close();
con.Close();
return;
}
dr.Read();//游标下移
byte []photo =(byte[]) dr["userPhoto"];
Stream s = new MemoryStream(photo);
pictureBox2.Image = Image.FromStream(s);
con.Close();
MessageBox.Show("读取完毕");
}
}
}