Solved

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

Posted on 2006-11-09
1
975 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

752 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