从SQL Server中读写大数据列。--打印文章

从SQL Server中读写大数据列。

作者：武汉SEO闵涛文章来源：敏韬网点击数3639 更新时间：2007/11/14 13:08:02 文章录入：mintao 责任编辑：mintao

;

BinaryWriter rbw;

long numread;

long startIndex;

int buffSize=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);