为什么从数据库里面读取的image类型返回值是system.byte[].
SqlDataReader sqlre = Sqlconnection9(selectxt);
sqlre.Read();
Response.ContentType = "image/gif"; Response.BinaryWrite((Byte[])sqlre["f_img"]);
Response.OutputStream.Write((Byte[])sqlre["f_img"], 0,10000);
Response.BufferOutput = true;
Response.End();
sqlre.Close();
各位帮帮忙啊
SqlDataReader sqlre = Sqlconnection9(selectxt);
sqlre.Read();
Response.ContentType = "image/gif"; Response.BinaryWrite((Byte[])sqlre["f_img"]);
Response.OutputStream.Write((Byte[])sqlre["f_img"], 0,10000);
Response.BufferOutput = true;
Response.End();
sqlre.Close();
各位帮帮忙啊
Response.ContentType = "image/gif";
Byte[] data = (Byte[])sqlre["f_img"];
Response.OutputStream.Write(data, 0, data.Length);
Response.End();
(
f_id int identity(1,1) primary key,
f_img image
)
这是数据库代码?
Response.BinaryWrite((Byte[])reader["Photo"]);
Response.End();
var connStr = @"...";
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO Exitfiless (f_img) VALUES (@img)", conn);
SqlParameter param = new SqlParameter("@img", SqlDbType.Image, int.MaxValue);
param.Value = File.ReadAllBytes(@"E:\Picture\壁纸\1.jpg");
cmd.Parameters.Add(param);
cmd.ExecuteNonQuery();
}---------------------------------------------------// 读数据,并显示在网页上
Byte[] data = null;
var connStr = @"...";
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT TOP 1 * FROM Exitfiless", conn);
var dr = cmd.ExecuteReader();
if (dr.Read())
{
data = (Byte[])dr[1];
}
dr.Close();
}Response.Clear();
Response.OutputStream.Write(data, 0, data.Length - 300);
Response.End();
SqlDataReader sqlre = Sqlconnection9(selectxt);
sqlre.Read();
Response.ContentType = "image/gif"; Response.BinaryWrite((Byte[])sqlre["f_img"]);
Response.End();
sqlre.Close();