Re: 1 to many in GridView

Sorry... quick addition. Instead of going with an inner join, I could
use a DataSet with the two related tables. The question is how to
display them properly.


MRW wrote:
Hello!

I don't know if this is possible, but I have two tables in a
one-to-many relationship. I want one record to be displayed in a
GridView from table1 with a blue background, followed by all the
related records in table 2 in a white background, followed by the next
record in table1 in a blue background (for example). It should be nice
an simple. Back in the ASP Classic days, I would use response.write
and build a table, but I was wondering if there is an easier way to do
this in .NET. Oh yes, I'm using VB.

Thanks for any help!

.

Relevant Pages

  • Re: Cant Count Records in Form
    ... Query1 would show you table2 records also. ... I have a one to many relationship between Table1 and Table2. ... in Table1 sequentially and in a subform I display the records from Table2 ...
    (microsoft.public.access.forms)
  • Re: Better "Join" vs "Where" clause?
    ... if you don't display any field from the second table when you are ... an INNER JOIN might give you the apparence that ... it appears that a WHERE clause accomplishes the same data set ...
    (microsoft.public.access.queries)
  • Re: Blue Background / White Text Word 2007 Beta
    ... It shows how to display green text on a black background; ... Windows display appearance settings." ... time with white text on the blue background that we all came to know ...
    (microsoft.public.word.docmanagement)
  • Re: update a row in one table with values from muliple rows in another table
    ... This kind of thing sort of goes against the grain. ... you would have already recieved 20 replies saying ... if you are doing this for display ... create table table1 ...
    (microsoft.public.sqlserver.programming)
  • HELP PLEASE! Missing info on invoice
    ... they do display on the screen. ... the Notes field into the detail area rather than the page footer where I did ... FROM (Dealer RIGHT JOIN (Customers RIGHT JOIN ([Shipping Methods] RIGHT JOIN ... Orders.DealerID) RIGHT JOIN ((Contracts INNER JOIN Products ON ...
    (microsoft.public.access.reports)