Change SelectCommand Runtime with Typed DataSet

I have a DataTable setup and want to be able to change the columns at
runtime so I limit the number of rows returned.

I know you can have have multiple queries within a DataTable but they return
empty columns which I don't want (or is there a way to stop empty rows being
returned?). I guess this is due to the fact the queries under the main query
inherit the data structure from the DataTable, is that correct?

Is there any way this can be done?

TIA

William
Fri Aug 25 10:56:34 CDT 2006

Not with the TableAdapter. This is easy with untyped DataTables, but not
with the code-generated TableAdapter.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"TigerMan" <nospam@antispam.com> wrote in message
news:eryc$2CyGHA.4984@TK2MSFTNGP05.phx.gbl...
>I have a DataTable setup and want to be able to change the columns at
>runtime so I limit the number of rows returned.
>
> I know you can have have multiple queries within a DataTable but they
> return empty columns which I don't want (or is there a way to stop empty
> rows being returned?). I guess this is due to the fact the queries under
> the main query inherit the data structure from the DataTable, is that
> correct?
>
> Is there any way this can be done?
>
> TIA
>
>

TigerMan
Fri Aug 25 16:08:40 CDT 2006

Hi Bill,

I suspected that was the case, thanks for your help

"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:e7AbL8FyGHA.4204@TK2MSFTNGP04.phx.gbl...
> Not with the TableAdapter. This is easy with untyped DataTables, but not
> with the code-generated TableAdapter.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
>
> "TigerMan" <nospam@antispam.com> wrote in message
> news:eryc$2CyGHA.4984@TK2MSFTNGP05.phx.gbl...
>>I have a DataTable setup and want to be able to change the columns at
>>runtime so I limit the number of rows returned.
>>
>> I know you can have have multiple queries within a DataTable but they
>> return empty columns which I don't want (or is there a way to stop empty
>> rows being returned?). I guess this is due to the fact the queries under
>> the main query inherit the data structure from the DataTable, is that
>> correct?
>>
>> Is there any way this can be done?
>>
>> TIA
>>
>>
>
>