Probleme avec distinct

Et en mettant un alias sur vos colonnes ?
Cela reviendrait à faire cela :

Code:

1
2
3
4
5
6
7
8
9
10
 
SQLSTR = "Select  T1.N AS col from march T1 UNION   select T1.N1 AS col from march T1 UNION select  T1.N2 AS col from march T1 "
 
CMD1 = New SqlCommand(SqlStr, con1)
DR1=Cmd1.executeReader
IF DR1.HasRows Then
   While DR1.READ
    Me.DropDownList4.Items.ADD(DR1("col"))
   End While
End IF