Store The Data From A Database Into A File.

how to use class iDataReader's function getbytes(...............) to read binary data? 

 

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Data.Common;
using System.IO;


public partial class uploadFileToDatabase : System.Web.UI.Page
{
    string strUser;
    protected void Page_Load(object sender, EventArgs e)
    {
      strUser=Request.QueryString["download"];
      if(strUser!=null)
      {
        string strConn="Data Source=hao-pc;Initial Catalog=simpleBBS;Persist Security Info=True;User ID=sa;Password=123;Pooling=False";       
        SqlDataAdapter sda=new SqlDataAdapter();
        DbProviderFactory dbProviderFactory=DbProviderFactories.GetFactory("System.Data.SqlClient");
        DbConnection dbConn=dbProviderFactory.CreateConnection();
        dbConn.ConnectionString=strConn;
        dbConn.Open();
        DbCommand dbComm=dbProviderFactory.CreateCommand();
        dbComm.Connection=dbConn;
        dbComm.CommandText="select * from userFiles2 where fileisn='"+strUser+"'";
        IDataReader myReader=dbComm.ExecuteReader();
        int strFileLen=0;
        if(myReader.Read())
        {
        strFileLen=Convert.ToInt32(myReader.GetString(3));
        FileStream afs;
        string fPath;
        fPath = Server.MapPath(Request.ApplicationPath) + "\upLoadFiles\" + myReader.GetString(1);
        afs = new FileStream(fPath, FileMode.OpenOrCreate, FileAccess.Write);
        Byte[] filedata = new Byte[strFileLen];
       
        afs.Write(filedata, 0, strFileLen);
       
        BinaryWriter abw;
       
          int iBufferSize=1000;
          Byte[] outbyte=new Byte[iBufferSize-1];
          long retval;
          long starIndex=0;
         
          abw=new BinaryWriter(afs);
          starIndex=0;
          int itemNum=4;
          retval=myReader.GetBytes(itemNum,starIndex,outbyte,0,iBufferSize);  //when i store  large data into a file it display an error such as "Buffer offset '0' plus the bytes '82452' is greater than the length of the passed in buffer.
            abw.Write(outbyte);
           
            starIndex+=iBufferSize;
            retval=myReader.GetBytes(itemNum,starIndex,outbyte,0,iBufferSize);
          } 
            abw.Write(outbyte);
            abw.Flush();
            abw.Close();
            afs.Close();
            myReader.Close();
            dbComm.Dispose();
          
        }
      }     
         
         
       
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
      string strFileName;
      string strFileType;
      int strFileLen;
      Random ran=new Random();
      string strFileISN=DateTime.Now.ToString("yyyyMMddhhmmss")+ran.Next(0,999);
      if(FileUpload1.PostedFile.FileName!=null)
      {
        strFileName=FileUpload1.PostedFile.FileName;
        strFileType=strFileName.Substring(strFileName.LastIndexOf(".")+1);
        strFileName=strFileName.Substring(strFileName.LastIndexOf("\")+1);
        strFileLen=FileUpload1.PostedFile.ContentLength;
        string strConn="Data Source=hao-pc;Initial Catalog=simpleBBS;Persist Security Info=True;User ID=sa;Password=123;Pooling=False";       
        SqlDataAdapter sda=new SqlDataAdapter();
        DbProviderFactory dbProviderFactory=DbProviderFactories.GetFactory("System.Data.SqlClient");
        DbConnection dbConn=dbProviderFactory.CreateConnection();
        dbConn.ConnectionString=strConn;
        dbConn.Open();
        DbCommand dbComm=dbProviderFactory.CreateCommand();
        dbComm.Connection=dbConn;
        string dateTime=DateTime.Now.ToString();
        Stream fs=FileUpload1.PostedFile.InputStream;
        Byte[] filedata=new Byte[strFileLen];
        fs.Read(filedata,0,strFileLen);       
        dbComm.CommandText="insert into userFiles2 (fileisn,filename,filetype,filesize,filecontent,uploadTime) values (@fileisn,@filename,@filetype,@filesize,@filecontent,@uploadTime)";
        dbComm.Parameters.Add(new SqlParameter("@fileisn", (object)strFileISN));
        dbComm.Parameters.Add(new SqlParameter("@filename",(object)strFileName));
        dbComm.Parameters.Add(new SqlParameter("@filetype",(object)strFileType));
        dbComm.Parameters.Add(new SqlParameter("@filesize",(object)strFileLen.ToString()));
        dbComm.Parameters.Add(new SqlParameter("@filecontent",(object)filedata));
        dbComm.Parameters.Add(new SqlParameter("@uploadTime",(object)dateTime));
        dbComm.ExecuteNonQuery();
        fs.Close();
        dbConn.Close();
        dbComm.Dispose();
        dbConn.Close();
      } 
    } 
}