looking for a special kind of table control

Hi

I'm wondering what you'd suggest on how to implement the following scenario:

A table based date entry/editing having 5 columns. One is an SQL bound
dropdown, another one a simple text item dropdown, the third one a numerical
entry box with a limited number range, the 4th is a read only textfield
whose content is recalculated according to changes made in the first and
third column and each time the first or third column is being changed
(performing an additional query on the SQL Datasource and then making a
quick calculation), and finally a free form text entry field (just plain
text, no formatting).

I need to have the functionality to delete an existing line, as well as
adding one, and an option to fill the table with some default values (by
default that's three entries with the same item selected in the first
dropdown, a different one in the second dropdown and an entry in the
numerical entry textbox). In the end, all entries need to end up in an SQL
DB (just a single table).

I'm currently considering two approaches. One based on basically writing the
table out programmatically. Clearly not a pretty solution. The other would
be starting out with a GridView, but I see a lot of work coming may way as
well. If you suggest that option, are there any useful samples out there to
give me a head start (preferably for ASP.NET 2.0).

Regards
Stephan


.

Relevant Pages

  • Re: Using Database Results Wizard for dropdown
    ... Present SQL for the form (showing just the dropdown portion for GroupMix; ... > Is there a parameter you can add to the sql of the Database Results Wizard ...
    (microsoft.public.frontpage.programming)
  • Followup Question
    ... Present SQL for the form (showing just the dropdown portion for GroupMix; there is a similar select for MeetingLocation further down in my page): ... > I'm using the Database Results Wizard to populate a dropdown list in a form. ...
    (microsoft.public.frontpage.programming)
  • RE: Looking for suggestions on populating dropdown from database table
    ... I can't figure out how to get the collection into the dropdown. ... > Public Function getKeyValueList(ByVal sql As String) As Collection ... readerCmd.Connection = readerConn ...
    (microsoft.public.dotnet.framework)
  • RE: Need some help with simple search query
    ... > dropdown with Resident's names and a dynamic dropdown with Appointment ... > search criteria, then it doesn't return any results. ... Here is my new query, ... > sql = blah,blah ...
    (microsoft.public.sqlserver.programming)
  • Re: Can one do a find/replace within a drop-down on a form?
    ... but you can do it with a macro. ... If the old entry is the selected entry in the completed form, ... information relating to your dropdown field ... Dim strFile As String ...
    (microsoft.public.word.docmanagement)