Save text from database to text file : Text File Load Save : ADO.Net C# Examples

    
/*
Quote  from


Beginning  C#  2005  Databases  From  Novice  to  Professional

#  Paperback:  528  pages
#  Publisher:  Apress  (December  18,  2006)
#  Language:  English
#  ISBN-10:  159059777X
#  ISBN-13:  978-1590597774
*/
using  System;
using  System.Data;
using  System.Data.SqlClient;

class  RetrieveText
{
      static  string  textFile  =  null;
      static  char[]  textChars  =  null;
      static  SqlConnection  conn  =  null;
      static  SqlCommand  cmd  =  null;
      static  SqlDataReader  dr  =  null;

      public  RetrieveText()
      {
            conn  =  new  SqlConnection(@"data  source  =  .\sqlexpress;integrated  security  =  true;initial  catalog  =  tempdb;");

            //  Create  command
            cmd  =  new  SqlCommand(@"select  textfile,textdata  from  texttable",  conn);

            //  Open  connection
            conn.Open();

            //  Create  data  reader
            dr  =  cmd.ExecuteReader();
      }

      public  static  bool  GetRow()
      {
            long  textSize;
            int  bufferSize  =  100;
            long  charsRead;
            textChars  =  new  Char[bufferSize];

            if  (dr.Read())
            {
                  //  Get  file  name
                  textFile  =  dr.GetString(0);
                  Console.WriteLine("------  start  of  file:");
                  Console.WriteLine(textFile);
                  textSize  =  dr.GetChars(1,  0,  null,  0,  0);
                  Console.WriteLine("---  size  of  text:  {0}  characters  -----",
                        textSize);
                  Console.WriteLine("---  first  100  characters  in  text  -----");
                  charsRead  =  dr.GetChars(1,  0,  textChars,  0,  100);
                  Console.WriteLine(new  String(textChars));
                  Console.WriteLine("---  last  100  characters  in  text  -----");
                  charsRead  =  dr.GetChars(1,  textSize  -  100,  textChars,  0,  100);
                  Console.WriteLine(new  String(textChars));  

                  return  true;
            }
            else
            {
                  return  false;
            }
      }

      public  static  void  endRetrieval()
      {
            //  Close  the  reader  and  the  connection.  
            dr.Close();
            conn.Close();
      }

      static  void  Main()
      {
            try
            {

                  while  (GetRow()  ==  true)
                  {
                        Console.WriteLine("-----  end  of  file:");
                        Console.WriteLine(textFile);
                  }
            }
            catch  (SqlException  ex)
            {
                  Console.WriteLine(ex.ToString());
            }
            finally
            {
                  endRetrieval();
            }
      }
}