MSSQL数据库中有个字段类型为Image C#中应该用什么类型? RT 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 读取图片了private void button_showimg_Click(object sender, EventArgs e){string sqlText = "server=localhost;initial catalog=Test; integrated security=true";string sqlstr = "select *from tast where whf=1";SqlConnection conn = new SqlConnection(sqlText);conn.Open();SqlCommand comm = new SqlCommand(sqlstr, conn);SqlDataAdapter da=new SqlDataAdapter ();da.SelectCommand=comm;DataSet ds=new DataSet ();da.Fill(ds);MemoryStream ms = new MemoryStream((byte[])ds.Tables[0].Rows[0][1]);Image i = Image.fromStream(ms,true);pictureBox1.Image = i;} 下面是插入图像到数据库,代码如下: private void button_connect_Click(object sender, EventArgs e){string sqlText = "server=localhost;initial catalog=Test; integrated security=true";string sqlstr = "insert into tast(photo) values(@image) ";SqlConnection conn = new SqlConnection(sqlText);conn.Open();SqlCommand comm = new SqlCommand(sqlstr, conn);comm.Parameters.Add("@image", SqlDbType.Image).Value = GetPhoto("DSC_6126.JPG");comm.ExecuteNonQuery();conn.Close();}public byte[] GetPhoto(string str1){string str = str1;FileStream file = new FileStream(str, FileMode.Open, FileAccess.Read);byte[]photo=new byte[file.Length];file.Read(photo,0,photo.Length);file.Close();return photo;} http://hi.csdn.net/invite.php?u=3370434&c=9cb528505d2f42a0 加好友谢谢! 大家来看看,关于net的反射, 我有一个菜单项里面有个叫AAA 的选项, 然后数据库里面存放了一个AAA字符串............. C# VS2005能为一个编好的项目制作安装文件吗? ???我做的spider不需要下载gif,.exe,pdf...等文件,我该如何判断 为什么程序越运行,占内存越大 谁有<C#线程参考手册>的源代码 为什么.net生成的程序启动的时候好慢,有什么办法可以优化吗?谢谢! 悬而未决的问题 请问,如何获得新插入的数据的索引号 请问C#如何实现一个物理网卡虚拟出多个IP地址? "委托"(delegete)以后就翻译为"代理函数" 无法找到C#命名空间?
private void button_showimg_Click(object sender, EventArgs e)
{
string sqlText = "server=localhost;initial catalog=Test; integrated security=true";
string sqlstr = "select *from tast where whf=1";
SqlConnection conn = new SqlConnection(sqlText);
conn.Open();
SqlCommand comm = new SqlCommand(sqlstr, conn);
SqlDataAdapter da=new SqlDataAdapter ();
da.SelectCommand=comm;
DataSet ds=new DataSet ();
da.Fill(ds);
MemoryStream ms = new MemoryStream((byte[])ds.Tables[0].Rows[0][1]);
Image i = Image.fromStream(ms,true);
pictureBox1.Image = i;
}
private void button_connect_Click(object sender, EventArgs e)
{
string sqlText = "server=localhost;initial catalog=Test; integrated security=true";
string sqlstr = "insert into tast(photo) values(@image) ";
SqlConnection conn = new SqlConnection(sqlText);
conn.Open();
SqlCommand comm = new SqlCommand(sqlstr, conn);
comm.Parameters.Add("@image", SqlDbType.Image).Value = GetPhoto("DSC_6126.JPG");
comm.ExecuteNonQuery();
conn.Close();
}
public byte[] GetPhoto(string str1)
{
string str = str1;
FileStream file = new FileStream(str, FileMode.Open, FileAccess.Read);
byte[]photo=new byte[file.Length];
file.Read(photo,0,photo.Length);
file.Close();
return photo;
}