troubleshooting Question

imported excel file to dataview then programatically add row and columns from SQL Table field names

Avatar of logoncom
logoncom asked on
ASP.NETVisual Basic.NET
10 Comments1 Solution459 ViewsLast Modified:
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.  

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 10 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros