Skip to content

.Net Filter and/or Sort Existing Datatable

February 10, 2012
   Shared Function GetPartList(ByVal PartType As String) As DataTable
      Using dt As DataTable = PartList() 
         GetPartList = dt.Clone
         For Each dr As DataRow In dt.Select(String.Format("PartType = '{0}'", PartType), PartType)
            GetPartList.ImportRow(dr)
         Next
      End Using
   End Function
    

OR

   Users.DefaultView.Sort = "Username"
   GetUsers = Users.DefaultView.ToTable
Advertisements

From → .Net, CodeProject

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: