Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

VS2005 Formview ADO.Net

this thread was previously posted under the .Net category where no-one seemed to be able to comment...I am fairly new to VS2005 (as probably most ;-), so I am just trying to get to grips with VS2005 and particularly ADO.Net. Here is what I want to do:

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
[1845 byte] By [drkybelk] at [2007-11-11 7:49:02]