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
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
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
| Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| DataSet object | k88elliott | VB Script | 0 | 07 Apr 2009 |
| dataset does not clear | douglas | .NET General | 4 | 05 Apr 2009 |
| DataSet Designer | johnb | .NET General | 1 | 14 Mar 2008 |
| powershell and DataSet | Neil Chambers | PowerShell | 1 | 19 Jul 2007 |
| WCF and typed dataset | Steve B. | Indigo | 0 | 06 Nov 2006 |