从sql server 中读取二进制图片
/**//// <summary>
/// 显示示带图片的记录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
string sql = "";
sql = "SELECT OrName,OrTel, Orimage FROM Organize WHERE OrID = 1"; //
SqlConnection conn = new SqlConnection(DBConnectioin.conStr);
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
this.textBox1.Text =(string) reader["OrName"];
textBox2.Text = (string)reader["OrTel"];
MemoryStream ms = new MemoryStream((byte[])reader["Orimage"]);
Image image = Image.FromStream(ms, true);
reader.Close();
conn.Close();
pictureBox1.Image = image;
}
/// 显示示带图片的记录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
string sql = "";
sql = "SELECT OrName,OrTel, Orimage FROM Organize WHERE OrID = 1"; //
SqlConnection conn = new SqlConnection(DBConnectioin.conStr);
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
this.textBox1.Text =(string) reader["OrName"];
textBox2.Text = (string)reader["OrTel"];
MemoryStream ms = new MemoryStream((byte[])reader["Orimage"]);
Image image = Image.FromStream(ms, true);
reader.Close();
conn.Close();
pictureBox1.Image = image;
}
作者:阿笨
【官方QQ一群:跟着阿笨一起玩NET(已满)】:422315558
【官方QQ二群:跟着阿笨一起玩C#(已满)】:574187616
【官方QQ三群:跟着阿笨一起玩ASP.NET(已满)】:967920586
【官方QQ四群:Asp.Net Core跨平台技术开发(可加入)】:829227829
【官方QQ五群:.NET Core跨平台开发技术(可加入)】:647639415
【网易云课堂】:https://study.163.com/provider/2544628/index.htm?share=2&shareId=2544628
【腾讯课堂】:https://abennet.ke.qq.com
【51CTO学院】:https://edu.51cto.com/sd/66c64
【微信公众号】:微信搜索:跟着阿笨一起玩NET