可以参考图片上传的方式。Stream imgDataStream = u_photo.PostedFile.InputStream;
int imgDataLen = u_photo.PostedFile.ContentLength;
byte[] imgDataTemp = new byte[imgDataLen];
imgDataStream.Read( imgDataTemp, 0, imgDataLen );
strSql = "INSERT INTO UserInfo ( u_photo ) VALUES ( ? )";
myConnection.Open();
myCommand = new OleDbCommand( strSql, myConnection );
myCommand.Parameters.Add( ":u_photo", OleDbType.Binary, imgDataLen, "u_photo" ).Value = imgDataTemp;
myCommand.ExecuteNonQuery();显示:string strSql = "SELECT u_photo FROM UserInfo WHERE id = '"+ id +"'";
myConnection.Open();
myCommand = new OleDbCommand( strSql , myConnection );
myReader = myCommand.ExecuteReader();
if ( myReader.Read() )
{
byte[] btImage = ( byte[] )myReader["u_photo"];
Response.BinaryWrite( btImage );
Response.End();
}
int imgDataLen = u_photo.PostedFile.ContentLength;
byte[] imgDataTemp = new byte[imgDataLen];
imgDataStream.Read( imgDataTemp, 0, imgDataLen );
strSql = "INSERT INTO UserInfo ( u_photo ) VALUES ( ? )";
myConnection.Open();
myCommand = new OleDbCommand( strSql, myConnection );
myCommand.Parameters.Add( ":u_photo", OleDbType.Binary, imgDataLen, "u_photo" ).Value = imgDataTemp;
myCommand.ExecuteNonQuery();显示:string strSql = "SELECT u_photo FROM UserInfo WHERE id = '"+ id +"'";
myConnection.Open();
myCommand = new OleDbCommand( strSql , myConnection );
myReader = myCommand.ExecuteReader();
if ( myReader.Read() )
{
byte[] btImage = ( byte[] )myReader["u_photo"];
Response.BinaryWrite( btImage );
Response.End();
}
解决方案 »
- 求:C#,WebForm,导出WORD
- 两张表和一个存储过程引发的血案
- 绘制panel面板滚动条
- 【求助】求一左侧工具栏控件,可以伸缩的!非常感谢!---------->【我真的没分了!】
- C#的office编程问题
- c# socket如何实现接收下面得数据,并解析出来
- C# Winform画折线,设置线状态 (最佳答案100分)
- 分不多了,就给100吧,Redmine,哪位大牛再用,我今天试着按照网上的教程安装,出了点错误~
- .net 操作Excel保存的时候禁止弹出提示框
- 强技术问题??
- 谁有activereports for .net 2.0 注册文件,licensepro.exe 或 esdsetup.exe
- 再次悬赏100分求解10道很简单的C语言题目!!!!!!!!
<a href="路径"></a>