把图片存储到数据库并从数据库读出显示,可参考<<用GridView显示数据库中的图片>>
/// <summary>
/// 将照片转换为二进制数组
/// </summary>
/// <param name="path"></param>
/// <returns></returns> 
private byte PhotoToArray( string path )
{
FileStream stream = new FileStream( path , FileMode.Open , FileAccess.Read ) ;
byte bufferPhoto =new byte[stream.Length] ;
stream.Read( bufferPhoto,0,Convert.ToInt32( stream.Length ) ) ;
stream.Flush();
stream.Close();
return bufferPhoto ;
} //把二进制的图片插到数据库
private void Save(byte image)
{
string sql = "insert into table2(aaa,photo) values(@aaa,@photo)";
SqlParameter param=new SqlParameter;
param[0] =new SqlParameter("@aaa",SqlDbType.Int);
param[0].Value = 1;
param= new SqlParameter("@photo",SqlDbType.Image);
param.Value= image;
SqlConnection conn= new SqlConnection();
conn.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings[0];
SqlCommand commd= new SqlCommand(sql,conn);
commd.Parameters.Add(param[0]);
commd.Parameters.Add(param);
try
{
conn.Open();
commd.ExecuteNonQuery();
MessageBox.Show("把图片成功的插入数据库");
}
catch(Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
