Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. OleDbConnection myConnection = new OleDbConnection("File Name = mylink.udl");
  2. myConnection.Open();
  3. OleDbCommand cmd = new OleDbCommand("SELECT Stu_Name,Photo FROM stu_Details WHERE Stu_ID ='" + stuid + "'", myConnection);
  4. var da = new OleDbDataAdapter(cmd);
  5. var ds = new DataSet();
  6. da.Fill(ds, "Photo");
  7. int count = ds.Tables["Photo"].Rows.Count;
  8.  
  9. if (count > 0)
  10. {
  11. var data = (Byte[])ds.Tables["Photo"].Rows[count - 1]["Photo"];
  12. var stream = new MemoryStream(data);
  13. pictureBox2.Image = Image.FromStream(stream);
  14. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement