Library tutorials & articles

Filtering and Sorting in ADO.NET

By Martin Zahn, published on 21 Jun 2005
Page 1 of 4
  1. Overview
  2. Filtering and Sorting with the DataTable Select Me
  3. Filtering and Sorting with the DataView Object
  4. Filtering and Sorting with the DataView Manager

Overview

ADO.NET supports many ways to manage memory-resident data returned in a DataSet. In this article you will see that ADO.NET exposes addidional functionality to the ways you can sort and filter data.

Because of the very nature of the disconnected DataSet architecture used in ADO.NET, it's often impractical or impossible to requery a remote data source to reorder or further filter data. Of course, this assumes that you are not implementing a traditional client/server application, which can execute further server-side sorting and filtering.

ADO.NET supports two fundamental approaches for performing these operations:

  • The DataTable Select Method - This method is overloaded to accept arguments to filter and sort data rows returning an array of DataRow objects.
  • The DataView object sort, filter and find methods - This object uses the same filter arguments supported by the Select method, but the DataView extrudes structures that can be bound to data-aware controls.

Comments

  1. Sumit Rastogi
    23 Dec 2008 at 07:34
    Friends please try out for this one........ Dim dv As New DataView(dsEdit.Tables(0)) dv.Sort = ("FieldName") dsEdit.Tables.Clear() dsEdit.Tables.Add(dv.ToTable) Sumit Rastogi
  2. naweinri
    23 Apr 2007 at 20:13
    I have been looking for a recordset.requery equivalent in ADO.NET forever and have neither found the method or a workaround.  I use this all the time in my current app and cannot do without.  Any suggestions.

  3. Paingthu
    30 Sep 2006 at 21:51

    hi .:)

    I'm a new comer .. dun know much about C#, ado.net but I 'm on assignment like a project :(

    I want to put sql statement like "select distinct column from table" in dataview.rowfilter .  how can I do that ?

    I want a distinct column value in my cbobox how could I support to do that ?

    can you guide me a way ? exam is around the corner and me havnt finish the assignment yet.  pls.....

     

    parden me for my bad english !

  4. prapoorna valluru
    09 Dec 2005 at 09:55

    how can we get the circle shape of image in  asp.net using c#.net?

  5. Developer Fusion Bot
    01 Jan 1999 at 00:00

    This thread is for discussions of Filtering and Sorting in ADO.NET.

Leave a comment

Sign in or Join us (it's free).

Related tags

c#, .net, ado.net, sql, dataview, datatable
Martin Zahn
AddThis

Related articles

Ask a question

Related discussion

Related podcasts

  • A Practical Look at Silverlight 2 Part 1

    Now that Silverlight 2 is at the Olympics and making a big splash, we wanted to explore this fascinating technology more. Microsoft Silverlight 2 is a cross-browser, cross-platform, and cross-device plug-in for delivering the next generation of .NET based media experiences and rich interactive ap...

Events coming up

  • Jul 22

    IT Job Seekers Greater Boston (Java, .NET, SQL, LAMP, etc.) July Meetup

    Boston, United States

    6:00pm to 6:30pm: Refreshments and networking6:30pm to 7:00pm: Individual introductions to the group7:00pm to 7:30pm: Job Hunting Tips- interviewing tips- what is hot, what is not- job hunting resources, places to look7:30 - 8:00pm: More networking!If you are a hiring manager, recruiter, or entrepreneur you are welcome to bring with you handouts about your company and opened positions.

Languages

Web Development

Frameworks & Architecture

Other major sections

Cancel
We'd love to hear what you think! Submit ideas or give us feedback