How to show a relation between two persons in a datagridview

siesta Published at Dev

Siesta

I want to show a relation between two persons in a datagridview (C# Windowsforms).

So, I made a (MS Access) table with persons. Each person has an unique number as its PK. Thereafter I made a Relation table. In this table I have a column for person 1 (FK), a column for the relation and a column for person 2 (FK).

This looks like this:

ERD

Now I tried to show this in a datagridview with columns that show Fname, Lname, DOB, Relation, Fname, Lname, DOB. I tried a lot, but I can't let it work.

I hope someone can let me know how the (SQL) select query should look like or what I should do to make this work.

Thanks a lot!

Lee Mac

You will need to use two references of your Person table in your query, since, for each record in your Relation table, two separate records are to be displayed from your Person table.

Therefore, you'll need to use a query along the lines of:

select
    p1.fname, 
    p1.lname, 
    p1.dob, 
    r.relation,
    p2.fname, 
    p2.lname, 
    p2.dob
from
    (relation r inner join person p1 on r.pnumber1 = p1.pnumber) 
    inner join 
    person p2 on r.pnumber2 = p2.pnumber

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-05-10

Comments

0 comments

TOP Ranking

Article

How to show a relation between two persons in a datagridview

How to show a relation between two persons in a datagridview

pump.io port in URL

Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

How to import an asset in swift using Bundle.main.path() in a react-native native module

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

Using Response.Redirect with Friendly URLS in ASP.NET

Can a 32-bit antivirus program protect you from 64-bit threats

Double spacing in rmarkdown pdf

How to fix "pickle_module.load(f, **pickle_load_args) _pickle.UnpicklingError: invalid load key, '<'" using YOLOv3?

3D Touch Peek Swipe Like Mail

Bootstrap 5 Static Modal Still Closes when I Click Outside

Assembly definition can't resolve namespaces from external packages

Vector input in shiny R and then use it

Emulator wrong screen resolution in Android Studio 1.3

Svchost high CPU from Microsoft.BingWeather app errors

Graphics Context misaligned on first paint

Python connect to firebird docker database

Is this docker-for-mac password dialog legit?

How to save models trained locally in Amazon SageMaker?