or Select top 10 * from agent where agentid not in (select top 10 agentid from agent)

You need to retrive 20 records and ignore top 10 to get next 10 records

Try it --- using System; using System.Collections; using System.Collections.Generic; public class SamplesArrayList { static char indi; public class Test : IComparable { public int x; public int y; //this is the variable which i want to sort the list with it also public char indi; public Test(int x, int y) { this.x = x; this.y = y; } int IComparable.CompareTo(object x) { if (indi == 'X') { Test x1 = (Test)x; return (this.x.CompareTo(x1.x)); } else { Test y1 = (Test)x; return (this.y.CompareTo(y1.y)); } } } public static void Main() { ArrayList test = new ArrayList(); Test l1 = new Test(7,8); Test l2 = new Test(3,2); Test l3 = new Test(9,1); Test l4 = new Test(2,0); Test l5 = new Test(4,5); indi = 'X'; test.Add(l1); test.Add(l2); test.Add(l3); test.Add(l4); test.Add(l5); test.Sort(); foreach (Test t in test) { Test x1 = t; Console.WriteLine(x1.x+ " "+ x1.y); } Console.ReadKey(); } }

OleDbConnection dbConnection; dbConnection = new OleDbConnection(); dbConnection.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0; " + "Data Source = " + Application.StartupPath + "\\Data.mdb";

There may be some other fields in the table which do not allow null values or John, Do, FunctionOne, DescriptionOne --- if these are variable then may be values are null or empty string.

I need a C# sample project book, for datadriven application and winsock programming

Select top 10 * from