How to read dat file

Question

0.00/5 (No votes)

See more:

Dear Sir,

Read .dat file record as follows;

000001201301011000I
000001201301011900O
000002201301011900I
000002201301011900O

Emp_No- 000001
Year-2013
Month-01
Date-01
time-10000
In/Out-I

Note Intime means I
Outtime Means O

Oracle Design Structure as follows;

Emp_No Year Month Date time In/Out

In run mode screen as follows;
Browse Button and submit button.

when i click the Browse Button read the .dat file from the system and i have one button called submit.when i click the submit button that read the .dat file and save it into the oracle data base.

Design in Asp.net and back end Oracle11g

Oracle Data base output as follows;

Emp_No Year Month Date time In/Out (from read .dat file)

000001 2013 01 01 10000 I

Thanks and regards,
Magesh.

Posted 25-Jan-13 23:55pm

Member 7665038

Add a Solution

Comments

OriginalGriff 26-Jan-13 6:09am

And? What have you tried? Where are you stuck?
What help do you need?

2 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)

Richard MacCutchan · Answer 1 · 2013-01-26T00:10:00

Solution 1

Use a StreamReader[^] to read each line of the file into a string object, and then use the various string methods to split it into the separate fields of your database record.

Posted 26-Jan-13 0:10am

Richard MacCutchan

Thomas Daniels · Answer 2 · 2013-01-26T03:26:00

Hi,

Have a look here:
http://msdn.microsoft.com/en-us/library/vstudio/ezwyzy7b.aspx[^]
http://msdn.microsoft.com/en-us/library/db5x7c0d.aspx[^]
http://www.csharp-station.com/HowTo/ReadWriteTextFile.aspx[^]
http://www.csharp-examples.net/filestream-read-file/[^]
http://csharp.net-tutorials.com/file-handling/reading-and-writing/[^]