Filtering DataSet

by

You can use DataTable.Select: 

var strExpr = "CostumerID = 1 AND OrderCount > 2";
var strSort = "OrderCount DESC";

// Use the Select method to find all rows matching the filter.
foundRows = ds.Table[0].Select(strExpr, strSort);

Or you can use DataView: 

ds.Tables[0].DefaultView.RowFilter = strExpr;

UPDATE I’m not sure why you want to have a DataSet returned. But I’d go with the following solution: 

var dv = ds.Tables[0].DefaultView;
dv.RowFilter = strExpr;
var newDS = new DataSet();
var newDT = dv.ToTable();
newDS.Tables.Add(newDT);

More Related Contents:

  1. How I can filter a Datatable?
  2. How do I import from Excel to a DataSet using Microsoft.Office.Interop.Excel?
  3. Direct method from SQL command text to DataSet
  4. How to fill Dataset with multiple tables?
  5. Datatable vs Dataset
  6. Stored procedure return into DataSet in C# .Net
  7. Why is a SQL float different from a C# float
  8. How to bind crystal report to manually created DataSet
  9. Convert Dataset to XML
  10. How do I transform a List into a DataSet?
  11. DataTable to List
  12. How and when to use ‘async’ and ‘await’
  13. Why is it important to override GetHashCode when Equals method is overridden?
  14. Why do I get “‘property cannot be assigned” when sending an SMTP email?
  15. How to handle AccessViolationException
  16. Finding holes in 2d point sets?
  17. Globally catch exceptions in a WPF application?
  18. How do I use Moq to mock an extension method?
  19. What is the purpose of the vshost.exe file?
  20. How to get a path to the desktop for current user in C#?
  21. Need to perform Wildcard (*,?, etc) search on a string using Regex
  22. How to effectively draw on desktop in C#?
  23. Identifying NHibernate proxy classes
  24. Is it possible to mock out a .NET HttpWebResponse?
  25. Returning iTextSharp PDF as memorystream causes StreamNotSupported
  26. Task.Factory.StartNew with async lambda and Task.WaitAll
  27. C# Field Naming Guidelines?
  28. Document.Ready() is not working after PostBack
  29. Generic list of generic objects
  30. How do I Embed a font with my C# application? (using Visual Studio 2005)

Leave a Comment