Bonnie,

Oddly enough, I just came across a need for something like this, although there may be another way to handle it. Once I have my first dataset, I would like to get the number of distinct values for a specific column in that dataset. Would I use something like these temporary tables or is there some way to query a dataset directly. I don't think I can use a RowFilter to get the number of distinct values. Thanks.


>Hi Gerard,
>
>You can use the .ToTable() method of the DataView. So, something like this:
>
>

>MyTable.DefaultView.RowFilter = "MyColumn = MyValue";
>DataTable MyTempTable = MyTable.DefaultView.ToTable();
>
>// or //
>
>DataView dv = new DataView(MyTable);
>dv.RowFilter = "MyColumn = MyValue";
>DataTable MyTempTable = dv.ToTable();
>

>
>This might not be totally what you want though, since you mentioned complicated selects, but this was my first thought off the top of my head.
>
>~~Bonnie
>
>
>>Hi.
>>Is there a way in .net (C#) to select to a temporary Cursor and then use this as the source
>> of another select e.g.
>>
>>Select * ,.....from Tablea Into Table Temp1
>>Select * from Temp1 into Table Temp2
>>Select * from Temp2 into table Temp3...etc
>>
>>The above selects are just examples
>>Each select is more complicated , with numerous fields and some
>> of the selects are done for grouping purposes.
>>
>>Any help appreciated.
>>regards,
>>Gerard