FP 2003 Forms update from database

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

Guest

How can I create a form in FP2003 that will show existing values in a
database table and allow changes additions to the those fields?

I have a members profile table (with personal data) which I want the members
to update. I have a data entry form which they used to enter the data the
first time. I now want them to update it without having to type all the data
again. just any new stuff. For this they need to see what is in the table.
Any ideas?

Thanks?
EdH
 
To get this level of function, you have to write your own program code in
ASP.NET or ASP.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*-----------------------------­-----------------------
|\----------------------------­-----------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||----------------------------­-----------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/----------------------------­-----------------------
*-----------------------------­-----------------------
 
Thanks for response. A couple of questions:

1. Can I have on the same page a form to input data and also show database
results? (am thinking that I in the same page with the dbase input form, I
could show the current contents of the dbase)

2. is there anywhere I can find a tutorial or a ready made template that has
a fillable form already filled with current data?

3. can you tell me of a good book, or website or course where I can learn
ASP coding?

Thanks a lot,
EdH
 
Responses interspersed.

EdH said:
Thanks for response. A couple of questions:

1. Can I have on the same page a form to input data and also show database
results? (am thinking that I in the same page with the dbase input form, I
could show the current contents of the dbase)
Click to expand...

Yes, but connecting the two would be very awkward.
2. is there anywhere I can find a tutorial or a ready made template that has
a fillable form already filled with current data?
Click to expand...

Oh, probably. You could try googling for it. However, in most cases, you'll
want to customize the edit criteria, the list of fields various users can
update, and so forth. That's why I always roll my own.
3. can you tell me of a good book, or website or course where I can learn
ASP coding?

Thanks a lot,
EdH
Click to expand...

For obvious reasons, I'm kind of partial to these:

Web Database Development Step by Step
Web Database Development Step by Step .NET Edition

You might also want to take a look at Visual Web Developer Express, which is
in beta. I think this plus ASP.NET 2.0 is going to change a lot of people's
minds about ASP.NET. For example, you can do database editing such as you
describe, plus database creation, database design, DHTML menus, breakcrumbs,
Master Pages (which are like DWT's assembled on the fly), site registration,
protected folders, site personalization, and other goodies all without
leaving the GUI.

http://lab.msdn.microsoft.com/express/vwd/default.aspx

For a hosting company that supports this beta, browse:

http://msdn.microsoft.com/asp.net/beta2/hosters/

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*-----------------------------­-----------------------
|\----------------------------­-----------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||----------------------------­-----------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/----------------------------­-----------------------
*-----------------------------­-----------------------
 
Back
Top