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