retrieve an image from oracle table

string show = "select NOTES_FILE from sample_file where FILE_ID=1";
con.Open(); // this is database connection
FileStream showFile;
BinaryWriter bw;
int buffsize = 100;
byte[] output = new byte[buffsize];
long retval;
long startindex;
OracleCommand cmd2 = new OracleCommand(show, con);
OracleDataReader dr = cmd2.ExecuteReader(CommandBehavior.SequentialAccess);
string savedimage="c:/vyas.jpg";
while (dr.Read())
{
showFile = new FileStream(savedimage, FileMode.Create);
bw = new BinaryWriter(showFile);
startindex = 0;
retval = dr.GetBytes(0, startindex, output, 0, buffsize);
while (retval == buffsize)
{
bw.Write(output);
bw.Flush();
startindex += buffsize;
retval = dr.GetBytes(0, startindex, output, 0, buffsize);
}


bw.Write(output,0,(int)retval-1);
bw.Flush();
bw.Close();
showFile.Close();

insert image into oracle table

FileStream fls;
fls = new FileStream(FileUpload1.PostedFile.FileName, FileMode.Open, FileAccess.Read);
byte[] blob = new byte[fls.Length];
fls.Read(blob, 0, System.Convert.ToInt32(fls.Length));
fls.Close();
con.Open();
string query = "insert into sample_file values(" + imageid.Text + "," + "'" + imagename.Text + "'," + " :BlobParameter )";

//insert the byte as oracle parameter of type blob
OracleCommand cmd;
OracleParameter blobParameter = new OracleParameter();
blobParameter.OracleType = OracleType.Blob;
blobParameter.ParameterName = "BlobParameter";
blobParameter.Value = blob;
cmd = new OracleCommand(query, con);
cmd.Parameters.Add(blobParameter);
cmd.ExecuteNonQuery();
con.Close();


Using.System.IO; //use this name space

sending sms from asp.net web application using ur mobile

GsmCommMain comm = new GsmCommMain(1, 9600, 300);
try
{
comm.Open();
if (comm.IsConnected())
{
// port no exmaple 1 or 2 or 3 or 4
GsmCommMain gpu = new GsmCommMain(port no, 9600, 300);
gpu.Close();
gpu.Open();
SmsSubmitPdu pdu = new SmsSubmitPdu("message to mobile", "9901652178");
gpu.SendMessage(pdu);
gpu.Close();

{

Label15.Text = "Connection Successful";
//return;
}

}
else
{
Label15.Text = "No Mobile Connected";
}
comm.Close();
}

download this dll files mentioned below and add that dll`s to ur application reference.
http://rapidshare.com/files/144123194/GSMCommunication.dll
http://rapidshare.com/files/144354385/PDUConverter.dll.html