I have a question about loading a listbox from a dataset.

[Gordon]

Hi;

I am trying to port a windows app which works to a web
app.

I select a date from a calender control then use that date
to select a corresponding record in a datset. When I
execute the same code section where I select a record from
a datatable I get an error message that says that the
column I want to match is not found. Here is the code
which is in a subroutine that is called from the calender
date_selected event. The dataset is created in another
subroutine. Why doesn't Asp.Net recognize the .Select
statement but windows does ?

Dim nRow As DataRow()
Dim irow As DataRow
nRow = tblCaseDocs.Select("doc_dte_due = '" &
holdDte.ToString & "'")

ListBox1.Items.Clear()

For Each irow In nRow
ListBox1.Items.Add(irow("case_id") & " " &
irow("Document_Nme"))
Next

Thanks,

Gordon

 

[Alvin Bruney]

Listbox are different beasts in the web environment so you have to do things
a bit differently. You're going the long way around the park here. Fire your
select and return the values in a dataset like this:
DataSet ds = query blah blah blah
Then bind your dataset to the list box like so

listbox.datasource = ds;
listbox.datatextformat = "case_id" //this is the column you want to display
in the listbox
listbox.databind();
roughly

regards