I would like to make a listbox only appear if there are results returned by the SQL select statement.
I want this to be assessed on a click event of a button before the listbox is rendered.
I obviously use the ".visible" property, but how do I assess the returned records is zero before it is rendered?
hi,
there must be datasource(dataset or reader) for that listbox i believe.
if its dataset then use dataset.tables[0].Rows.Count, if its reader then use reader.hasrows.
hope it helps.
regards,
satish.
|||Thanks Satish,
I used an if statement to assess if rows > 0
Cheers,
Ben.
|||cheers Ben
satish.
sql