Writing a SQL query through VB.net to oracle

Hey, i need to connect to oracle when i press a button, and ask this SQL query:

SELECT oi.vare_nr, oi.ans_nr, COUNT(*)
FROM ordreinfo oi, vare v, ansatt a
WHERE v.vare_nr = oi.vare_nr
AND a.ans_nr = oi.ans_nr
GROUP BY oi.vare_nr, oi.ans_nr;

after this i need to get the information i receive from the SQL query to a listbox, how do i do this?


I was thinking something like this (its some variables there in norwegian, but you understand :))

I dont understand how i should implement this SQL query to my code, and i dont know if this is the correct way to go :)
Dim forbindelse As New System.Data.OracleClient.OracleConnection
 
        forbindelse.ConnectionString = "user id=****;password=****;data source=oracle.*******"
        forbindelse.Open()
 
        Dim setning As String = "sql query?????"
 
 
        Dim kommando As New System.Data.OracleClient.OracleCommand(setning, forbindelse)
 
 
        Dim dataleser As OracleClient.OracleDataReader
        dataleser = kommando.ExecuteReader()

Open in new window

LVL 3
leeds2000Asked:
Who is Participating?
 
Solar_FlareCommented:
yes you are on the right track

once that code has finished you will want to set the datasource of the listbox = dataleser
Dim forbindelse As New System.Data.OracleClient.OracleConnection
 
        forbindelse.ConnectionString = "user id=****;password=****;data source=oracle.*******"
        forbindelse.Open()
 
        Dim setning As String = "SELECT ...."
 
 
        Dim kommando As New System.Data.OracleClient.OracleCommand(setning, forbindelse)
 
 
        Dim dataleser As OracleClient.OracleDataReader
        dataleser = kommando.ExecuteReader()
 
 listbox1.Datasource = dataleser ''bind the results of the query to the listbox, make sure you have the display and value members of the listbox set to the correct column names in the query
 dataleser.Close()
 

Open in new window

0
 
leeds2000Author Commented:
Okei, i will try this tomorrow, thanks for the help so far :)
0
 
leeds2000Author Commented:
Im struggling with getting the information from this SQL query to show in the listbox or a datagridview, how do i do this?
please help
0
 
Solar_FlareCommented:
you need to make sure the datatextfield and datavaluefield are set to the appropriate field names from the query so it knows which fields to use for the text and value
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.