?

保存image到database

public bool SaveImage(string filePath)
{
bool isSuccess = false;
string FilePath = filePath;
string filename = FilePath.Substring(FilePath.LastIndexOf("\\") + 1); //得到上傳文件的文名
string filetext = string.Empty;
FileStream fs = new FileStream(FilePath, FileMode.OpenOrCreate, FileAccess.Read);
BinaryReader br = new BinaryReader(fs);
byte[] fileByte = br.ReadBytes((int)fs.Length);//將流讀入到字節數組中
//Byte[] fileByte = new Byte[(int)fs.Length];
//fs.Read(fileByte, 0, fileByte.Length);
//filetext = System.Text.Encoding.Default.GetString(fileByte); //將指定字節數組中的說有字節解碼為一個字符串
SqlConnection conn = new SqlConnection(@"server=.;database=SoyErp2.0;uid=sa;pwd=sa;");

conn.Open();
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO dbo.picSaveToSql ( ImgFile) VALUES ( @Photo )");
SqlCommand cmd = new SqlCommand(strSql.ToString(), conn);
cmd.Parameters.Add("@Photo", SqlDbType.Binary).Value = fileByte;
isSuccess =cmd.ExecuteNonQuery()>0?true:false;
conn.Close();
fs.Close();
return isSuccess;
}

//從database獲取圖片

public Bitmap Get_Image()
{
byte[] imagebytes = null;
SqlConnection conn = new SqlConnection(@"server=.;database=SoyErp2.0;uid=sa;pwd=sa;");
conn.Open();
SqlCommand com = new SqlCommand(" SELECT * FROM picSaveToSql WHERE Id=4 ", conn);
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
imagebytes = (byte[])dr.GetValue(1);
}
dr.Close();
conn.Close();
MemoryStream ms = new MemoryStream(imagebytes);
Bitmap bmpt = new Bitmap(ms);
return bmpt;
}

圖片內容保存到數據庫，并從數據庫里獲取圖片