Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: C#
Dear Sir,
Read .dat file record as follows;
Emp_No- 000001
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 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,
Posted 26-Jan-13 0:55am
OriginalGriff at 26-Jan-13 6:09am
And? What have you tried? Where are you stuck?
What help do you need?
Rate this: bad
Please Sign up or sign in to vote.

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.

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 575
1 Kornfeld Eliyahu Peter 409
2 Maciej Los 369
3 DamithSL 196
4 OriginalGriff 188
0 OriginalGriff 6,353
1 DamithSL 4,854
2 Maciej Los 4,466
3 Kornfeld Eliyahu Peter 4,058
4 Sergey Alexandrovich Kryukov 3,897

Advertise | Privacy | Mobile
Web03 | 2.8.141220.1 | Last Updated 26 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100