C#

countnazgul wrote:

byte[] MyData = new byte[0];

countnazgul wrote:

int ArraySize = new int();

countnazgul wrote:

System.Convert.ToInt32(fs.Length-1)

MySqlConnection Conn = new MySqlConnection("SERVER=localhost;" +
"DATABASE=db;" +
"UID=user;" +
"PASSWORD=root;");

MySqlCommand Cmd = new MySqlCommand("Select * From test where id = 19", Conn);
Cmd.CommandType = CommandType.Text;
Conn.Open();
MySqlDataReader Reader = Cmd.ExecuteReader(CommandBehavior.CloseConnection);
FileStream FStream = null;
BinaryWriter BWriter = null;

byte[] Binary = null;
const int ChunkSize = 100;
int SizeToWrite = 0;
MemoryStream MStream = null;

while (Reader.Read())
{
    FStream = new FileStream(@"c:\Data\Nomenclature123.xls", FileMode.OpenOrCreate, FileAccess.Write);
    BWriter = new BinaryWriter(FStream);
    Binary = (Reader["blobdata"]) as byte[];
    SizeToWrite = ChunkSize;
    MStream = new MemoryStream(Binary);

    for (int i = 0; i < Binary.GetUpperBound(0) - 1; i = i + ChunkSize)
    {
        if (i + ChunkSize >= Binary.Length) SizeToWrite = Binary.Length - i;
        byte[] Chunk = new byte[SizeToWrite];
        MStream.Read(Chunk, 0, SizeToWrite);
        BWriter.Write(Chunk);
        BWriter.Flush();
    }
    BWriter.Close();
    FStream.Close();
}
FStream.Dispose();

countnazgul wrote:

Thank You gays for responses!

srinivas0099 wrote:

How Can I achieve this?

srinivas0099 wrote:

if you have sample code then only....

srinivas0099 wrote:

other wise give me some reference books name..