Oracle SP question

[Guest]

I have a SP I'm calling to talk to the Oracle Back end, I want to split up the data (columns) be returned and display them in labels and not on a grid. How can i do that?

here is the call to the sp:

cn.Parameters.Add("carCursor", OracleDbType.RefCursor, DBNull.Value, ParameterDirection.Output)

this returns,, make, model, year, engine_type

I want to display only the Make and Year in a label form.

 

[Thomas Dodds]

what container are you using to store the data once it is returned ... you
can bind an asp:label to a data source

I have a SP I'm calling to talk to the Oracle Back end, I want to split up

the data (columns) be returned and display them in labels and not on a grid.
How can i do that?

 

[Thomas Dodds]

you can create a datarow based on a specific row in the dataset (findbykey)
and bind the label to a concatenation of the row's data elements ...

Dim ds As New DataSet("ds")
Dim key As String = "somevalue"
Dim dr As DataRow = ds.Tables(0).Rows.Find(key)
Dim lbl As Label

lbl.Text = dr(0).ToString() & " " & dr(1).ToString()

What do you mean by "container"?
I'm using a dataset to store my data, if thats what you mean.
I can display everything in the grid, but i want only 2 things to display

in a label form, not a grid formup the data (columns) be returned and display them in labels and not on a
grid. How can i do that?