Solved

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

Posted on 2006-11-09
1
960 Views
Last Modified: 2010-10-05
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
0
Comment
Question by:Camillia
1 Comment
 
LVL 6

Accepted Solution

by:
riyazthad earned 500 total points
ID: 17909712
Yes you can assign your stored procedure return value to typed dataset if you have already created that.

0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now