You need to rethink your entire data retrieval system, especially using .NET. Users enter query criteria then you populate the dataset, not the other way around. Also, you shouldn't use OLEDB to SQL Server in .NET. You'll take a performance hit and you're using unmanaged code.
>When using views in VFP I have made great use of the NoDataOnLoad property. Is there an equivalent to this setting in VB.Net when using SQL Server Views? I realize this might be the wrong place to post this function so please don't fuss at me.
>
>Thanks for any help...
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer