I have a website where users upload a CSV file which is displayed in a dataview. It is address information that I will eventually import to my sql table. I need to make sure each field is mapped correctly to my sql table. Every CSV file will be in a different layout with different field names.
I want to enable a way for the user to map their field names to my sql table field names by using a dropdown so the import will be successful.
How can I programatically add dropdown boxes to the first row of each column in the dataview so they can select which sql field name is the same as their CSV field name.