Exporting to text file, last row not exported.

• Directly export data via Excel automation (see, for instance "How to automate Excel from Visual Basic .NET to fill or to obtain data in a range by using arrays" at MSDN[^].

• Export your data in the very simple CSV[^] file format (Google helps[^]). Since Excel is able to import data from a CSV file.

using System;
using System.Data;
using System.Data.SqlClient;
using System.IO;

   private void WriteDataFile()
   {
      string connString = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";
      string sql = @"select * from employee";
      SqlConnection conn = new SqlConnection(connString);
      string text="";
      try
      {
         conn.Open();
         SqlDataAdapter da = new SqlDataAdapter(sql, conn);
         DataSet ds = new DataSet();    
         da.Fill(ds, "employee");
         DataTable dt = ds.Tables["employee"];
         foreach (DataRow row in dt.Rows)
         {
	    text += "\r\n";
            foreach (DataColumn col in dt.Columns)
            {		
		text += row[col].ToString() + "  ";
            }
         }
         // Here Write the text in txt file

 	FileStream fs1 = new FileStream("D:\\Yourfile.txt", FileMode.OpenOrCreate, FileAccess.Write);
        StreamWriter writer = new StreamWriter(fs1);
        writer.WriteLine(text);
        writer.Close();

      }
      catch(Exception e)
      {
         Console.WriteLine("Error: " + e);
      }
      finally
      {
         conn.Close();
      }
   }  

using System.IO;
 
   private void WriteDataFile()
   {
      // Initialize Connection string
      string connString = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";

      // Define Query to fetch Data From DatabaseTable
      string sql = @"select * from employee";

      // Initialize SQL Connection
      SqlConnection conn = new SqlConnection(connString);
      string text="";
      try
      {
	 // Initialize SQLDataAdapter to fetch data from tables
         SqlDataAdapter da = new SqlDataAdapter(sql, conn);

	 // Initialize DataSet
         DataSet ds = new DataSet();    

	 // Fill DataSet
         da.Fill(ds, "employee");

	 // Extract Data from DataSet in DataTable
         DataTable dt = ds.Tables["employee"];

	 // Loop to fetch Data From DataTable Row By Row
         foreach (DataRow row in dt.Rows)
         {
	    // Add New Line to Variable
	    text += "\r\n";

	    // Read a Row from DataTable & Add to text
            foreach (DataColumn col in dt.Columns)
            {		
		text += row[col].ToString() + "  ";
            }
         }
         // Here Write the text in txt file

	// Open File Stream in Which Data is to be Saved
 	FileStream fs1 = new FileStream("D:\\Yourfile.txt", FileMode.OpenOrCreate, FileAccess.Write);

	// Writing Data To Stream using StreamWriter
        StreamWriter writer = new StreamWriter(fs1);
	writer.WriteLine(text);

	//Close The Stram Writer 
        writer.Close();
        
	// Close File Stream
	fs1.Close();
      }
      catch(Exception e)
      {
         Response.Write("Error: " + e);
      }
      finally
      {
         conn.Close();
      }
   }