讀出並生成圖片到物理位置

public void Read()

{

byte[] MyData = new byte[0];

using (SqlConnection conn = new SqlConnection(sqlconnstr))

{

conn.Open();

SqlCommand cmd = new SqlCommand();

cmd.Connection = conn;

cmd.CommandText = "select * from T_img";

SqlDataReader sdr = cmd.ExecuteReader();

sdr.Read();

MyData = (byte[])sdr["ImgFile"];//讀取第一個圖片的位流

int ArraySize= MyData.GetUpperBound(0);//獲得資料庫中儲存的位流陣列的維度上限，用作讀取流的上限

FileStream fs = new FileStream(@"c:\00.jpg", FileMode.OpenOrCreate, FileAccess.Write);

fs.Write(MyData, 0, ArraySize);

fs.Close(); //-- 寫入到c:\00.jpg。

conn.Close();

Console.WriteLine("讀取成功");//檢視硬碟上的檔案

}

}