Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > Indigo

Vista - avoid returning dataset

 
 
Old 01-23-2008   #1 (permalink)
Kevin


 
 

avoid returning dataset

hi all,

what's the alternative to return a dataset/datatable that is dymanically
populated from dymanic sql? remember the number of column is known only at
runtime.

thx


Kevin

My System SpecsSystem Spec
Old 01-24-2008   #2 (permalink)
Marc Gravell


 
 

Re: avoid returning dataset

As always, it depends on what you need ;-p

But for a simple answer - how about csv/tsv.... most clients will have
a mechanism of dealing with that? Or xml? Or if large, a Stream of the
same (note this is only really effective using transport security;
with message security it needs to buffer everything anyway;
better-still with MTOM etc). If your transport doesn't already include
it, you might [again for large data as a Stream] consider throwing a
GZipStream into the pipeline so you have a compressed MTOM stream of a
simple data format).

Marc


My System SpecsSystem Spec
 

Thread Tools


Similar Threads
Thread Forum
DataSet object VB Script
dataset does not clear .NET General
DataSet Designer .NET General
powershell and DataSet PowerShell


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46