bigger buffer corrupts file

[Guest]

Hi, I am really done. What is wrong with this simple code? Buffer with size
smaller than about 500 works. But bigger buffer results in corrupted file.
Generated file is bigger than the original (about 10 kB). Why? File is stored
in MS SQL server 2000. Thank you. Tom


if (dr.Read())
{

startIndex = 0;
this.retval = dr.GetBytes(2,startIndex,buffer,0,this.bufferSize);

while (this.retval == this.bufferSize)
{
Response.BinaryWrite(this.buffer);
Response.Flush();
this.startIndex += this.bufferSize;
this.retval = dr.GetBytes(2,startIndex,buffer,0,this.bufferSize);
}
Response.BinaryWrite(this.buffer);
Response.Flush();

Response.End();
}
dr.Close();