>>>>How do you return a dataset, using Linq, of rows from another dataset?
>>>
>>>Here is a sample:
>>>

>>>    DataTable tbl = new DataTable();
>>>	using (OleDbConnection con = new OleDbConnection(
>>>	"Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;"+
>>>	@"Data Source=C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Samples\northwind.sdf;"))
>>>	{
>>>	  con.Open();
>>>	  OleDbCommand cmd = con.CreateCommand();
>>>	  cmd.CommandText = "select * from customers";
>>>	  OleDbDataReader rdr = cmd.ExecuteReader();
>>>	  tbl.Load(rdr);
>>>	  con.Close();
>>>	}
>>>	
>>>	DataTable usaCustomers =
>>>	 tbl.AsEnumerable()
>>>	    .Where(c => c.Field<string>("Country") == "USA")
>>>		.CopyToDataTable();
>>>	
>>>	DataTable ukCustomers =
>>>	 tbl.AsEnumerable()
>>>	    .Where(c => c.Field<string>("Country") == "UK")
>>>		.CopyToDataTable();
>>>	
>>>//	usaCustomers.Dump("USA");
>>>//	ukCustomers.Dump("UK");
>>>

Cetin
>>
>>Not so easy with a *DataSet* though :-}
>
>Sorry I don't understand what you mean Viv. What is hard in that sample?

Your example is great but it's one Table. Kevin wanted to do that with a DataSet. So how would you know how many tables, what the filter condition might be, what relationships might exist between the tables, etc.etc.

(I wouldn't use a dataset when there is Linq but still I don't think it is very hard).

I don't think you *could* realistically do this with a DataSet?