关于数据库储存图片的问题! Inserting Images to SqlServer in ASP .NEThttp://aspalliance.com/138 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 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"]); } if (dr.Read())//把图片从oracle数据库读出后并保存再本地 { //Stream imgdatastream = dr["ufiledata"]; byte[] bytes = (byte[])dr["ufiledata"]; Response.ContentType = dr["ufiletype"].ToString(); string path=@"d:\" + dr["ufiletitle"].ToString() + ".jpg"; FileStream fs = new FileStream(path, FileMode.Create, FileAccess.Write); //Response.BinaryWrite(bytes,); fs.Write(bytes,0,bytes.Length); // Response.Write(dr["ufiledata"]); } myCommand.Connection.Close();这是Oracle数据库的存贮图片的方法经本人修改后的版本! 从asp转过来觉得概念完全不一样了。 求一个正则表达式 ASP求助读取多条数据 sql怎么去除重复项 服务器附件无法上传!!! 虚拟服务器上的图片上传问题 散分,宝宝的生日快到了。顺便求一支生日歌,THX! 请问为什么我的label无法显示大量文字 请教如何解决sharpziplib.dll中的(.Zip)压缩中文问题。 在赋值时如何让DropDownList的值跳到相应的Items项??? 表的插入问题???在线跪求!!!!!!!!!!!!!!! 注册后向邮箱发确认信
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"]);
}
if (dr.Read())//把图片从oracle数据库读出后并保存再本地
{
//Stream imgdatastream = dr["ufiledata"];
byte[] bytes = (byte[])dr["ufiledata"];
Response.ContentType = dr["ufiletype"].ToString();
string path=@"d:\" + dr["ufiletitle"].ToString() + ".jpg";
FileStream fs = new FileStream(path, FileMode.Create, FileAccess.Write);
//Response.BinaryWrite(bytes,);
fs.Write(bytes,0,bytes.Length);
// Response.Write(dr["ufiledata"]);
}
myCommand.Connection.Close();这是Oracle数据库的存贮图片的方法经本人修改后的版本!