Click here to Skip to main content
12,826,171 members (28,002 online)
Rate this:
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 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
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170326.1 | Last Updated 26 Jan 2013
Copyright © CodeProject, 1999-2017
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