C# SQl2008读取图片

来源：互联网发布：如何查看5s支持网络编辑：程序博客网时间：2024/05/17 22:02

        private void button1_Click(object sender, EventArgs e)
        {
            //通过员工工号获取照片
            pictureBox1.Image = null;
            using (SqlConnection conn = new SqlConnection(@"server=192.168.1.100;uid=sa;pwd=sa;database=erp"))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "select * from hra110";
                    using (SqlDataReader reader = cmd.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            string strno = reader.GetString(0).ToString();
                            if (strno == textBox1.Text.Trim())
                            {

                                MemoryStream buf=new MemoryStream((byte[])reader[1]);

Image image=Image.FromStream(buf,true);

pictureBox1.Image=image;

                            }

                        }

}

            }
        }