word存入oracle,使用流上传WORD和下载WORD（oracle）

private void Button1_Click(object sender, System.EventArgs e)

{

int intDocLen = File1.PostedFile.ContentLength;

byte[] Docbuffer = new byte[intDocLen];

Stream objStream;

objStream = File1.PostedFile.InputStream;

objStream.Read(Docbuffer, 0, intDocLen);

OracleConnection con = new OracleConnection("user id=nj;data source=njoraclelocal;password=124578;");

con.Open();

OracleCommand cmd = new OracleCommand("InSert Into AAAA(WORD) Values(:word)",con);

OracleParameter para = new OracleParameter(":word",OracleType.Blob);

para.Value = Docbuffer;

para.Size = Docbuffer.Length;

cmd.Parameters.Add(para);

cmd.ExecuteNonQuery();

con.Close();

//   objStream.Close();

}

private void Button2_Click(object sender, System.EventArgs e)

{

//   OracleConnection con = new OracleConnection("user id=nj;data source=NJORACLELOCAL;password=124578;");

//   OracleCommand cmd = new OracleCommand("Select * From AAAA",con);

//      con.Open();

//   OracleDataReader dr = cmd.ExecuteReader();

//   dr.Read();

//   Byte[] words = (Byte[])dr["WORD"];

//   Response.OutputStream.Write(words,0,words.Length);

string queryString = "Select * From AAAA where ROWID = 'AAAHsVAAJAAAAuHAAB'";

OracleConnection conn = new OracleConnection("user id=nj;data source=NJORACLELOCAL;password=124578;");

OracleCommand cmd = new OracleCommand(queryString,conn);

conn.Open();

OracleDataReader dr = cmd.ExecuteReader();

if (dr.Read())

{

Response.Clear();

Response.AddHeader("Content-Type", "application/msword");

//    Response.AddHeader("content-type","text/html");

Response.BinaryWrite((byte[])dr["WORD"]);//WDSJ为该BLOB字段名

}

dr.Close();

conn.Close();

}