Click here to Skip to main content
Rate this: bad
good
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 at 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
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