Import of txt file into textbox

Question

0.00/5 (No votes)

See more:

Hi all.

I have a text file that I import into my program. My code works fine with a normal text file but the problem is I get text files from a client that for some reason doesn't import properly(It only imports the first line).

If I open the text file in notepad and "save as" a text file and then try to import it again it works fine.

I can't always open the file and save it again as this slows down production and the text file is on average 100mb. So it takes a long time for me to open in notepad and save again.

Is there another way of importing the file?
Here is the code I use:

Dim FILE_NAME As String = TextBox1.Text
Dim objReader As New System.IO.StreamReader(FILE_NAME)
TextBox2.Text = TextBox2.Text & objReader.ReadToEnd

Posted 12-Aug-10 1:37am

wikus70

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2010-08-12T01:57:00

Are you seriously saying that you are loading 100MB into a text box?
WHY?
Who the heck do you expect to read that? Even an reasonable size .NET manual in PDF format, with pictures, is about a tenth the size. A 100MB text file is approximately 3 million lines of text.
How long is the poor sod being given to read it? A week? A year?

Find a better way: page it for him, provide search facilities, anything but "open a huge file and stuff the user"!

E.F. Nijboer · Answer 2 · 2010-08-12T02:05:00

Try reading it one line at a time inside a loop. like in the example shown here:
http://msdn.microsoft.com/en-us/library/db5x7c0d.aspx[^]

Do not concatenate something like:

s = s & sLine

but use a StringBuilder like:

objStringBuilder.Append(sLine)

Also, if you already know the file size you can use EnsureCapacity to reserve the memory needed.

Good luck!

wikus70 · Answer 3 · 2010-08-12T02:19:00

Solution 3

Sorry I should have mentioned that no one is going to read the file. We need info from the text file and the program splits up the data and just does a count and wrights a nice small report. The program reads the text file so a user doesn't have to :cool:

The report is just going to say product A = 375 and product B = 645 and so on.

Thanx E.F. Nijboer. I'll have a look at the string builder ;)

Posted 12-Aug-10 2:19am

wikus70

Comments

OriginalGriff 12-Aug-10 8:30am

Phew! That's a relief!
Have a look at File.ReadAllLines (http://msdn.microsoft.com/en-us/library/system.io.file.readalllines.aspx) which returns an array of strings - but do concatenate with StringBuilder as E.F. suggests.

wikus70 · Answer 4 · 2010-08-12T03:42:00

Solution 4

Thanx everyone I got it working :-D

I had to use a StringBuilder like E.F. Nijboer suggested and then run the data split on the StringBuilder and write the report to a textbox

Posted 12-Aug-10 3:42am

wikus70

Import of txt file into textbox

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0