Best method???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone please tell me the best way to create a database update form with
a large number of fields...

The form only needs to use standard textboxes for some pretty basic info...

I thought about just manually adding the textboxes to the form and then
using a loop to create the SQL procedure to update the database, but was
wondering if there is a better way of doing it... perhaps using a Stored
Procedure but then I guess I have to manually add all the variables in the
Stored Procedure which doesn't make alot of sense...

Any suggestions would be appritiated...

Thanks
 
I would resort to stored procedures.
But if I understand correctly, this is too much work for you.

Might want to use the commandbuilder to build the statements for you?

Need more info :)

Marcel van Eijkel
(www.vaneijkel.com)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make a page to update information, show saved data from database. 1
Array Question??? 5
TextBox control not accepting Information typed in.. 3
For Each Loop - Variable names must be unique 6
Call stored procedure in SSMS from Access 2016 doesn't work. 0
What is the correct way to do this? 3
SQL Connection on the fly??? 2
FormView ObjectDataSource FormParameter can't find textbox if inside asp:table 2

Back
Top