I am trying to do something similar in asp.net using c# which I did in macro with vba code.
On my aspx page I have a Textbox and a button. I am trying to display the results in a grid like the format in attched excel file.
I have an excel file which will fetch data from multiple text files from different locations.
I want to fetch a data from parent file and its reference data from other child data files(reference data files).
I have no idea that the reference will be in which of the reference files. What I want is to find the reference
data in by searching data in all the files and display the data in desired format as in attached sample excel sheet.
Ta. for your suggestions