有增删改查图片从sql数据库的类
class DataEditPhoto
{
public DataEditPhoto()
{ }
/// <summary>
/// 打开一个jpg\bmp\gif类型的图片文件返回其Image
/// </summary>
/// <returns>System.Drawing.Image</returns>
private Image openFileToPictureBox()
{ }
/// <summary>
/// 把图片保存到数据库
/// </summary>
/// <param name="fileName">图片路径</param>
/// <param name="conn">数据库连接</param>
/// <param name="insertSqlStr">insert语句如："INSERT INTO Photo(UID,Uhead) values(1,@Photo)"</param>
/// <param name="message">是否提示错误</param>
/// <returns>是否保存成功</returns>
private bool savePhoto(string fileName, SqlConnection conn, string insertSqlStr, bool message)
{}
/// <summary>
/// 更新数据库里的图片
/// </summary>
/// <param name="fileName">图片路径</param>
/// <param name="conn">数据库连接</param>
/// <param name="updateSqlStr">update语句，如："update Photo Set Uhead=@Photo where UID=1"</param>
/// <param name="message">是否提示错误</param>
/// <returns>是否更新成功</returns>
private bool updatePhoto(string fileName, SqlConnection conn, string updateSqlStr, bool message)
{}
/// <summary>
/// 查询数据库里的图片
/// </summary>
/// <param name="conn">数据库连接</param>
/// <param name="selectStr">select语句，如："SELECT Photo FROM photo WHERE ID=1"，只要一个字段</param>
/// <param name="message">是否提示错误</param>
/// <returns>图片的字节数组</returns>
private byte[] selectPhoto(SqlConnection conn,string selectStr,bool message)
{}
}
