ASP.NET Oracle Query

Question

What code would put the results of the query (or any query) into an HTML table?

ReadOnly QUERY As String = "SELECT * FROM DUAL"

Public Sub page_load()
    Dim myConn As New OracleConnection( _
        ConfigurationManager.ConnectionStrings("DB").ConnectionString)
    myConn.Open()

    Dim myCommand As New OracleCommand(QUERY, myConn)
    Dim myReader As OracleDataReader
    myReader = myCommand.ExecuteReader()

    'Insert Code Here'

    myConn.Close()
End Sub

There's nothing in DUAL, SELECT * won't return any columns — OMG Ponies
– OMG Ponies, Commented Dec 29, 2009 at 19:17
@OMG Ponies: That's absolutely not true. DUAL has one column (DUMMY) and one row. — DCookie
– DCookie, Commented Dec 29, 2009 at 19:23

Sonny Boy · Accepted Answer · 2009-12-30 16:39:44Z

2

First... add a table to your markup using <asp:Table id="myTable" runat="server"></asp:Table>

Then in your code, try this:

While myReader.Read
  Dim myRow as HTMLTableRow = New HTMLTableRow

  For i as Integer = 0 to myReader.FieldCount- 1
    Dim myCell as HTMLTableCell = New HTMLTableCell

    myCell.InnterText = myReader.GetString(i)

    myRow.Cells.Add(myCell)
  Next i

  myTable.Rows.Add(myRow)
End While

edited Dec 30, 2009 at 16:39

answered Dec 29, 2009 at 19:25

Sonny Boy

8,03620 gold badges80 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sonny Boy Over a year ago

As a side note, you may be better off using an IDataReader instead of your OracleDataReader object unless specific functionality is needed. This will help to make your code more generic and portable.

Oded · Accepted Answer · 2009-12-29 19:20:53Z

1

Loop over the reader using the boolean Read method:

while (myReader.Read())
{
    'Write out to html, or populate server side controls.
    'use myReader.GetXxx(index) methods here to get to the data
}

answered Dec 29, 2009 at 19:20

Oded

501k102 gold badges900 silver badges1k bronze badges

Collectives™ on Stack Overflow

ASP.NET Oracle Query

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related