filename =
filMyFile.PostedFile.FileName; FileStream
fls;
fls = new
FileStream(filename, FileMode.Open,
FileAccess.Read);
blob = new
byte[fls.Length];
fls.Read(blob, 0, System.Convert.ToInt32(fls.Length));
fls.Close();
query = "insert into poemmaster values(" + pid + ",'" + txtTitle.Text + "'," + "
:BlobParameter," +uid+",'"+
ddlCategory.SelectedValue.ToString() + "',default)";
OracleParameter
blobParameter = new OracleParameter();
blobParameter.OracleType = OracleType.Blob;
blobParameter.ParameterName = "BlobParameter";
blobParameter.Value = blob;
cmnd = new
OracleCommand(query, conn1);
cmnd.Parameters.Add(blobParameter);
cmnd.ExecuteNonQuery();
Retrieve.aspx.cs(Retrieve
file code)
FileStream FS = new FileStream("word.doc", FileMode.Create);
foreach
(DataRow dr in
dt.Rows)
{
lblPoemName.Text =
dr[1].ToString();
byte[]
blob = (byte[])dr[2];
lblCategory.Text =
dr[4].ToString();
lblFName.Text = dr[7].ToString();
lblLName.Text =
dr[8].ToString();
FS.Write(blob, 0, blob.Length);
FS.Close();
FileStream
fs2 = new FileStream("word.doc", FileMode.Open,
FileAccess.Read);
StreamReader
sReader2 = new StreamReader(fs2,
System.Text.Encoding.Default);
line = sReader2.ReadLine();
while
((line = sReader2.ReadLine()) != null)
{
txtTitle.Text = txtTitle.Text
+ "\r\n" + sReader2.ReadLine();
}
sReader2.Close();
}