Why datagridview shows column from each SQL server table in on its own row

Question

1.00/5 (1 vote)

See more:

I get a datagridview with datatables on its own rows with this query

C#

SELECT 
    E.*,
    TA.Numero_Transfert,
    Ta.Code_Transfert,
    TA.Numero_Agent,
    TA.Montant_Transfert,
    D.* 
FROM 
    Expéditeur E 
FULL JOIN 
    Transfert_Argent TA ON (E.Cin_Expéditeur = TA.CIN_Expéditeur) 
FULL JOIN 
    Agent A ON (A.Numero_Agent = TA.Numero_Agent)
FULL JOIN 
    Destinataire D ON (D.Cin_Destinataire = TA.Cin_Destinataire);

What I have tried:

i tried to change the JOIN with(Inner Join) Or (Left Join)..... without any results

Posted 7-Nov-21 9:02am

Oussama Frija

Updated 7-Nov-21 10:19am

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2021-11-07T10:19:00

Because that is what a FULL JOIN does - it shows all the rows from all the tables involved: SQL - FULL JOINS[^]

I don't know what data you have, or what results you expect - so I can't tell you what to write to get them. But ... a FULL JOIN is probably not what you want. Start here: SQL JOINS diagram[^] and thing about your inputs and outputs. Then work out exactly what you want to achieve along with the diagrams and double check here before moving to code: SQL Joins[^]

Why datagridview shows column from each SQL server table in on its own row

1 solution

Solution 1

Add your solution here

Preview 0

Why datagridview shows column from each SQL server table in on its own row

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us