vb.net - .net - Sorting a Data Table -


how sort datatable using vb.net? i've read thread having same output. sorting data table how sort datatable

also, i've tried sample in microsoft still it's not sorting.

        dim locationtable new datatable("location")     ' add 2 columns     locationtable.columns.add("state")     locationtable.columns.add("zipcode")      ' add data      locationtable.rows.add("washington", "1")     locationtable.rows.add("california", "2")     locationtable.rows.add("hawaii", "3")     locationtable.rows.add("hawaii", "4")     locationtable.rows.add("hawaii", "5")     locationtable.rows.add("hawaii", "6")     locationtable.rows.add("hawaii", "7")     locationtable.rows.add("hawaii", "8")     locationtable.rows.add("hawaii", "9")     locationtable.rows.add("hawaii", "10")     locationtable.acceptchanges()      console.writeline("rows in original order" & vblf & " state " & vbtab & vbtab & " zipcode")     each row datarow in locationtable.rows         console.writeline(" {0} " & vbtab & " {1}", row("state"), row("zipcode"))     next      ' create dataview      dim view new dataview(locationtable)      ' sort state , zipcode column in descending order     view.sort = "zipcode asc"      console.writeline(vblf & "rows in sorted order" & vblf & " state " & vbtab & vbtab & " zipcode")     each row datarowview in view         console.writeline(" {0} " & vbtab & " {1}", row("state"), row("zipcode"))     next

the output rows in sorted order

state zipcode

washington 1

hawaii 10

california 2

hawaii 3

hawaii 4

hawaii 5

hawaii 6

hawaii 7

hawaii 8

hawaii 9

it should 1 ~ 10 right? :(

your zipcode column considered string, need specify coumn datatype int

try this

dim locationtable new datatable("location") ' add 2 columns locationtable.columns.add("state",type.gettype("system.string")) locationtable.columns.add("zipcode",type.gettype("system.int32")) ' add data  locationtable.rows.add("washington", 1) locationtable.rows.add("california", 2) locationtable.rows.add("hawaii", 3) locationtable.rows.add("hawaii", 4) locationtable.rows.add("hawaii", 5) locationtable.rows.add("hawaii", 6) locationtable.rows.add("hawaii", 7) locationtable.rows.add("hawaii", 8) locationtable.rows.add("hawaii", 9) locationtable.rows.add("hawaii", 10) locationtable.acceptchanges()  console.writeline("rows in original order" & vblf & " state " & vbtab & vbtab & " zipcode") each row datarow in locationtable.rows     console.writeline(" {0} " & vbtab & " {1}", row("state"), row("zipcode")) next  ' create dataview  dim view new dataview(locationtable)  ' sort state , zipcode column in descending order view.sort = "zipcode asc"  console.writeline(vblf & "rows in sorted order" & vblf & " state " & vbtab & vbtab & " zipcode") each row datarowview in view     console.writeline(" {0} " & vbtab & " {1}", row("state"), row("zipcode")) next

f use dataset...check 

if dataset isnot nothing amdalso dataset.tables(0).rows.count>0  // code here end if

Comments

Post a Comment

Popular posts from this blog

google app engine - 403 Forbidden POST - Flask WTForms -

i have flask application running on google app engine. trying submit form built using wtform , keep getting following error. 403 forbidden: don't have permission access requested resource. either read-protected or not readable server. location.html (part of code) <form method=post action="/home/location"> .... <button type="submit" class="btn btn-primary" value="submit"> directions </button> </form> main.py @app.route('/home/location', methods=['post', 'get']) def location(): form = cfcdirections.direction(request.form) print(request.method) if request.method == 'post' , form.validate(): print("after if") directions = cfcdirections() street_no = directions.no street = directions.street suburb = directions.suburb postcode = directions.postcode ...
Read more

Android layout hidden on keyboard show -

i have strange problem layout. when tap on edittext , keyboard shown edittext stay on bottom , when tap on to hide keyboard , keyboard hides , edittext go should when want input text. when tap again, keyboard shown , edittext goes down behind keyboard... <relativelayout android:layout_width="match_parent" android:layout_height="match_parent" > <scrollview android:layout_width="match_parent" android:layout_height="fill_parent" android:above="@+id/rl_commands"> <textview android:layout_width="match_parent" android:layout_height="wrap_content"/> </scrollview> <relativelayout android:layout_width="match_parent android:layout_height="24dp" android:id="@+id/rl_commands" android:alignparentbottom="true"> ...
Read more

Parse xml element into list in Python -

i've been trying days store list of coordinates list in python. i've tried minidom, xmlreader, , few others. i'm doing wrong, i'm on deadline , need help. <?xml version="1.0" encoding="utf-8"?> <kml xmlns="http://www.opengis.net/kml/2.2" xmlns:gx="http://www.google.com/kml/ext/2.2" xmlns:kml="http://www.opengis.net/kml/2.2" xmlns:atom="http://www.w3.org/2005/atom"> <document> <name>kmlfile</name> <style id="s_ylw-pushpin_hl"> <iconstyle> <scale>1.3</scale> <icon> <href>http://maps.google.com/mapfiles/kml/pushpin/ylw-pushpin.png</href> </icon> <hotspot x="20" y="2" xunits="pixels" yunits="pixels"/> </iconstyle> </style> <stylemap id="m_ylw-pushpin"> ...
Read more