Hi friends,
i have a problem i didnt solve 3days,
i get data from oracle database with down codes. but when i changed checkbox selection then datagridvew add column right .
not in order pf query
What I have tried:
ma = "SYS19.MUHTM001_PKG.GETAD(MUHKOD)"
If ayb.Checked = True Then kosul = "TO_CHAR(TARIH,'MM'),SYS19.MUHTM001_PKG.GETAD(MUHKOD)"
If fb.Checked = True Then kosul = " TARIH,SYS19.MUHTM001_PKG.GETAD(MUHKOD),FISNO "
If gunb.Checked = True Then kosul = " TARIH,SYS19.MUHTM001_PKG.GETAD(MUHKOD)" : gunkosul = " AND TO_CHAR(TARIH,'MM') =" & AY.Text & " "
sorgu = " SELECT " & kosul & ", " & borç & "," & alacak & " ," & Borçbakiye & "," & alacakbakiye & "" & _
" FROM SYS19.MUHTD002 WHERE BIRIM NOT IN ('999','998') " & gunkosul & " " & _
" AND TARIH BETWEEN '" & ilktar.Text & "' AND '" & sontar.Text & "' " & _
" AND MUHKOD LIKE '" & muhkod.Text & "%' GROUP BY " & kosul & " ORDER BY " & kosul & " "
myConn.Open()