472,968 Members | 1,803 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,968 software developers and data experts.

working with multiple datasets

I currently have a vb.net application that reads ado datasets that are from
views withing sql 2000. To "cheat" for the moment I have a view that only
gets records within a certain time frame and then another view that SUMS
those records. My application creates a dataset from the second view.

However, now the time stamps used in the first view need to be dynamic. I
need to be able to choose the start and end dates, and some how get that
first view to only return records in timeframe.

I was thinking of creating a temp table in sql, but do not know how to pass
the dates into a stored procedure. Should I select and then insert into a
table and then work with that table?

Any ides would be appreciated. Thanks!
Jun 21 '06 #1
0 827

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Dinesh | last post by:
Currently we use a data adapter and a dataset for fetching data from multiple data source. Once we populate the data from each data source we merge all datasets into a single dataset. Hence if...
3
by: Kaveri | last post by:
Currently we use a data adapter and a dataset for fetching data from multiple data source. Once we populate the data from each data source we merge all datasets into a single dataset. Hence if...
2
by: malcolm | last post by:
Hello, We have a robust (.NET 1.1 c# winforms) client-server application that utilizes many typed DataSets, typed DataTables and typed DataRows. Our application is a series of windows and popup...
3
by: lee_mcknight | last post by:
I am using Crystal Enterprise V9. I have a report that needs to have multiple datasets as the datasource(s) on a single subreport (some common lookup data I need to join to is stored in a seperate...
3
by: Yul | last post by:
Hi, We are in the process of designing an ASP.NET app, where a user will enter some 'Customer ID' to be queried in the database. If the ID is valid, several stored procedures will be called to...
2
by: Chumley Walrus | last post by:
If I have as many as 7 different datasets I want to use, is it possible to merge 7 different datasets with the Merge method for just one datagrid? thanx chumley
1
by: moondaddy | last post by:
I have a vb.net 1.1 winforms app and need to retrieve multiple datasets in a single pass from a web service. I know I can hve multiple tables in a dataset and these do, but in some cases I still...
3
by: TomH | last post by:
I am using VB within VS 2005. How can I have multiple datagridviews on the same form pulling from the same table? e.g. I want to see all clients from New York in one view and all clients from LA in...
0
by: robin9876 | last post by:
I have two data connections and two returned datasets which one set of results need to be used in the other connection. The first dataset will return a list of customer reference codes that are...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
3
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.