Solved

For Each objRow In Workspace.DataTable.DataSet - Order by

Posted on 2013-01-25
5
299 Views
Last Modified: 2013-01-30
In the following code how would I do this so it orders by SalesAmountDescr?


For Each objRow In Workspace.DataTable.DataSet
           
                    Text = objRow.SalesAmountDescr
   
        Next
0
Comment
Question by:vbnetcoder
5 Comments
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 38820736
You can sort using the DataView object of the datatable. Looks like you have some poor naming conventions in use. Is DataSet of type DataTable? You can use DataTable.DefaultView.Sort property


http://msdn.microsoft.com/en-GB/library/system.data.dataview.sort.aspx
0
 
LVL 7

Expert Comment

by:tipsybroom
ID: 38820764
you can sort your rowcollection with linq

// create a sorted collection
var result = Workspace.DataTable.DataSet.OrderBy(r => r.SalesAmountDescr);

foreach (var item in result) Console.WriteLine(r.SalesAmountDescr);

Open in new window

0
 

Author Comment

by:vbnetcoder
ID: 38827399
What is r in r.SalesAmountDescr?
0
 
LVL 28

Accepted Solution

by:
Ark earned 500 total points
ID: 38829863
r is lambda function. VB syntax is almost similar to C# in all cases except of LINQ :). So, VB:
Dim result = Workspace.DataTable.DataSet.OrderBy(Function(r) r.SalesAmountDescr)
0
 

Author Closing Comment

by:vbnetcoder
ID: 38835409
ty
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Technology Resume 7 67
ASP.NET on IIS website not sending PDF file anymore ? [IzillaFramework Cognition] 6 47
IDE for Python 5 65
How to force output to ascii 2 34
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

761 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question