Save text from database to text file : Text File Load Save « ADO.Net « C# / CSharp Tutorial

1. C# / CSharp Tutorial
2. ADO.Net
3. Text File Load Save

/*
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();
      }
   }
}