例子:
Int32 imageSize;//图片大小
string imageType;//图片类型
string imageName;
/// <summary>
///读到图片插入数据库
/// </summary>
private void InsertImage()
{ Int32 imageSize = txtFile.PostedFile.ContentLength;
imageType = txtFile.PostedFile.ContentType;
imageName = txtFile.PostedFile.FileName;
Stream im = txtFile.PostedFile.InputStream;
byte[] content = new byte[imageSize];
int n = im.Read(content,0,imageSize);
OracleCommand cmd = new OracleCommand("insert into image values(:aa,:bb,:cc)",yourConn);
OracleParameter []pa = {
new OracleParameter("aa",OracleType.VarChar),
new OracleParameter("bb",OracleType.VarChar),
new OracleParameter("cc",OracleType.Blob)
};
pa[0].Value = imageName;
pa[1].Value = imageType;
pa[2].Value = content;
cmd.Parameters.Add(pa[0]);
cmd.Parameters.Add(pa[1]);
cmd.Parameters.Add(pa[2]);
yourConn.Open();
cmd.ExecuteNonQuery();
yourConn.Close();
}
Int32 imageSize;//图片大小
string imageType;//图片类型
string imageName;
/// <summary>
///读到图片插入数据库
/// </summary>
private void InsertImage()
{ Int32 imageSize = txtFile.PostedFile.ContentLength;
imageType = txtFile.PostedFile.ContentType;
imageName = txtFile.PostedFile.FileName;
Stream im = txtFile.PostedFile.InputStream;
byte[] content = new byte[imageSize];
int n = im.Read(content,0,imageSize);
OracleCommand cmd = new OracleCommand("insert into image values(:aa,:bb,:cc)",yourConn);
OracleParameter []pa = {
new OracleParameter("aa",OracleType.VarChar),
new OracleParameter("bb",OracleType.VarChar),
new OracleParameter("cc",OracleType.Blob)
};
pa[0].Value = imageName;
pa[1].Value = imageType;
pa[2].Value = content;
cmd.Parameters.Add(pa[0]);
cmd.Parameters.Add(pa[1]);
cmd.Parameters.Add(pa[2]);
yourConn.Open();
cmd.ExecuteNonQuery();
yourConn.Close();
}
上传的:
Stream imgdatastream = File1.PostedFile.InputStream;
int imgdatalen = File1.PostedFile.ContentLength;
string imgtype = File1.PostedFile.ContentType;
string imgtitle = TextBox1.Text;
byte[] imgdata = new byte[imgdatalen];
int n = imgdatastream.Read(imgdata,0,imgdatalen);
OracleCommand myCommand = new OracleCommand("INSERT INTO uu(ufiletitle, ufiletype, ufiledata) VALUES (:imgtitle,:imgtype, :imgdata)");
myCommand.Connection = new OracleConnection("Data Source=OA;User ID=jack;Password=dian;Integrated Security=no;");
myCommand.CommandType = CommandType.Text;
OracleParameter paramtitle = new OracleParameter( ":imgtitle", OracleType.VarChar, 50);
paramtitle.Value = imgtitle;
myCommand.Parameters.Add( paramtitle );
OracleParameter paramtype = new OracleParameter( ":imgtype", OracleType.VarChar, 50);
paramtype.Value = imgtype;
myCommand.Parameters.Add( paramtype ); OracleParameter paramData = new OracleParameter( ":imgdata", OracleType.LongRaw);
paramData.Value = imgdata;
myCommand.Parameters.Add( paramData ); myCommand.Connection.Open();
myCommand.ExecuteNonQuery(); myCommand.Connection.Close();
显示的:
OracleCommand myCommand = new OracleCommand("SELECT ufiletype,ufiledata FROM UU where ufiletitle='bnm'");
myCommand.Connection = new OracleConnection("Data Source=OA;User ID=jack;Password=dian;Integrated Security=no;");
myCommand.CommandType = CommandType.Text;
myCommand.Connection.Open();
OracleDataReader dr =myCommand.ExecuteReader();
if(dr.Read())
{
//Stream imgdatastream = dr["ufiledata"];
Response.ContentType = dr["ufiletype"].ToString();
Response.BinaryWrite((byte[])dr["ufiledata"]);
//Response.Write(dr["ufiledata"]);
}
myCommand.Connection.Close();