一段.net windows应用程序的代码
#region//将图片写入数据库
/// <summary>
/// 存储图片
/// </summary>
/// <param name="openF">打开文件对话框</param>
/// <param name="cb">下拉列表框</param>
/// <param name="pb">图片框</param>
public void SaveImage(OpenFileDialog openF, ComboBox cb, PictureBox pb)//将图片以二进制存入数据库中
{
try
{
string strimg = openF.FileName.ToString(); //记录图片的所在路径
FileStream fs = new FileStream(strimg, FileMode.Open, FileAccess.Read); //将图片以文件流的形式进行保存
BinaryReader br = new BinaryReader(fs);
byte[] imgBytesIn = br.ReadBytes((int)fs.Length); //将流读入到字节数组中
conn.Open();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_pic(name,img) values(@Name,@Photo)");
SqlCommand cmd = new SqlCommand(strSql.ToString(), conn);
cmd.Parameters.Add("@Photo", SqlDbType.Binary).Value = imgBytesIn;
cmd.Parameters.Add("@Name", SqlDbType.Text).Value = strimg;
if (cmd.ExecuteNonQuery() == 1)
MessageBox.Show("上传成功");
conn.Close();
BindPicId(cb);
}
catch (Exception exp)
{
MessageBox.Show(exp.ToString());
}
}
#endregion