If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Create A Fixed Text File From SQL DB Table

Hello programmers. I am trying to retreive data from an SQL db table using VB in a .NET aspx page (visual studio 2005), confirm that there are records (i.e. record count, etc.) then print the data into a fixed text file somewhere on my network. I did this in Visual Basic 6 using selects, padstrings, freefile, recordcount properties, etc. hitting an Access db table. However I am not able to repeat this in .aspx page. Below is the script I used to output the text file from the MSAccess table. Thanks for the support.

Below is my new working vb.net script which creates a text file if there is data in the table. However it is only putting out manual text. I need to loop through the table assign the fields (I guess) to variables and then somehow get the variable values into something similar to the writeline in a fixed format. I am getting the count of the records, but I'm kind of lost from there. Any help is appreciated.