[VB2010] Add data to listbox and textboxes from ORA Table.
775312May 26 2010 — edited Jun 7 2010Hi, I.ve problem to get data from Oracle table in VisualBasic wer 2010.
My Form has one listbox, using source from that simple qwery: +"SELECT DOC_NO FROM OSSH_LISTY_PRZEWOZOWE WHERE (ILOSC IS NULL) AND (WAGA_KG IS NULL)"+
I want to fill listbox.DataSource with "DOC_NO".
in VB6 that was easy with recordset. In VB2010 does't that kond of object.
I was bild Dataset using ODBC connection and stoped. ;(
after that i must fill in textboxes form and run oracle procedure with those datas
Pleace step by step how to do that or link to FAQ with complete exp.
edit:_____________
ok I'm connected (http://support.microsoft.com/kb/310985), but standing have not draw date do listbox
If myCommand.Connection.State <> 1 Then myCommand.Connection.Open()
Dim dt As New DataTable("ossh_listy_przewozowe")
myCommand.Fill(dt) 'error !!
lista_zamowien.DataSource = dt
lista_zamowien.DisplayMember = "DOC_NO"
edit2:____________
Answer is on http://articles.techrepublic.com.com/5100-10878_11-5793285.html
now i cant find solution for run data in ORA procedure
Edited by: user13156550 on 2010-05-26 08:16