string title = "1112"; //文件标题
int filelength = fileup.PostedFile.ContentLength; //获取HtmlInputFile控件中上载文件的长度
byte[] uploadbuffer = new byte[filelength]; //设置缓存
Stream filestream = fileup.PostedFile.InputStream;
filestream.Read(uploadbuffer, 0, filelength);
string strSQL = "insert into exceltodb (fileid,DOC,FILETYPE) values (:fileid,:doc,:filetype)";
//fileid 为varchar2,doc为blob,filetype为varchar2
OracleConnection oconn = new OracleConnection(db.pcsConnectionString);
oconn.Open();
OracleCommand ocmd = new OracleCommand(strSQL,oconn);
ocmd.Parameters.Add("fileid",OracleType.VarChar);
ocmd.Parameters.Add("doc", OracleType.Blob);
ocmd.Parameters.Add("filetype", OracleType.VarChar);
ocmd.Parameters[0].Value = title;
ocmd.Parameters[1].Value = uploadbuffer;
ocmd.Parameters[2].Value = "application/ms-excel";
ocmd.ExecuteNonQuery();
oconn.Close();
另oledb连接字符串 OleDbConnection objConnection = new OleDbConnection("Provider=MSDAORA;Data Source=dbsrv;user id=uid;password=psw;persist security info=false;");
根据csdn上相关文章改写
下面继续研究如何读出来,有结果了post在下一篇