>>>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? (I wouldn't use a dataset when there is Linq but still I don't think it is very hard).
Cetin