bryan 0

bryan 0

  • NA
  • 9
  • 0

multiple related tables on a datagrid

May 21 2005 11:22 PM
Problem: The below will display: home_name, person_id, person_name, person_age, person_job field records with no problem. However when i re-create da1 to input tb3 & tb4 and select the company_name field to show on the datagrid as well, it doesnt display any records. The relationships are created in the MS access already and when i used data adapter query builder, the relationships are there as well, am i missing any steps? - Private Sub frmResults_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'da1 is a data adapter that has 2 tables: tb1 & tb2 'i used vs.net to drag the oledbdataadapter to select fields using sql query builder 'the datagrid will show eg: home_name, person_id, person_name, person_age, person_job da1.Fill(ds) dataview = ds.Tables("tb1").DefaultView 'dg is datagrid with dataview as DataSource dg.Datasource = dataview Table: Fields ------------ tb1: home_id, home_name, home_type tb2: person_id, person_name, person_age, person_job tb3: company_id, person_id tb4: company_id, company name - any advise will be appreciated!