Click to See Complete Forum and Search --> : can i requery a dataset ? (with no connection)


amirxy
May 18th, 2003, 12:22 PM
can i do that :

create dataset of 2 tables.
then,create new dataset that query the 2 tables from the first dataset ?

amirxy
May 18th, 2003, 01:20 PM
lets say i have dataset , with 2 tables ,and no open connection.

can i do some or all this things with it :

1.query the dataset tables , and create new table in it.
2.query the dataset tables and create new dataset from it
3.somthing else that close to this things...(query dataset with no
connection)

hellomadhu
May 21st, 2003, 04:36 AM
you cant query a dataset. All u can do is manipulate the records in the datatables.

chanti
May 21st, 2003, 05:58 AM
Hi,

Yes you can do all the things you have asked.

The DataTable has a method called select which takes the query and returns a DataRow() array of the rows that pass the query from the given datatable. So you can create a table with these rows and add this table to the dataset if you need.


Cheers.