Not sure how to do this:
UI: I want to display a list of cities in a *** dropdownbox *** based on username. I pass username to BLL
BLL: I get the username in a function. I have "array list" as the return value of the function. I call "getValues" in DAL
DAL: I have a stored proc that returns the name of the cities. Reurn value of this function is "array list" as well...
Question: How can I use Typed Dataset? (getvalues.xsd)..should I bind the result of the stored proc to a dataset instead of an array list?
Shared Function User(ByVal Identity As String) As ArrayList
Dim userData As New ArrayList
'use caching here
' userData = GetUser(Identity) 'calls DAL here