mysql上传图片后显示_上传图片至数据库再显示方法（MSSQL和MYSQL）

对于把图片上传至数据库的一点经验总结(MSSQL    MYSQL)

在MSSQL中   图片字读类型是IMAGE   但是在MYSQL中不存在IMAGE  ,而有的提到是用BOLB类型保存，我但建议是用LONGBOLB,因为在图片稍微较大时，用BOLB保存的图片只能显示半节。下面是具体的代码

上传部分

int len = FileUpload1.PostedFile.ContentLength;

byte[] pic = new byte[len];

FileUpload1.PostedFile.InputStream.Read(pic, 0, len);

string strImageType = FileUpload1.PostedFile.ContentType;

MySqlConnection connection = DAL.DBHelp.Conn();

// SqlConnection connection = new

//SqlConnection(@"server=ALLEN/SQLEXPRESS;Initial Catalog=GibbsCAMCert;Integrated Security=True");

try

{

//  connection.Open();

//   SqlCommand cmd = new SqlCommand("insert into photo "

///     + "(photo, type) values (@pic, @text)", connection);

string sql = "update tbl_resume set c_photo=?c_photo where c_uid='aaa111'";//, connection

MySqlCommand cmd = new MySqlCommand();

cmd.Connection = connection;

cmd.CommandText = sql;

cmd.CommandType = CommandType.Text;

cmd.Parameters.AddWithValue("?c_photo", pic);//.Paramters.AddWithValue();

string ss = cmd.CommandText;

cmd.ExecuteNonQuery();

//cmd.Parameters.Add("@pic", pic);

//cmd.Parameters.Add("@text", strImageType);

//cmd.ExecuteNonQuery();

}

finally

{

connection.Close();

}

注：如果是测试直接用

MySqlCommand cmd = new MySqlCommand("update tbl_resume set c_photo='"+pic+"' where c_uid='aaa111'",connection);这样存在数据库的大小会比图片实际字节小，读取的时候会显示不了(呵呵，具体哪出错了还没来的急研究，但我在调试的时候就因为这样郁闷了很久)

显示代码

MemoryStream stream = new MemoryStream();

//  SqlConnection connection = new SqlConnection(@"server=ALLEN/SQLEXPRESS;Initial Catalog=GibbsCAMCert;Integrated Security=True");

MySqlConnection connection = DAL.DBHelp.Conn();

try

{

//connection.Open();

//  SqlCommand command = new SqlCommand("select photo from photo", connection);

MySqlCommand command = new MySqlCommand("select c_photo from tbl_resume where c_uid='aaa111'", connection);

byte[] image = (byte[])command.ExecuteScalar();            stream.Write(image, 0, image.Length);            Bitmap bitmap = new Bitmap(stream);            Response.ContentType = "image/gif";            bitmap.Save(Response.OutputStream, ImageFormat.Gif);        }        finally        {            connection.Close();            stream.Close();        }