recently, i realise theres such thing as Hashtable that are allow listbox to retrieve url when clicked. However, as i find out more, i realise most examples i saw are static. As in
dim mycountries=New Hashtable mycountries.Add("N","Norway") mycountries.Add("S","Sweden") mycountries.Add("F","France") mycountries.Add("I","Italy")
is there any way to retrieve this list from database instead of coding it like that?
i tried doing so, but it gave me a "Public member 'DataSource' on type 'Hashtable' not found." error.
cmdSelect = New OdbcCommand( "SELECT IMG_TITLE, IMG_LINK FROM worklist", conODBC) DApt.selectCommand = cmdSelect DApt.Fill(dsSet, "worklist") Dim linkrd = new Hashtable linkrd.DataSource = dsSet.Tables("worklist") linkrd.DataBind() linklist.DataSource = linkrd linklist.DataTextField="img_title" linklist.DataValueField="img_link" linklist.DataBind()
can anyone guide me on this?
thanks a lot