Two dropdownlist and two tables...

Discussion in 'ASP .Net Web Controls' started by Paolo, Sep 19, 2006.

  1. Paolo

    Paolo Guest

    Hi all!
    I have a database that has 3 tables:

    User, roles and roleUser.
    The last one has only two fields, idUser and idRole, they are the
    primary key of the table.
    When inserting a new row in this table, I want to show two dropdown
    lists, one with all the users and one with all the roles in the other
    two tables. The problem is I can't figure out how to do this. I tried
    with a dataadpter that croos-joins the two table, but this way for
    example if I have 3 users and 2 roles I have each role 3 times and each
    user 2 times...
    Any idea?

    Thank you

    Paolo
     
    Paolo, Sep 19, 2006
    #1
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Peter Bassett
    Replies:
    3
    Views:
    958
    Augustus
    Aug 15, 2003
  2. Otuatail

    Tables within tables

    Otuatail, Jul 31, 2004, in forum: HTML
    Replies:
    7
    Views:
    520
  3. Chris Brat
    Replies:
    5
    Views:
    711
    =?iso-8859-1?q?Luis_M._Gonz=E1lez?=
    Aug 22, 2006
  4. Ping-Hsun Hsieh
    Replies:
    1
    Views:
    450
    Jon Clements
    Nov 19, 2009
  5. barney

    binding tables with relationes to 2 dropdownlist

    barney, Mar 4, 2005, in forum: ASP .Net Web Controls
    Replies:
    3
    Views:
    166
    barney
    Mar 5, 2005
Loading...

Share This Page