how can I display alarge number of records , about 2 million records, in a data grid?

how should I select my data? and how should I paging my dataset or datatable?

Thanx; 

I highly suggest you look into these two articles for data that large.

http://aspnet.4guysfromrolla.com/articles/031506-1.aspx

http://www.4guysfromrolla.com/webtech/042606-1.shtml

Hello :

I think you should read articels about clustering and indexing

its useful to you case

Good Luck