[RESOLVED] Write to a .txt file & some other things....

[callydata]

I am looking for the simplest way to write to a .txt file, that has a seperate header area, subhead area, and single entries. The data needs to pull from tables in a SQL database and from pre defined values.
Can anyone help?
Thanks.

[Neoharuo]

Can you give us an example of what you are looking for? (Formatting)

[callydata]

Here is a sample of what I am going after:

101 07500005113918269450458081136A094101MARTIN & KINGSLY BANK ABS SERVICES INC
5200ABS SERVICES INC 1391830098PPDLOAN PYMT 050808050808 1075000050000001
62729147959214000202 0000049243NMB00001 SCHMIDT, SARA A. RA0075000050000001
820000113100920707970000599142600000599142601391826998 075000050000001
9000001000114000011310092070797000200914260000059914260
9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999
9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999
9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999
9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999
9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999

[jain_mj]

Please expain what this sample means. which is head, subhead etc

[Zakary]

I am looking for the simplest way to write to a .txt file, that has a seperate header area, subhead area, and single entries. The data needs to pull from tables in a SQL database and from pre defined values.
Can anyone help?
Thanks.

Well a good way to do so is by usage for IO.StreamWriter.

Peudo code:

Open File using IOStreamWriter

WriteFileHeader()

Do Loop for all record
      ' Write This product header
      Do Loop Until The Same product
          ' Write Product Detail from the current record
      Loop
      ' Write This product footer
Loop
WriteFileFooter()

Close IO.StreamWriter

Hope it help!

PS
I use Product just as exemple I can't be anything else

[callydata]

Header:
101 07500005113918269450458081136A094101MARTIN & KINGSLY BANK ABS SERVICES INC

SubHead:
5200ABS SERVICES INC 1391830098PPDLOAN PYMT 050808050808 1075000050000001

Entry:
62729147959214000202 0000049243NMB00001 SCHMIDT, SARA A. RA0075000050000001

Footer:
9000001000114000011310092070797000200914260000059914260
9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999
9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999
9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999
9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999
9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999

So some of this content will be constant, and other parts of the content will be pulled from a table.
Any ideas are appreciated!

[gigemboy]

Simple....

Dim oFile As System.IO.File
Dim oWrite As System.IO.StreamWriter
 
'creates text file
oWrite = oFile.CreateText(...pathtofile... ex. "c:\mydata.txt"...)
 
'writes data by line
oWrite.WriteLine(...header...)
oWrite.WriteLine(...sub header...)      
oWrite.WriteLine(...data...)
 
'flushes data to file and closes it      
oWrite.Close()

[callydata]

NOt so fast gigemboy....

oWrite.WriteLine(...sub header...)

some of the info should be pulled from a table, what kind of statement would that be?

thanks!!

[gigemboy]

That was the code to write the info to the text file once you got it over from the data tables... 'tis all.. should've written it on there.. but I thought it was evident

Pulling data from SQL tables is going to require data access contstructs, sql queries, etc... not a particulary "easy" task.. better to find a link to read up on it.. I don't have any off hand, and haven't "delved" into the matter at all... maybe someone else can post a good link...

[mar_zim]

Yeah if you know some in ADO.NET then you could fetch the data in sql put in a datatable then loop to your datatable for writing to the txt file.