reading data from notepad and storing in ms-access

Question

0.00/5 (No votes)

See more:

I am a student and I am going to create a window application with ms access that will read data from a notepad file and and store it in the database.

Notepad file will be in specific foramt as:

name|age

If my reader finds 'name' and there after a '|' then next data should go to age section.
I am expecting some tips or kind of coding help so that I can make my application.

Regards,
[EMAIL DELETED]

[edit]Never post your email address in any forum, unless you really like spam! If anyone replies to you, you will receive an email to let you know. - OriginalGriff[/edit]

Posted 16-Jan-11 20:51pm

arshad alam

Updated 16-Jan-11 21:42pm

Dalek Dave

v3

Add a Solution

Comments

Dalek Dave 17-Jan-11 3:43am

Edited for Grammar and Readability.

1 solution

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 · 2011-01-16T21:00:00

Solution 1

The easiest way is to read the file in using the ReadAllLines method:

string[] lines = File.ReadAllLines(path);

You can then process each line individually:

foreach (string line in lines)

And process each line into two sections:

string[] sections = line.Split('|');

Check you have two sections (or there is an input problem), and then use them:

string name = sections[0];
string age = sections[1];

All you have to do then is save them to your database.

Note: You have nearly all the code you need there: I have left you some work in deciding how to "bolt it all together". Since it is your homework, it is only fair you do some of the work! :laugh:

Posted 16-Jan-11 21:00pm

OriginalGriff

Comments

Dalek Dave 17-Jan-11 3:43am

Good Call, Griff.

arshad alam 19-Jan-11 4:08am

hi Dave,

i am very thankful to you,its working fine, i am adding a datatable so that i can insert all the rows of section array. i am dealing with huge data. it has 44 column and its txt file size is 20 MBs. first time when i fill the datatable in the datagridview , its fine . i have a cancel button. on click . i am clearing the datatable. when i do same the proccess in after clicking the cancel button, it is taking more time to display than previous time. what can be possiblities to handle this.

OriginalGriff 19-Jan-11 5:18am

I think your reply contains the reasons quite well:
"44 column"
"20Mb"
"datagridview"

Now think about the user. How many rows?
If every entry in every column has ten characters, that is 47,000 rows.

Do you want to sit there and look at 47,000 rows of similar looking data, trying to find the row you want?
Don't load it all into a datatable, or a datagridview, or anything else.
Read it from your text file, and write it to your database using SQL or LINQ.
Then only display data a page at a time. Give him search facilities.

Why does it slow down? Probably because it calls in the garbage collector to get rid of all the old stuff to make room for the new...

arshad alam 19-Jan-11 6:38am

how can i impliment LINQ to Display or save data .. will you kindly demonstrate it ??