DaniWeb Forum Index > Software Development > C#

C# RSS

Read certain # of lines

Please support our C# advertiser: Intel Parallel Studio Home

•

Join Date: Sep 2007

Posts: 28

Reputation: SiPexTBC is an unknown quantity at this point

Solved Threads: 0

SiPexTBC

Offline

Light Poster

Read certain # of lines

Nov 21st, 2007

I have a program that reads an sql file and then executes it into the mysql database. The problem is that when a file larger than 1 mb is executed, an error comes up saying the file is too large. Is there anyway that i can read, say 200 lines of the file, and execute that?

Any help would be appreciated

SiPex

Last edited by SiPexTBC; Nov 21st, 2007 at 8:25 pm.

•

Join Date: Apr 2007

Posts: 103

Reputation: mariocatch is an unknown quantity at this point

Solved Threads: 17

mariocatch mariocatch is offline

Offline

Junior Poster

Re: Read certain # of lines

Nov 21st, 2007

Try using StreamReader.

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
 
namespace ReadLines
{
    class Program
    {
 
 
        static void Main(string[] args)
        {
 
            using (StreamWriter _SW = new StreamWriter("File.txt"))
            {
                for (int i = 0; i < 200; i++)
                    _SW.WriteLine("Pre-200 #: " + i);
                for (int i = 0; i < 50; i++)
                    _SW.WriteLine("Post-200 #: " + i);
            }
 
            using (StreamReader _SR = new StreamReader("File.txt", Encoding.UTF8))
            {
                for(int i = 0; i < 200; i++)
                    Console.WriteLine(_SR.ReadLine());
            }
 
            Console.WriteLine("\n\n\nPress any key to exit");
            Console.ReadLine();
        }
    }
}
using System;
using System.Collections.Generic;
using System.Text;
using System.IO;

namespace ReadLines
{
    class Program
    {


        static void Main(string[] args)
        {

            using (StreamWriter _SW = new StreamWriter("File.txt"))
            {
                for (int i = 0; i < 200; i++)
                    _SW.WriteLine("Pre-200 #: " + i);
                for (int i = 0; i < 50; i++)
                    _SW.WriteLine("Post-200 #: " + i);
            }

            using (StreamReader _SR = new StreamReader("File.txt", Encoding.UTF8))
            {
                for(int i = 0; i < 200; i++)
                    Console.WriteLine(_SR.ReadLine());
            }

            Console.WriteLine("\n\n\nPress any key to exit");
            Console.ReadLine();
        }
    }
}