hi
I have a huge form to build on an asp.net page with multiple fields that come from and also connect to (postback=true) 10 different tables{database is access for now } .which controls would be helpful please suggest.
Also how about usign infopath to build forms and hosting it on iis is it feasible..please advice.
Thanks in advance
Environment: Visual studio 2005 ,iis webserver,ms access,
Thanks to all the PROS who are helping other developers..
![]() |
0 |
![]() |
Hi,
For ASP.NET 2.0 Hosting purpose I am currently using GoDaddy.com. And satisfied with the service.
Regards
Kuldeep Deokule
MCSD.NET
Blog: http://dkuldeep.blogspot.com
This posting is provided "AS IS" with no warranties, and confers no rights.
![]() |
0 |
![]() |
mranonimus:
hi
I have a huge form to build on an asp.net page with multiple fields that come from and also connect to (postback=true) 10 different tables{database is access for now } .which controls would be helpful please suggest.
Requirement is not so clear. Advise you to give more clarity for better response.
MCSD.NET
Blog: http://dkuldeep.blogspot.com
This posting is provided "AS IS" with no warranties, and confers no rights.
![]() |
0 |
![]() |
The real question is how should you access the data.
Since you are using Access, you could create a query that pulls all the various data fields (from the 10 tables) together into one query. That way you can write one SQL statement to access the correct record in the query. Also, I believe when you update the query, Access will update each of the 10 tables for you. For the user interface, when you have all the data fields in 1 query, using DetailsView in VS 2005 will create all the form fields for you. This can save lots of time. Once you have the DetailsView form auto-populated, you can fine tune the presentation of the form on the APS.Net page.
The FormView provides more flexibility in how the form is displayed to the user. It takes more time to setup than the DetailsView, but for complicated forms, getting the form to make sense to the user is critical. I don't know the details about your form, so you will have to deside: Ease of coding with DetailsView, or Best user interface with FormView. FormView uses Templates exclusively. DetailsView uses Templates when you want and auto-populates everything else.
The right way to do it is to have a Business Logic Layer to provide the data to your form and also take any updates and save them back to the 10 tables individually. This is the better way to handle updating multiple tables because you can handle errors better and have more visibility to what went wrong.
What I mean about things going wrong is this: What if your update (to 10 tables) has a conflict in table #7. Using Access and the 1 query will return an error of some kind (not really sure what), and you are not sure which table had the problem. But if you are updating each table individually in the Business Logic Layer, then you will see that tables #1 through #6 updated ok, but #7 had a problem. That can help you in a big way when something goes wrong in production (and it will at some point).
Just my 2 cents. HTH
Cheers,
Chris
Remember, you can mark more than 1 post as the answer.
![]() |
0 |
![]() |
hi sorry if i was not clear..
Iam trying to build a webapp which uses forms and update it in a Ms Access database, i was looking for a quicker way with new tools/technologies to help me out..any suggestions?
Thanks
Thanks to all the PROS who are helping other developers..
![]() |
0 |
![]() |
hi sorry if i was not clear..
Iam trying to build a webapp which uses forms and update it in a Ms Access database, i was looking for a quicker way with new tools/technologies to help me out..any suggestions?
Thanks
Thanks to all the PROS who are helping other developers..
![]() |
0 |
![]() |
Thanks a lot Chris..Very clear answer to a novice like me..
Thanks to all the PROS who are helping other developers..
![]() |
0 |
![]() |
I'm glad you found my post helpful, and thank you for the kind words.
Cheers,
Chris
Remember, you can mark more than 1 post as the answer.
![]() |
0 |
![]() |