Passing data from DAL to BAL to UI (Typed dataset)

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


        Return userData


    End Function
LVL 7
CamilliaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
riyazthadConnect With a Mentor Commented:
Yes you can assign your stored procedure return value to typed dataset if you have already created that.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.