数据库存取图片
来源:互联网 发布:阿里云怎么重启服务器 编辑:程序博客网 时间:2024/06/06 05:26
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("读取完毕");
}
}
}
- 数据库存取图片
- 数据库中存取图片
- 数据库存取图片
- C#数据库存取图片
- 图片存取数据库(java)
- 数据库存取图片
- 数据库中存取图片
- 图片的数据库存取
- oracle数据库存取图片
- java数据库 存取图片
- 数据库中图片存取
- 数据库存取图片类
- 数据库存取图片类
- 数据库图片的存取
- Android 数据库存取图片
- Android 数据库存取图片
- Sqlite数据库图片存取
- Android 数据库存取图片
- asp.net 定制简单的错误处理页面
- 校内网API的.net版本XiaoNei.Net 1.0(非官方)
- 文件存取图片
- 我也来秀一下google的 Android 手机
- 用ASP.NET加密Cookie数据
- 数据库存取图片
- 用ASP.NET开发Web服务的五则技巧
- 听:快乐的牧羊人
- ASP.NET数据库缓存依赖
- MD5加密
- ASP.Net开发者常见Datagrid错误
- asp.net 2.0多语言网站解决方案
- 受惊的“兔子”
- ASP.NET ViewState 初探