Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dataset in Datalayer

Status
Not open for further replies.

fcoomermd

Programmer
Nov 20, 2002
218
CA
I have an application which has a:
Presentation Layer (includes some business logic)
Data Layer (includes some business logic)

Within the Data layer, I populate a dataset via a bunch of Stored Proc calls. Within the presentation layer, I call methods within the Data Layer which returns the dataset.
For example:
Presentation -
dim ds as new dataset
ds = datalayer.getDataset(customerNumber)

Data Layer -
getDataset(customerNumber as integer) as dataset
....

Is there any extra overhead for returning dataset (sometimes large) within multiple method calls?

I was thinking of having the dataset to be global either:
Within the datalayer and just call the reference to it, for example:
dim ds as dataset
ds = datalayer.dataSet

or return an instance of the dataset at the topmost level of the presentation layer, then make it global from there...

Thoughts? I want to seperate my data more from my presentation layer... I find it hard to do the seperation because a datase is so tightly bound, not to mention I am using binding...

Thanks for any help
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top