help! need advice on best way to do database driven add/edit/search type web forms...

Thanks to the lovely folks on this form, and way too much time.. I have now filled up my SQL tables from my old access tables, i have created a form that hooks into the database and pulls fields out to populate drop down boxes and have little red * that show up if a field isn't filled in...
my method:
create new form ->pull over listbox - connect to datasource to fill up listbox w/ topics... repeat several times -> pull over input text boxes -->drag over Submit button-->drag over 'RequiredFieldValidator' and set it to the list boxes....
problems:
1. (in VisWebDeveloper) input boxes do not show up in "control to Validate" (they are not hooked into db)
2. (up on the web) after required fields are filled in, submit does nothing --- i dont know how to specify "after validation"
3.i have 4 listboxes that are all being populated by the same table -- Topics ... each one has it's own SqlDataSource picking out rows with specific topic categories... should i be creating one master query and just separating to topic categories in some other property field?
i got a bit **** up because i didn't specify code separate than the file so i'm trying to sort out the difference... don't know if that matters...?
Any input on the above would be Fantastic!!
Otherwise - what I really need is some direction!
There seems to be so so many options on how to do stuff... I can't figure out if I'm doing combinations of 2 different "styles" of programming... Like should I be doing data grid->validate->insert OR
What do you all recommend for the below things I need to do? (3 word answers are ok)
Entry Form -->after all required fields are filled in -submit creates inset Query --data going into 3 separate tables. email is sent that entry was posted.
Edit Form -->edit above info (in 3 tables) but only limited fields can be changed

dzr 3/20/2006 8:28:19 PM

Reply:

(Thread closed)