public class ImagesFromDatabase{ string MyimageFilename = null; byte[] MyimageBytes = null; SqlConnection MySqlConnection = null; SqlCommand MySqlCommand = null; SqlDataReader MySqlDataReader = null; public ImagesFromDatabase() { MySqlConnection = new SqlConnection("Your Connection String"); MySqlCommand = new SqlCommand(@"select MyFileName, MyFileData from MyTable", MySqlConnection); MySqlConnection.Open(); MySqlDataReader = MySqlCommand.ExecuteReader(); } public Bitmap GetImage() { MemoryStream MyMemoryStream = new MemoryStream(MyimageBytes); Bitmap MyBitmap = new Bitmap(MyMemoryStream); return MyBitmap; } public string GetFilename() { return MyimageFilename; } public bool HaveImages() { if (MySqlDataReader.Read()) { MyimageFilename = (string) MySqlDataReader.GetValue(0); MyimageBytess = (byte[]) MySqlDataReader.GetValue(1); return true; }else { return false; } } public void CloseObjects() { MySqlDataReader.Close(); MySqlConnection.Close(); }}
ImagesFromDatabase MyImages= new ImagesFromDatabase();if (MyImages.HaveImages()) { this.textBox1.Text = MyImages.GetFilename(); this.pictureBox1.Image = (Image) MyImages.GetImage();}MyImages.CloseObjects()