getdata.cs

这是一个关于用C#从数据库中加载图片和读取图片的小应用程序

using System;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.IO;

namespace photo
{
	public class image_query
	{
		string image_filename = null;
		byte[] image_bytes = null;

		SqlConnection image_connection = null;
		SqlCommand image_command = null;
		SqlDataReader image_reader = null;

		public image_query() 
		{
			image_connection = new SqlConnection(
				@"Data Source=(local);" +
				"Integrated Security=SSPI;" +
				"Initial Catalog=EAlbum;" +
				"Connect Timeout=3");

			image_command = new SqlCommand(
				@"SELECT name, photo FROM Photos", 
				image_connection);

			// Open the connection and read data into the DataReader.
			image_connection.Open();
			image_reader = image_command.ExecuteReader();
		}

		public Bitmap get_image()
		{
			MemoryStream ms = new MemoryStream(image_bytes);
			Bitmap bmap = new Bitmap(ms);
			return bmap;
		}

      
		public string get_filename()
		{
			return image_filename;
		}

		public bool get_row()
		{   
			//如果还可以读取 则读取该行
			if (image_reader.Read())
			{
				image_filename = (string) image_reader.GetValue(0);
				image_bytes = (byte[]) image_reader.GetValue(1);

				return true;
			}
			else 
			{
				return false;
			}
		}

		public void end_query() 
		{
			// Close the reader and the connection.
			image_reader.Close();
			image_connection.Close();
		}
	}
}