File.WriteAllBytes

File.WriteAllBytes

將存放在SQL2008的image型態欄位的檔案，轉成實體檔案
ps:以下程式在windows form測試

private void button1_Click(object sender, EventArgs e)
{
DataTable dt = ds.Tables["resultTable"];
DataRow dr = dt.rows[0];

File.WriteAllBytes(@"C:\" + dr["filename"].ToString(), (byte[])dr["data"]);
}