Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLServer Views and NoDataOnLoad
Message
From
23/10/2009 15:29:26
 
 
To
23/10/2009 15:12:38
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgia, United States
General information
Forum:
ASP.NET
Category:
Databases
Miscellaneous
Thread ID:
01430775
Message ID:
01431111
Views:
39
I'm not sure what you're trying to accomplish, but a dataset doesn't load until you tell it to, so you get NoDataOnLoad by default. A SQL Server View is not the same as a DataSet.

>I take it all back, I am using the sql server connection. I am using sqlserver views and XtraReports to generate reports in a vb.net project. (obviously I am more oriented to VFP than vb.net). The view is used as the basis for a dataset. The user can then enter or choose various parameters to operate against the dataset (view). I may be confused about how views work in sqlserver, but it appears to me that if the view creates a dataset then that dataset will be populated with all possible records. The report then applies a filter to the dataset and prints.
>
>What I would like is the equivalent to vfps nodataonload for the dataset. Is this possible or have I completely misunderstood how things work?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform