Click here to Skip to main content
12,248,742 members (48,119 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C#
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 26-Jan-13 0:55am
Comments
OriginalGriff 26-Jan-13 6:09am
   
And? What have you tried? Where are you stuck?
What help do you need?
Rate this: bad
 
good
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.
  Permalink  

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.160426.1 | Last Updated 26 Jan 2013
Copyright © CodeProject, 1999-2016
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