Solved

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

Posted on 2006-11-09
1
966 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

770 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