VS2005 Formview ADO.Net
In SQL Server I have 2 tables 1 lookup for country codes (UK,USA,F,I,D...)
and an address table with a constraint to only allow values that are in the lookup.
In my Web-interface I want to present the user with addresses for amendment, so the country code should initially be the current value but the valid choice should be in a dropdown. Other data of the address record should be textboxes.
The trouble I have is the following. I first tried to build up my user interface by using the standard control for textboxes which seem not to be data-bindable, hence not usable for my purpose. And there seems to be no data-bindable textbox in the Toolbox. Then I resorted to use the FormView - data control which unfortunately doesn't seem to have automatic support for dropdown-lists/multiple datasources/table-layout and the support for iterating through records is frankly a pain, because the (text-only!!) navigation hyperlinks are floating around...
My question is: Is there any way to
- add dropdown support to the formview or alternatively is there any textbox web control with data binding?
- is there a way to change the appearance of the navigation buttons of Formview to be "Buttons" at a fixed location
- Is there a way to add a datasource to a particular element inside the formview
- can the layout of the formview be modified to align labels say to the left and input boxes/dropdowns on the right?
- or do I have to write my own custom web-control
Any help/tip is much appreciated!
Thanks,
Dieter

