Rank Dataset Contents

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Wayne Wengert" <wayneSKIPSPAM@xxxxxxxxxxx>
Date: Mon, 22 May 2006 17:34:08 -0600

I have a VS2005/VB Windows application in which I want to rank the contents
of a "total" field in a dataset but I can't seem to figure out how to do
this. I've created an SQL DataAdapter and an SQL Dataset and I filled the
dataset with the values needed. The dataset has "n" rows and the columns
include "total" (a decimal value) and "rank" (an integer initially set to
zero). I want to place the ranking value (e.g. 1 through n) for each value
of "total" in the corresponding "rank" column and then write the updated
data back to the DB.
Any suggestions/pointers would be appreciated.

.

Follow-Ups:
- Re: Rank Dataset Contents
  - From: Cor Ligthert [MVP]

Prev by Date: Using Process.start to Open an XML file with Excel
Next by Date: Re: Access DB Issues - Again
Previous by thread: Using Process.start to Open an XML file with Excel
Next by thread: Re: Rank Dataset Contents
Index(es):
- Date
- Thread

Relevant Pages

Re: assigning points to rankings
... HTH. ... Windows XP, Office 2003 ... I want to display the points given in the next column. ... NAME TIME RANK PTS ...
(microsoft.public.excel.worksheet.functions)
Re: assigning points to rankings
... The Rank function would never be negative. ... If the op wanted to go this route, then perhaps just: ... Windows XP, Office 2003 ... I figured out the rank formula, but I can't figure out how to assign the ...
(microsoft.public.excel.worksheet.functions)
Re: BBC News says OS X probably no more secure than Windows
... Palm ... Windows ... i rank them in THAT order ... Right on the money. ...
(comp.sys.mac.advocacy)