show relationship between tables in Asp.net using c#

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • muskan
    New Member
    • Nov 2006
    • 35

    show relationship between tables in Asp.net using c#

    hello,

    Can I show relationship between tables in the datagrid control.

    I have written a below code for establish relation b/w tables.

    dset.Relations. Add("Customer requests",
    dset.Tables["Customers"].Columns["icustid"],
    dset.Tables["requests"].Columns["icustid"]);
  • radcaesar
    Recognized Expert Contributor
    • Sep 2006
    • 759

    #2
    Originally posted by muskan
    hello,

    Can I show relationship between tables in the datagrid control.

    I have written a below code for establish relation b/w tables.

    dset.Relations. Add("Customer requests",
    dset.Tables["Customers"].Columns["icustid"],
    dset.Tables["requests"].Columns["icustid"]);


    When u bind this dset to grid, it will shows u as a drill down records in the datagrid.

    I Was unable to decide whether it will work with this single line of code. Please post with the detailed code snippet and ur problem in brief.

    :)

    Comment

    • Rathorevivek
      New Member
      • Dec 2006
      • 17

      #3
      Hi Muskan,

      Would u please tell in detail that what is ur requirement?
      It is not getting clear that wat are ur intentions means wat do u actually want to do?

      Thanks and Regards,
      VIVEK RATHORE.

      Comment

      • muskan
        New Member
        • Nov 2006
        • 35

        #4
        thanks for reply..

        actually I have showed the relationship b/w the 2 tables
        I want to know that it is possible to show the result of the relationship into the datagrid control.


        Originally posted by Rathorevivek
        Hi Muskan,

        Would u please tell in detail that what is ur requirement?
        It is not getting clear that wat are ur intentions means wat do u actually want to do?

        Thanks and Regards,
        VIVEK RATHORE.

        Comment

        Working...