Retrive A Binary Field From Database

hi

I have used the following code (mostly created by MSDN) to retrive a binary field from SQL database. it works but I have extra space between characters. for example if I save a text file with "Hello world" text, after retriving I have it like "H e l l o  w o r l d". what is the problem??????

I am really looking forward your answers

private void retrive()

{

public void a()

{

SqlConnection connection = new SqlConnection("Some Connection string");

SqlCommand command = new SqlCommand("Select * from temp", connection);

// Writes the BLOB to a file

FileStream stream;

// Streams the BLOB to the FileStream object.

BinaryWriter writer;

// Size of the BLOB buffer.

int bufferSize = 50;

// The BLOB byte[] buffer to be filled by GetBytes.

byte[] outByte = new byte[bufferSize];

// The bytes returned from GetBytes.

long retval;

// The starting position in the BLOB output.

long startIndex = 0;

// Open the connection and read data into the DataReader.

connection.Open();

SqlDataReader reader = command.ExecuteReader(CommandBehavior.SequentialAccess);

while (reader.Read())

{

// Create a file to hold the output.

stream = new FileStream(

"C:\file.txt", FileMode.OpenOrCreate, FileAccess.Write);

writer = new BinaryWriter(stream);

// Reset the starting byte for the new BLOB.

startIndex = 0;

// Read bytes into outByte[] and retain the number of bytes returned.

retval = reader.GetBytes(0, startIndex, outByte, 0, bufferSize);

// Continue while there are bytes beyond the size of the buffer.

while (retval == bufferSize)

{

writer.Write(outByte);

writer.Flush();

// Reposition start index to end of last buffer and fill buffer.

startIndex += bufferSize;

retval = reader.GetBytes(0, startIndex, outByte, 0, bufferSize);

}

// Write the remaining buffer.

if (retval != 0)

writer.Write(outByte, 0, (int)retval - 1);

writer.Flush();

// Close the output file.

writer.Close();

stream.Close();

}

// Close the reader and the connection.

reader.Close();

connection.Close();

}

}