ASP.NET/VB.NET problem solving help!
- by Jonesy
Hi folks,
Got a problem I need help with. Basically I'm gonna develop a form (part of a bigger web app) that lists a load of clients and there business contact, tech contact 1, and tech contact 2.
The idea is rapid data entry. So one form shows each client with their contacts in dropdowns and I we can change each one then click a save button to do a mass save.
the database looks like this:
tblClient
ClientID
ClientName
BusinessContact
Tech1
Tech2
My idea was to use a repeater to format the data like this:
Client
Business Contact
Tech1
Tech2
Client2
Business Contact
Tech1
Tech2
What I'm stuck on is how to do the mass update? Can I do something like for each item in Repeater1 then do an update SQL statement? -- Jonesy