Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Return DataSet From DataSet
Message
From
16/07/2010 06:45:17
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
ASP.NET
Category:
LINQ
Miscellaneous
Thread ID:
01472665
Message ID:
01472682
Views:
65
>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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform