CodeSmith Community
Your Code. Your Way. Faster!

How to edit data from 2 tables linked together on 1 page

Latest post 09-21-2008 8:32 PM by mike123. 2 replies.
  • 09-19-2008 1:37 AM

    • zoz
    • Not Ranked
    • Joined on 09-18-2008
    • Posts 4
    • Points 80

    How to edit data from 2 tables linked together on 1 page

    Hi,

    I am using netTiers, and have successfully created aspx pages allowing to edit data of ONE database table each.

    BUT, how to edit information coming from 2 different tables linked together with a foreign key on ONE aspx page ?

    Here is the description of the problem:
    I have 2 tables: 'application' and 'recommendant'. They are linked together with a foreign key ('recommendant' has a column which corresponds to a line on 'application')
    I know how to create a aspx page to edit the table 'recommendant' and a aspx page to edit the table 'application'.
    BUT how do you create ONE aspx page allowing to edit the data from the table 'application' as well as editing the matching data in the table 'recommendant' ?

    I have made lots of attemps, here is what I got:
    - If I put all in one page, the databinding system is not working anymore (but the validation of required inputs works)
    - if I use a different usercontrol to put the table 'recommendant', the databinding works but the validation of the required inputs works

    please, help.

    • Post Points: 65
  • 09-19-2008 2:33 PM In reply to

    • SuperJeffe
    • Top 25 Contributor
    • Joined on 05-05-2006
    • Tulsa, Ok
    • Posts 432
    • Points 10,850

    Re: How to edit data from 2 tables linked together on 1 page

    I will tell you it is difficult to get support for the UI portions of Nettiers.  The people that wrote them don't respond to posts much anymore.

    I don't use the UI components of nettiers so I really can't answer your question related to the Nettiers UI components.  What I can tell you is code the UI yourself if the built in controls don't work.  I code all the UI's myself and bind directly to the Tlist.  It is very hard to generate a generic UI that everyone likes.

    jeff

    ----------------------------------------------------------------------
     Member of the .NetTiers team | Visit http://www.nettiers.com
    ----------------------------------------------------------------------

    • Post Points: 5
  • 09-21-2008 8:32 PM In reply to

    • mike123
    • Top 10 Contributor
    • Joined on 02-25-2005
    • Toronto, Ontario
    • Posts 735
    • Points 17,045

    Re: How to edit data from 2 tables linked together on 1 page

    Reply |Contact |Answer

    zoz,

     

    There are some examples in the documentation section of the forums .. here is one http://community.codesmithtools.com/forums/t/3033.aspx

     

     

    Mike Shatny
    --------------------------------------------------------------
    Member of the .netTiers team http://www.nettiers.com
    --------------------------------------------------------------

    • Post Points: 5
Page 1 of 1 (3 items) | RSS
Copyright © 2008 CodeSmith Tools, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems