t;
private void button2_Click(object sender, System.EventArgs e)
{
SqlConnection conn = new SqlConnection("server=192.168.2.200;integrated security = sspi;database = northwind");
SqlCommand cmd = new SqlCommand("select * from imgtable where imgname like '%bmp%'",conn);
conn.Open();
SqlDataReader dr;
try
{
dr = cmd.ExecuteReader();
dr.Read();
System.Data.SqlTypes.SqlBinary sb = dr.GetSqlBinary(2);
//或byte[] imageData = (byte[])dr[2];
MemoryStream ms = new MemoryStream(sb.Value);//在内存中操作图片数据
Bitmap bmp = new Bitmap(Bitmap.FromStream(ms));
this.pictureBox1.Image = bmp;
dr.Close();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
}
/// <summary>
/// 读取文件并保存到硬盘，然后打开文件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button3_Click(object sender, System.EventArgs e)
{
SqlConnection conn = new SqlConnection("server=192.168.2.200;integrated security = sspi;database = northwind");
SqlCommand cmd = new SqlCommand("select * from imgtable where imgname like '%doc'",conn);
conn.Open();
SqlDataReader dr;
try
{
dr = cmd.ExecuteReader();
上一页 [1] [2] [3] [4] [5] [6] 下一页 |
