Read and Write large objects to the sqlserver Database

Public static void main ()
{
// Write large objects to sqlserver
Filestream FS = new filestream ("C: \ test.bmp", filemode. Open, fileaccess. Read );
Binaryreader BR = new binaryreader (FS );

Sqlconnection conn = new sqlconnection ("Server = localhost; uid = sa; Pwd = sa; database = northwind ");

String plain text = "Update employees" +
"Set photo = @ image where employeeid = 1 ";

Sqlcommand cmd = new sqlcommand (plain text, Conn );
Cmd. Parameters. Add ("@ image", sqldbtype. Image );

Cmd. Parameters ["@ image"]. value = Br. readbytes (INT) Br. basestream. Length );

Conn. open ();
Int I = cmd. executenoquery ();

// Read large objects from SQL Server
String plain text = "select employeeid, photo" +
"From employees where employeeid = 1 ";

Sqlcommand cmd2 = new sqlcommand (plain text, Conn );

Filestream RFS;
Binarywriter rbw;

Long numread;
Long startindex;
Int buffer size = 4096;
Byte [] buff = new byte [buffsize];

Conn. open ();
Sqldatareader RDR = cmd. executereader (commandbehavior. sequentialaccess );

If (RDR. Read ())
{
Int empid = RDR. getint32 (0 );

FS = new filestream ("C: \ mypic.bmp", filemode. openorcreate, fileaccess. Write );
BW = new binarywrite (FS );

Startindex = 0;

Numread = RDR. getbytes (1, startindex, buff, 0, buffsize );

While (numread = buffsize)
{
Bw. Write (buff );
Bw. Flush ();
Startindex + = buffsize;
Numread = RDR. getbytes (1, startindex, buff, buffsize );
}
Bw. Write (buff );
Bw. Flush ();

Bw. Close ();
FS. Close ();
}
RDR. Close ();
Conn. Close ();

}