Console Appl- Data file and Database update

[TopNotchBuddy]

Console application to read .dat file
data in .dat file pipe limited.

Input file layout is delimited by '|':
fileA
fileB
fileC
fileD
fileE
fileF
fileG
fileH
fileI
fileJ
fileK

Output Table Layout is:
• TYPE_1 (VARCHAR2(20))
• ENTITY_2 (VARCHAR2(100))
• ENTITY_3 (VARCHAR2(100))
• ENTITY_4 (VARCHAR2(4000))
• ACTIVE_5 (VARCHAR2(2))
• DISPLAY_ORDER_6 (NUMBER(4,0))
• LST_UPD_DT (DATE)
• LST_UPD_USERID (VARCHAR2(35))
TYPE_1 - TEST always
ENTITY_2 and ENTITY_3 is fileA
ENTITY_4 is
{"fileA":"XY,"fileB"":"XY COMPANY"}

ACTIVE_5 - Y
DISPLAY_ORDER_6 is 0
LST_UPD_DT is sysdate
LST_UPD_USERID is TEST


C# console application has to read .dat file in above laayout and update a table in oracle as table layout.
first row in .dat file is
XY| XY COMPANY | Y| N| | | | | | | N

Can you please code for it ...thanks ..

[Ubiquitous]

I'm sure people will tell you this is a help forum not a code request forum. So post what you have tried and people here will help you and guide you in the right direction.

Also use
[code]
//Put code between tags
[/code]

[TopNotchBuddy]

Thank you.

I did the code. environment is visual studio 2005 and C#.

public class EntityData
  {
       public string workgrp {get;set;}
                
       public string wrkgrpds {get;set;}

       public string returnJSON()
       {
           return "{\"workgrp\":\"" + workgrp + ",\"wrkgrpds\":\"" + wrkgrpds + "\"}";
        }
  }

Am getting build error on using get, set in above.
Error 4 'FileUpdate.Program.EntityData.wrkgrpds.set' must declare a body because it is not marked abstract or extern C:\Documents and Settings\Aricent\My Documents\Visual Studio 2005\Projects\FileUpdate\FileUpdate\Program.cs 123 41 FileUpdate
Error 3 'FileUpdate.Program.EntityData.wrkgrpds.get' must declare a body because it is not marked abstract or extern C:\Documents and Settings\Aricent\My Documents\Visual Studio 2005\Projects\FileUpdate\FileUpdate\Program.cs 123 37 FileUpdate
Error 2 'FileUpdate.Program.EntityData.workgrp.set' must declare a body because it is not marked abstract or extern C:\Documents and Settings\Aricent\My Documents\Visual Studio 2005\Projects\FileUpdate\FileUpdate\Program.cs 121 40 FileUpdate
Error 1 'FileUpdate.Program.EntityData.workgrp.get' must declare a body because it is not marked abstract or extern C:\Documents and Settings\Aricent\My Documents\Visual Studio 2005\Projects\FileUpdate\FileUpdate\Program.cs 121 36 FileUpdate

[DataMiser]

Use [code][/code] tags when posting code please.