Change SelectCommand Runtime with Typed DataSet

  • Thread starter Thread starter TigerMan
  • Start date Start date
T

TigerMan

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
 
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.
__________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Typed DataSet Relationships 2
Oracle integer is set to Decimal in the DataTable 1
ADO.NET TableAdapter "The connection is closed" error 0
Typed Dataset: Add expression-based column? 5
strongly typed dataset update with identity column 6
How to fill a listview from LINQ query 8
DataSet help -- .Merge() & .GetChanges() 8
?fill dataTable created at design time with dataAdpter at runtime 9

Back
Top