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
Solved

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

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

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…
Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

828 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