Tips & Tricks
A simple way of filtering items in a collection in .Net version 2: // Our sample collection List<string> sampleList = new List<string>(); sampleList.Add("Chris"); sampleList.Add("Chris Adrian"); sampleList.Add("Chris Adrian S. Ongsuco"); sampleList.Add("Cicily"); sampleList.Add("Cicily Ongsuco"); sampleList.Add("Unknown"); Example 1: FindAll() // Filter collection using FindAll(). This will // return a collection of names. List<string> names = sampleList.FindAll( delegate(string...
Try this: use Northwindselect (select SUM(1) from Region where RegionID <= reg.RegionID) as 'Row Number', * from Region reg