Question

C#中怎么从数据库中读取二进制图片

要具体详细点的代码

Answer 1

String sql = "select * from picture where [id]=2";
string str = "server=DA5A491B3F7544B;database=study;uid=sa;pwd=liyi123";
SqlConnection con = new SqlConnection(str);
con.Open();
SqlCommand cmd=new SqlCommand(sql,con);
SqlDataReader sdr = cmd.ExecuteReader();
if(sdr.HasRows)
{
sdr.Read();
byte[] bytes = (byte[]) sdr["pic"];
MemoryStream ms =new MemoryStream(bytes);
Image image = Image.FromStream(ms);
pictureBox1.Image = image;
}
sdr.Close();
con.Close();

Answer 2

- -
你的邮箱多少？ 我发一个txt的demo给你，你自己试着做。。。发出你的邮箱来