asked on 5/16/2011

How to Draw drop down list while excuting ?

I'm trying to load fields from excel file and assigns each field to my database field ?
How can I generate each to field of excel a drop down list containing my database fields to let the user choose which field in his excel is what in my database ?
So it is kind of creating dynamic drop down list
I'm using vb.net/asp.net

.NET Programming ASP.NET Visual Basic.NET

Last Comment

Nasir Razzaq

5/16/2011

prajapati84

5/16/2011

In the application page, you can read the excel file and make a bind it to a grid/repeater etc.
Then get the list of fields from database table and bind it to a dropdownlist against each of excel field.
Here you need to generate the dropdownlist dynamically by code with unique id in ItemRowDataBound event.

And at the end, you can place a button which will save the combination selected in the grid.

Let me know if you have any difficulty.

ankouny

5/16/2011

ASKER

How can that be done by code ? do you have an example.
I prefer to have it coded in the vb.net page not as a javascript ?

ASKER CERTIFIED SOLUTION

Nasir Razzaq

5/16/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial