Hey everybody! Just wanted to say that I love .NetTiers. It is awesome beyond words. Thank you soo much for all your hard work.
I was given the requirement to read in a set of data in a text file with the format:
Header: Date: mm/dd/yyyy
16-19 digit credit card,9 digit ssn number
16-19 digit credit card,9 digit ssn number
etc...
Date: 09/29/2006
XXXXXXXXXXX68318 ,XXXXXX697
XXXXXXXXXXX62793 ,XXXXXX431
XXXXXXXXXXX48566 ,XXXXXX832
XXXXXXXXXXX46252 ,XXXXXX531
XXXXXXXXXXX69259 ,XXXXXX783
XXXXXXXXXXX41667 ,XXXXXX362
It was easiest for me to create a Cards table in SQL Server with the credit card number as the primary key and the SSN as a field in that table. I then used .NetTiers to generate the code for me. This is great but the data is going to reside in a text file and not
in a SQL Server. So, I was wanting to get some advice from the .NetTiers community about changing the provider from SQL to a TextFileDataProvider or something similar so I can read in all the values. I don't need all the CRUD functions. Just Read and Find by Credit Card Number.
Thanks!