Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

[VB2010] Add data to listbox and textboxes from ORA Table.

775312May 26 2010 — edited Jun 7 2010
Hi, 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 5 2010
Added on May 26 2010
4 comments
2,327 views