【数据库课程设计】主页面(二)
我们注册添加了插入图片功能,那么也在主页面显示图片:
1 private void pictureBox1_Click(object sender, EventArgs e) 2 { 3 string uName = Form1.UserName; 4 int id = Form1.ID; 5 string sql = "select Image from StaffAccount where ID = '" + id + "'"; 6 string connstr = ConfigurationManager.ConnectionStrings["SQL"].ConnectionString; 7 SqlConnection conn = new SqlConnection(connstr); 8 SqlCommand cmd = new SqlCommand(sql, conn); 9 10 conn.Open(); 11 SqlDataReader r = cmd.ExecuteReader(); 12 r.Read(); 13 byte[] bs = (byte[])r["Image"]; 14 MemoryStream ms = new MemoryStream(bs, true); 15 ms.Write(bs, 0, bs.Length); 16 pictureBox1.Image = new Bitmap(ms, true); 17 ms.Dispose(); 18 conn.Close(); 19 }
1 private void panel1_Paint(object sender, PaintEventArgs e) 2 { 3 display(); 4 } 5 private void display() 6 { 7 string uName = Form1.UserName; 8 int id = Form1.ID; 9 string sql = "select Image from StaffAccount where ID = '" + id + "'"; 10 string connstr = ConfigurationManager.ConnectionStrings["WindowsFormsApplication6.Properties.Settings.staffConnectionString1"].ConnectionString; 11 SqlConnection conn = new SqlConnection(connstr); 12 SqlCommand cmd = new SqlCommand(sql, conn); 13 14 conn.Open(); 15 SqlDataReader r = cmd.ExecuteReader(); 16 r.Read(); 17 byte[] bs = (byte[])r["Image"]; 18 MemoryStream ms = new MemoryStream(bs, true); 19 ms.Write(bs, 0, bs.Length); 20 pictureBox1.Image = new Bitmap(ms, true); 21 ms.Dispose(); 22 conn.Close(); 23 }