不错呦!smile@林凯西,确保“准备文件”中的几个文件都有安装,S...您好,看了您这篇帖子觉得很有帮助。但是有个问题想请...我的修改过了怎么还被恶意注册呢 @jjjjiiii 用PJ快9年了,主要是A...PJ3啊,貌似很少有人用PJ了,现在不是WP就是z...@332347365,我当时接入时错误码没有-10...楼主,ChkValue值应为-103是什么意思呢?...大哥 你最近能看到我发的信息,请跟我联系,我有个制...
[C#] Sql Server2000图片存取技术
编辑:dnawo 日期:2009-09-15
复制内容到剪贴板
程序代码

//存储
private void button1_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection("Data Source=127.0.0.1;Initial Catalog=Northwind;User ID=sa;Password=sa"))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "Insert INTO Images(Pic) Values(@Pic)";
cmd.CommandType = CommandType.Text;
//读取图片
byte[] b;
using (FileStream fs = new FileStream(@"F:\b1274.jpg", FileMode.Open))
{
b = new byte[fs.Length];
fs.Read(b, 0, b.Length);
}
//添加参数
SqlParameter[] parms = new SqlParameter[]{
new SqlParameter("@Pic", SqlDbType.Image)
};
parms[0].Value = b;
for (int i = 0; i < parms.Length; i++)
cmd.Parameters.Add(parms[i]);
cmd.ExecuteNonQuery();
}
conn.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection("Data Source=127.0.0.1;Initial Catalog=Northwind;User ID=sa;Password=sa"))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "Insert INTO Images(Pic) Values(@Pic)";
cmd.CommandType = CommandType.Text;
//读取图片
byte[] b;
using (FileStream fs = new FileStream(@"F:\b1274.jpg", FileMode.Open))
{
b = new byte[fs.Length];
fs.Read(b, 0, b.Length);
}
//添加参数
SqlParameter[] parms = new SqlParameter[]{
new SqlParameter("@Pic", SqlDbType.Image)
};
parms[0].Value = b;
for (int i = 0; i < parms.Length; i++)
cmd.Parameters.Add(parms[i]);
cmd.ExecuteNonQuery();
}
conn.Close();
}
}
复制内容到剪贴板
程序代码

//读取
private void button2_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection("Data Source=127.0.0.1;Initial Catalog=Northwind;User ID=sa;Password=sa"))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "Select Top 1 Pic FROM Images orDER BY ID DESC";
cmd.CommandType = CommandType.Text;
pictureBox1.Image = Image.FromStream(new MemoryStream((byte[])cmd.ExecuteScalar()));
}
conn.Close();
}
}
private void button2_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection("Data Source=127.0.0.1;Initial Catalog=Northwind;User ID=sa;Password=sa"))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "Select Top 1 Pic FROM Images orDER BY ID DESC";
cmd.CommandType = CommandType.Text;
pictureBox1.Image = Image.FromStream(new MemoryStream((byte[])cmd.ExecuteScalar()));
}
conn.Close();
}
}
评论: 0 | 引用: 0 | 查看次数: 4070
发表评论
请登录后再发表评论!