强大的JS版分页

SQL

create table H
(
id int primary key identity(1,1) not null,
name nvarchar(50),
age int,
address nvarchar(50),
sex char(2),
phone nvarchar(20),
email nvarchar(50)
)
insert into H values('胡钧1',1,'北京1','男','13521786808','hu_hujun1@163.com')
insert into H values('胡钧2',2,'北京2','男','13521786808','hu_hujun2@163.com')
insert into H values('胡钧3',3,'北京3','男','13521786808','hu_hujun3@163.com')
insert into H values('胡钧4',4,'北京4','男','13521786808','hu_hujun4@163.com')
insert into H values('胡钧5',5,'北京5','男','13521786808','hu_hujun5@163.com')
insert into H values('胡钧6',6,'北京6','男','13521786808','hu_hujun6@163.com')
insert into H values('胡钧7',7,'北京7','男','13521786808','hu_hujun7@163.com')
insert into H values('胡钧8',8,'北京8','男','13521786808','hu_hujun8@163.com')
insert into H values('胡钧9',9,'北京9','男','13521786808','hu_hujun9@163.com')
insert into H values('胡钧10',10,'北京10','男','13521786808','hu_hujun10@163.com')
insert into H values('胡钧11',11,'北京11','男','13521786808','hu_hujun11@163.com')
insert into H values('胡钧12',12,'北京12','男','13521786808','hu_hujun12@163.com')
insert into H values('胡钧13',13,'北京13','男','13521786808','hu_hujun13@163.com')
insert into H values('胡钧14',14,'北京14','男','13521786808','hu_hujun14@163.com')
insert into H values('胡钧15',15,'北京15','男','13521786808','hu_hujun15@163.com')
insert into H values('胡钧16',16,'北京16','男','13521786808','hu_hujun16@163.com')
insert into H values('胡钧17',17,'北京17','男','13521786808','hu_hujun17@163.com')
insert into H values('胡钧18',18,'北京18','男','13521786808','hu_hujun18@163.com')
insert into H values('胡钧19',19,'北京19','男','13521786808','hu_hujun19@163.com')
insert into H values('胡钧20',20,'北京20','男','13521786808','hu_hujun20@163.com')
insert into H values('胡钧21',21,'北京21','男','13521786808','hu_hujun21@163.com')
insert into H values('胡钧22',22,'北京22','男','13521786808','hu_hujun22@163.com')
insert into H values('胡钧23',23,'北京23','男','13521786808','hu_hujun23@163.com')
insert into H values('胡钧24',24,'北京24','男','13521786808','hu_hujun24@163.com')
insert into H values('胡钧25',25,'北京25','男','13521786808','hu_hujun25@163.com')
insert into H values('胡钧26',26,'北京26','男','13521786808','hu_hujun26@163.com')
insert into H values('胡钧27',27,'北京27','男','13521786808','hu_hujun27@163.com')
insert into H values('胡钧28',28,'北京28','男','13521786808','hu_hujun28@163.com')
insert into H values('胡钧29',29,'北京29','男','13521786808','hu_hujun29@163.com')
insert into H values('胡钧30',30,'北京30','男','13521786808','hu_hujun30@163.com')
insert into H values('胡钧31',31,'北京31','男','13521786808','hu_hujun31@163.com')
insert into H values('胡钧32',32,'北京32','男','13521786808','hu_hujun32@163.com')
insert into H values('胡钧33',33,'北京33','男','13521786808','hu_hujun33@163.com')
insert into H values('胡钧34',34,'北京34','男','13521786808','hu_hujun34@163.com')
insert into H values('胡钧35',35,'北京35','男','13521786808','hu_hujun35@163.com')
insert into H values('胡钧36',36,'北京36','男','13521786808','hu_hujun36@163.com')
insert into H values('胡钧37',37,'北京37','男','13521786808','hu_hujun37@163.com')
insert into H values('胡钧38',38,'北京38','男','13521786808','hu_hujun38@163.com')
insert into H values('胡钧39',39,'北京39','男','13521786808','hu_hujun39@163.com')
insert into H values('胡钧40',40,'北京40','男','13521786808','hu_hujun40@163.com')
insert into H values('胡钧41',41,'北京41','男','13521786808','hu_hujun41@163.com')
insert into H values('胡钧42',42,'北京42','男','13521786808','hu_hujun42@163.com')
insert into H values('胡钧43',43,'北京43','男','13521786808','hu_hujun43@163.com')
insert into H values('胡钧44',44,'北京44','男','13521786808','hu_hujun44@163.com')
insert into H values('胡钧45',45,'北京45','男','13521786808','hu_hujun45@163.com')
insert into H values('胡钧46',46,'北京46','男','13521786808','hu_hujun46@163.com')
insert into H values('胡钧47',47,'北京47','男','13521786808','hu_hujun47@163.com')
insert into H values('胡钧48',48,'北京48','男','13521786808','hu_hujun48@163.com')
insert into H values('胡钧49',49,'北京49','男','13521786808','hu_hujun49@163.com')
insert into H values('胡钧50',50,'北京50','男','13521786808','hu_hujun50@163.com')
insert into H values('胡钧51',51,'北京51','男','13521786808','hu_hujun51@163.com')
insert into H values('胡钧52',52,'北京52','男','13521786808','hu_hujun52@163.com')
insert into H values('胡钧53',53,'北京53','男','13521786808','hu_hujun53@163.com')
insert into H values('胡钧54',54,'北京54','男','13521786808','hu_hujun54@163.com')
insert into H values('胡钧55',55,'北京55','男','13521786808','hu_hujun55@163.com')
insert into H values('胡钧56',56,'北京56','男','13521786808','hu_hujun56@163.com')
insert into H values('胡钧57',57,'北京57','男','13521786808','hu_hujun57@163.com')
insert into H values('胡钧58',58,'北京58','男','13521786808','hu_hujun58@163.com')
insert into H values('胡钧59',59,'北京59','男','13521786808','hu_hujun59@163.com')
insert into H values('胡钧60',60,'北京60','男','13521786808','hu_hujun60@163.com')
insert into H values('胡钧61',61,'北京61','男','13521786808','hu_hujun61@163.com')
insert into H values('胡钧62',62,'北京62','男','13521786808','hu_hujun62@163.com')
insert into H values('胡钧63',63,'北京63','男','13521786808','hu_hujun63@163.com')
insert into H values('胡钧64',64,'北京64','男','13521786808','hu_hujun64@163.com')
insert into H values('胡钧65',65,'北京65','男','13521786808','hu_hujun65@163.com')
insert into H values('胡钧66',66,'北京66','男','13521786808','hu_hujun66@163.com')
insert into H values('胡钧67',67,'北京67','男','13521786808','hu_hujun67@163.com')
insert into H values('胡钧68',68,'北京68','男','13521786808','hu_hujun68@163.com')
insert into H values('胡钧69',69,'北京69','男','13521786808','hu_hujun69@163.com')
insert into H values('胡钧70',70,'北京70','男','13521786808','hu_hujun70@163.com')
insert into H values('胡钧71',71,'北京71','男','13521786808','hu_hujun71@163.com')
insert into H values('胡钧72',72,'北京72','男','13521786808','hu_hujun72@163.com')
insert into H values('胡钧73',73,'北京73','男','13521786808','hu_hujun73@163.com')
insert into H values('胡钧74',74,'北京74','男','13521786808','hu_hujun74@163.com')
insert into H values('胡钧75',75,'北京75','男','13521786808','hu_hujun75@163.com')
insert into H values('胡钧76',76,'北京76','男','13521786808','hu_hujun76@163.com')
insert into H values('胡钧77',77,'北京77','男','13521786808','hu_hujun77@163.com')
insert into H values('胡钧78',78,'北京78','男','13521786808','hu_hujun78@163.com')
insert into H values('胡钧79',79,'北京79','男','13521786808','hu_hujun79@163.com')
insert into H values('胡钧80',80,'北京80','男','13521786808','hu_hujun80@163.com')
insert into H values('胡钧81',81,'北京81','男','13521786808','hu_hujun81@163.com')
insert into H values('胡钧82',82,'北京82','男','13521786808','hu_hujun82@163.com')
insert into H values('胡钧83',83,'北京83','男','13521786808','hu_hujun83@163.com')
insert into H values('胡钧84',84,'北京84','男','13521786808','hu_hujun84@163.com')
insert into H values('胡钧85',85,'北京85','男','13521786808','hu_hujun85@163.com')
insert into H values('胡钧86',86,'北京86','男','13521786808','hu_hujun86@163.com')
insert into H values('胡钧87',87,'北京87','男','13521786808','hu_hujun87@163.com')
insert into H values('胡钧88',88,'北京88','男','13521786808','hu_hujun88@163.com')
insert into H values('胡钧89',89,'北京89','男','13521786808','hu_hujun89@163.com')
insert into H values('胡钧90',90,'北京90','男','13521786808','hu_hujun90@163.com')
insert into H values('胡钧91',91,'北京91','男','13521786808','hu_hujun91@163.com')
insert into H values('胡钧92',92,'北京92','男','13521786808','hu_hujun92@163.com')
insert into H values('胡钧93',93,'北京93','男','13521786808','hu_hujun93@163.com')
insert into H values('胡钧94',94,'北京94','男','13521786808','hu_hujun94@163.com')
insert into H values('胡钧95',95,'北京95','男','13521786808','hu_hujun95@163.com')
insert into H values('胡钧96',96,'北京96','男','13521786808','hu_hujun96@163.com')
insert into H values('胡钧97',97,'北京97','男','13521786808','hu_hujun97@163.com')
insert into H values('胡钧98',98,'北京98','男','13521786808','hu_hujun98@163.com')
insert into H values('胡钧99',99,'北京99','男','13521786808','hu_hujun99@163.com')
insert into H values('胡钧100',100,'北京100','男','13521786808','hu_hujun100@163.com')
insert into H values('胡钧101',101,'北京101','男','13521786808','hu_hujun101@163.com')
insert into H values('胡钧102',102,'北京102','男','13521786808','hu_hujun102@163.com')
insert into H values('胡钧103',103,'北京103','男','13521786808','hu_hujun103@163.com')
insert into H values('胡钧104',104,'北京104','男','13521786808','hu_hujun104@163.com')
insert into H values('胡钧105',105,'北京105','男','13521786808','hu_hujun105@163.com')
insert into H values('胡钧106',106,'北京106','男','13521786808','hu_hujun106@163.com')
insert into H values('胡钧107',107,'北京107','男','13521786808','hu_hujun107@163.com')
insert into H values('胡钧108',108,'北京108','男','13521786808','hu_hujun108@163.com')
insert into H values('胡钧109',109,'北京109','男','13521786808','hu_hujun109@163.com')
insert into H values('胡钧110',110,'北京110','男','13521786808','hu_hujun110@163.com')
insert into H values('胡钧111',111,'北京111','男','13521786808','hu_hujun111@163.com')
insert into H values('胡钧112',112,'北京112','男','13521786808','hu_hujun112@163.com')
insert into H values('胡钧113',113,'北京113','男','13521786808','hu_hujun113@163.com')
insert into H values('胡钧114',114,'北京114','男','13521786808','hu_hujun114@163.com')
insert into H values('胡钧115',115,'北京115','男','13521786808','hu_hujun115@163.com')
insert into H values('胡钧116',116,'北京116','男','13521786808','hu_hujun116@163.com')
insert into H values('胡钧117',117,'北京117','男','13521786808','hu_hujun117@163.com')
insert into H values('胡钧118',118,'北京118','男','13521786808','hu_hujun118@163.com')
insert into H values('胡钧119',119,'北京119','男','13521786808','hu_hujun119@163.com')
insert into H values('胡钧120',120,'北京120','男','13521786808','hu_hujun120@163.com')
insert into H values('胡钧121',121,'北京121','男','13521786808','hu_hujun121@163.com')
insert into H values('胡钧122',122,'北京122','男','13521786808','hu_hujun122@163.com')
insert into H values('胡钧123',123,'北京123','男','13521786808','hu_hujun123@163.com')
insert into H values('胡钧124',124,'北京124','男','13521786808','hu_hujun124@163.com')
insert into H values('胡钧125',125,'北京125','男','13521786808','hu_hujun125@163.com')
insert into H values('胡钧126',126,'北京126','男','13521786808','hu_hujun126@163.com')
insert into H values('胡钧127',127,'北京127','男','13521786808','hu_hujun127@163.com')
insert into H values('胡钧128',128,'北京128','男','13521786808','hu_hujun128@163.com')
insert into H values('胡钧129',129,'北京129','男','13521786808','hu_hujun129@163.com')
insert into H values('胡钧130',130,'北京130','男','13521786808','hu_hujun130@163.com')
insert into H values('胡钧131',131,'北京131','男','13521786808','hu_hujun131@163.com')
insert into H values('胡钧132',132,'北京132','男','13521786808','hu_hujun132@163.com')
insert into H values('胡钧133',133,'北京133','男','13521786808','hu_hujun133@163.com')
insert into H values('胡钧134',134,'北京134','男','13521786808','hu_hujun134@163.com')
insert into H values('胡钧135',135,'北京135','男','13521786808','hu_hujun135@163.com')
insert into H values('胡钧136',136,'北京136','男','13521786808','hu_hujun136@163.com')
insert into H values('胡钧137',137,'北京137','男','13521786808','hu_hujun137@163.com')
insert into H values('胡钧138',138,'北京138','男','13521786808','hu_hujun138@163.com')
insert into H values('胡钧139',139,'北京139','男','13521786808','hu_hujun139@163.com')
insert into H values('胡钧140',140,'北京140','男','13521786808','hu_hujun140@163.com')
insert into H values('胡钧141',141,'北京141','男','13521786808','hu_hujun141@163.com')
insert into H values('胡钧142',142,'北京142','男','13521786808','hu_hujun142@163.com')
insert into H values('胡钧143',143,'北京143','男','13521786808','hu_hujun143@163.com')
insert into H values('胡钧144',144,'北京144','男','13521786808','hu_hujun144@163.com')
insert into H values('胡钧145',145,'北京145','男','13521786808','hu_hujun145@163.com')
insert into H values('胡钧146',146,'北京146','男','13521786808','hu_hujun146@163.com')
insert into H values('胡钧147',147,'北京147','男','13521786808','hu_hujun147@163.com')
insert into H values('胡钧148',148,'北京148','男','13521786808','hu_hujun148@163.com')
insert into H values('胡钧149',149,'北京149','男','13521786808','hu_hujun149@163.com')
insert into H values('胡钧150',150,'北京150','男','13521786808','hu_hujun150@163.com')
insert into H values('胡钧151',151,'北京151','男','13521786808','hu_hujun151@163.com')
insert into H values('胡钧152',152,'北京152','男','13521786808','hu_hujun152@163.com')
insert into H values('胡钧153',153,'北京153','男','13521786808','hu_hujun153@163.com')
insert into H values('胡钧154',154,'北京154','男','13521786808','hu_hujun154@163.com')
insert into H values('胡钧155',155,'北京155','男','13521786808','hu_hujun155@163.com')
insert into H values('胡钧156',156,'北京156','男','13521786808','hu_hujun156@163.com')
insert into H values('胡钧157',157,'北京157','男','13521786808','hu_hujun157@163.com')
insert into H values('胡钧158',158,'北京158','男','13521786808','hu_hujun158@163.com')
insert into H values('胡钧159',159,'北京159','男','13521786808','hu_hujun159@163.com')
insert into H values('胡钧160',160,'北京160','男','13521786808','hu_hujun160@163.com')
insert into H values('胡钧161',161,'北京161','男','13521786808','hu_hujun161@163.com')
insert into H values('胡钧162',162,'北京162','男','13521786808','hu_hujun162@163.com')
insert into H values('胡钧163',163,'北京163','男','13521786808','hu_hujun163@163.com')
insert into H values('胡钧164',164,'北京164','男','13521786808','hu_hujun164@163.com')
insert into H values('胡钧165',165,'北京165','男','13521786808','hu_hujun165@163.com')
insert into H values('胡钧166',166,'北京166','男','13521786808','hu_hujun166@163.com')
insert into H values('胡钧167',167,'北京167','男','13521786808','hu_hujun167@163.com')
insert into H values('胡钧168',168,'北京168','男','13521786808','hu_hujun168@163.com')
insert into H values('胡钧169',169,'北京169','男','13521786808','hu_hujun169@163.com')
insert into H values('胡钧170',170,'北京170','男','13521786808','hu_hujun170@163.com')
insert into H values('胡钧171',171,'北京171','男','13521786808','hu_hujun171@163.com')
insert into H values('胡钧172',172,'北京172','男','13521786808','hu_hujun172@163.com')
insert into H values('胡钧173',173,'北京173','男','13521786808','hu_hujun173@163.com')
insert into H values('胡钧174',174,'北京174','男','13521786808','hu_hujun174@163.com')
insert into H values('胡钧175',175,'北京175','男','13521786808','hu_hujun175@163.com')
insert into H values('胡钧176',176,'北京176','男','13521786808','hu_hujun176@163.com')
insert into H values('胡钧177',177,'北京177','男','13521786808','hu_hujun177@163.com')
insert into H values('胡钧178',178,'北京178','男','13521786808','hu_hujun178@163.com')
insert into H values('胡钧179',179,'北京179','男','13521786808','hu_hujun179@163.com')
insert into H values('胡钧180',180,'北京180','男','13521786808','hu_hujun180@163.com')
insert into H values('胡钧181',181,'北京181','男','13521786808','hu_hujun181@163.com')
insert into H values('胡钧182',182,'北京182','男','13521786808','hu_hujun182@163.com')
insert into H values('胡钧183',183,'北京183','男','13521786808','hu_hujun183@163.com')
insert into H values('胡钧184',184,'北京184','男','13521786808','hu_hujun184@163.com')
insert into H values('胡钧185',185,'北京185','男','13521786808','hu_hujun185@163.com')
insert into H values('胡钧186',186,'北京186','男','13521786808','hu_hujun186@163.com')
insert into H values('胡钧187',187,'北京187','男','13521786808','hu_hujun187@163.com')
insert into H values('胡钧188',188,'北京188','男','13521786808','hu_hujun188@163.com')
insert into H values('胡钧189',189,'北京189','男','13521786808','hu_hujun189@163.com')
insert into H values('胡钧190',190,'北京190','男','13521786808','hu_hujun190@163.com')
insert into H values('胡钧191',191,'北京191','男','13521786808','hu_hujun191@163.com')
insert into H values('胡钧192',192,'北京192','男','13521786808','hu_hujun192@163.com')
insert into H values('胡钧193',193,'北京193','男','13521786808','hu_hujun193@163.com')
insert into H values('胡钧194',194,'北京194','男','13521786808','hu_hujun194@163.com')
insert into H values('胡钧195',195,'北京195','男','13521786808','hu_hujun195@163.com')
insert into H values('胡钧196',196,'北京196','男','13521786808','hu_hujun196@163.com')
insert into H values('胡钧197',197,'北京197','男','13521786808','hu_hujun197@163.com')
insert into H values('胡钧198',198,'北京198','男','13521786808','hu_hujun198@163.com')
insert into H values('胡钧199',199,'北京199','男','13521786808','hu_hujun199@163.com')
insert into H values('胡钧200',200,'北京200','男','13521786808','hu_hujun200@163.com')
insert into H values('胡钧201',201,'北京201','男','13521786808','hu_hujun201@163.com')
insert into H values('胡钧202',202,'北京202','男','13521786808','hu_hujun202@163.com')
insert into H values('胡钧203',203,'北京203','男','13521786808','hu_hujun203@163.com')
insert into H values('胡钧204',204,'北京204','男','13521786808','hu_hujun204@163.com')
insert into H values('胡钧205',205,'北京205','男','13521786808','hu_hujun205@163.com')
insert into H values('胡钧206',206,'北京206','男','13521786808','hu_hujun206@163.com')
insert into H values('胡钧207',207,'北京207','男','13521786808','hu_hujun207@163.com')
insert into H values('胡钧208',208,'北京208','男','13521786808','hu_hujun208@163.com')
insert into H values('胡钧209',209,'北京209','男','13521786808','hu_hujun209@163.com')
insert into H values('胡钧210',210,'北京210','男','13521786808','hu_hujun210@163.com')
insert into H values('胡钧211',211,'北京211','男','13521786808','hu_hujun211@163.com')
insert into H values('胡钧212',212,'北京212','男','13521786808','hu_hujun212@163.com')
insert into H values('胡钧213',213,'北京213','男','13521786808','hu_hujun213@163.com')
insert into H values('胡钧214',214,'北京214','男','13521786808','hu_hujun214@163.com')
insert into H values('胡钧215',215,'北京215','男','13521786808','hu_hujun215@163.com')
insert into H values('胡钧216',216,'北京216','男','13521786808','hu_hujun216@163.com')
insert into H values('胡钧217',217,'北京217','男','13521786808','hu_hujun217@163.com')
insert into H values('胡钧218',218,'北京218','男','13521786808','hu_hujun218@163.com')
insert into H values('胡钧219',219,'北京219','男','13521786808','hu_hujun219@163.com')
insert into H values('胡钧220',220,'北京220','男','13521786808','hu_hujun220@163.com')
insert into H values('胡钧221',221,'北京221','男','13521786808','hu_hujun221@163.com')
insert into H values('胡钧222',222,'北京222','男','13521786808','hu_hujun222@163.com')
insert into H values('胡钧223',223,'北京223','男','13521786808','hu_hujun223@163.com')
insert into H values('胡钧224',224,'北京224','男','13521786808','hu_hujun224@163.com')
insert into H values('胡钧225',225,'北京225','男','13521786808','hu_hujun225@163.com')
insert into H values('胡钧226',226,'北京226','男','13521786808','hu_hujun226@163.com')
insert into H values('胡钧227',227,'北京227','男','13521786808','hu_hujun227@163.com')
insert into H values('胡钧228',228,'北京228','男','13521786808','hu_hujun228@163.com')
insert into H values('胡钧229',229,'北京229','男','13521786808','hu_hujun229@163.com')
insert into H values('胡钧230',230,'北京230','男','13521786808','hu_hujun230@163.com')
insert into H values('胡钧231',231,'北京231','男','13521786808','hu_hujun231@163.com')
insert into H values('胡钧232',232,'北京232','男','13521786808','hu_hujun232@163.com')
insert into H values('胡钧233',233,'北京233','男','13521786808','hu_hujun233@163.com')
insert into H values('胡钧234',234,'北京234','男','13521786808','hu_hujun234@163.com')
insert into H values('胡钧235',235,'北京235','男','13521786808','hu_hujun235@163.com')
insert into H values('胡钧236',236,'北京236','男','13521786808','hu_hujun236@163.com')
insert into H values('胡钧237',237,'北京237','男','13521786808','hu_hujun237@163.com')
insert into H values('胡钧238',238,'北京238','男','13521786808','hu_hujun238@163.com')
insert into H values('胡钧239',239,'北京239','男','13521786808','hu_hujun239@163.com')
insert into H values('胡钧240',240,'北京240','男','13521786808','hu_hujun240@163.com')
insert into H values('胡钧241',241,'北京241','男','13521786808','hu_hujun241@163.com')
insert into H values('胡钧242',242,'北京242','男','13521786808','hu_hujun242@163.com')
insert into H values('胡钧243',243,'北京243','男','13521786808','hu_hujun243@163.com')
insert into H values('胡钧244',244,'北京244','男','13521786808','hu_hujun244@163.com')
insert into H values('胡钧245',245,'北京245','男','13521786808','hu_hujun245@163.com')
insert into H values('胡钧246',246,'北京246','男','13521786808','hu_hujun246@163.com')
insert into H values('胡钧247',247,'北京247','男','13521786808','hu_hujun247@163.com')
insert into H values('胡钧248',248,'北京248','男','13521786808','hu_hujun248@163.com')
insert into H values('胡钧249',249,'北京249','男','13521786808','hu_hujun249@163.com')
insert into H values('胡钧250',250,'北京250','男','13521786808','hu_hujun250@163.com')
insert into H values('胡钧251',251,'北京251','男','13521786808','hu_hujun251@163.com')
insert into H values('胡钧252',252,'北京252','男','13521786808','hu_hujun252@163.com')
insert into H values('胡钧253',253,'北京253','男','13521786808','hu_hujun253@163.com')
insert into H values('胡钧254',254,'北京254','男','13521786808','hu_hujun254@163.com')
insert into H values('胡钧255',255,'北京255','男','13521786808','hu_hujun255@163.com')
insert into H values('胡钧256',256,'北京256','男','13521786808','hu_hujun256@163.com')
insert into H values('胡钧257',257,'北京257','男','13521786808','hu_hujun257@163.com')
insert into H values('胡钧258',258,'北京258','男','13521786808','hu_hujun258@163.com')
insert into H values('胡钧259',259,'北京259','男','13521786808','hu_hujun259@163.com')
insert into H values('胡钧260',260,'北京260','男','13521786808','hu_hujun260@163.com')
insert into H values('胡钧261',261,'北京261','男','13521786808','hu_hujun261@163.com')
insert into H values('胡钧262',262,'北京262','男','13521786808','hu_hujun262@163.com')
insert into H values('胡钧263',263,'北京263','男','13521786808','hu_hujun263@163.com')
insert into H values('胡钧264',264,'北京264','男','13521786808','hu_hujun264@163.com')
insert into H values('胡钧265',265,'北京265','男','13521786808','hu_hujun265@163.com')
insert into H values('胡钧266',266,'北京266','男','13521786808','hu_hujun266@163.com')
insert into H values('胡钧267',267,'北京267','男','13521786808','hu_hujun267@163.com')
insert into H values('胡钧268',268,'北京268','男','13521786808','hu_hujun268@163.com')
insert into H values('胡钧269',269,'北京269','男','13521786808','hu_hujun269@163.com')
insert into H values('胡钧270',270,'北京270','男','13521786808','hu_hujun270@163.com')
insert into H values('胡钧271',271,'北京271','男','13521786808','hu_hujun271@163.com')
insert into H values('胡钧272',272,'北京272','男','13521786808','hu_hujun272@163.com')
insert into H values('胡钧273',273,'北京273','男','13521786808','hu_hujun273@163.com')
insert into H values('胡钧274',274,'北京274','男','13521786808','hu_hujun274@163.com')
insert into H values('胡钧275',275,'北京275','男','13521786808','hu_hujun275@163.com')
insert into H values('胡钧276',276,'北京276','男','13521786808','hu_hujun276@163.com')
insert into H values('胡钧277',277,'北京277','男','13521786808','hu_hujun277@163.com')
insert into H values('胡钧278',278,'北京278','男','13521786808','hu_hujun278@163.com')
insert into H values('胡钧279',279,'北京279','男','13521786808','hu_hujun279@163.com')
insert into H values('胡钧280',280,'北京280','男','13521786808','hu_hujun280@163.com')
insert into H values('胡钧281',281,'北京281','男','13521786808','hu_hujun281@163.com')
insert into H values('胡钧282',282,'北京282','男','13521786808','hu_hujun282@163.com')
insert into H values('胡钧283',283,'北京283','男','13521786808','hu_hujun283@163.com')
insert into H values('胡钧284',284,'北京284','男','13521786808','hu_hujun284@163.com')
insert into H values('胡钧285',285,'北京285','男','13521786808','hu_hujun285@163.com')
insert into H values('胡钧286',286,'北京286','男','13521786808','hu_hujun286@163.com')
insert into H values('胡钧287',287,'北京287','男','13521786808','hu_hujun287@163.com')
insert into H values('胡钧288',288,'北京288','男','13521786808','hu_hujun288@163.com')
insert into H values('胡钧289',289,'北京289','男','13521786808','hu_hujun289@163.com')
insert into H values('胡钧290',290,'北京290','男','13521786808','hu_hujun290@163.com')
insert into H values('胡钧291',291,'北京291','男','13521786808','hu_hujun291@163.com')
insert into H values('胡钧292',292,'北京292','男','13521786808','hu_hujun292@163.com')
insert into H values('胡钧293',293,'北京293','男','13521786808','hu_hujun293@163.com')
insert into H values('胡钧294',294,'北京294','男','13521786808','hu_hujun294@163.com')
insert into H values('胡钧295',295,'北京295','男','13521786808','hu_hujun295@163.com')
insert into H values('胡钧296',296,'北京296','男','13521786808','hu_hujun296@163.com')
insert into H values('胡钧297',297,'北京297','男','13521786808','hu_hujun297@163.com')
insert into H values('胡钧298',298,'北京298','男','13521786808','hu_hujun298@163.com')
insert into H values('胡钧299',299,'北京299','男','13521786808','hu_hujun299@163.com')
insert into H values('胡钧300',300,'北京300','男','13521786808','hu_hujun300@163.com')
insert into H values('胡钧301',301,'北京301','男','13521786808','hu_hujun301@163.com')
insert into H values('胡钧302',302,'北京302','男','13521786808','hu_hujun302@163.com')
insert into H values('胡钧303',303,'北京303','男','13521786808','hu_hujun303@163.com')
insert into H values('胡钧304',304,'北京304','男','13521786808','hu_hujun304@163.com')
insert into H values('胡钧305',305,'北京305','男','13521786808','hu_hujun305@163.com')
insert into H values('胡钧306',306,'北京306','男','13521786808','hu_hujun306@163.com')
insert into H values('胡钧307',307,'北京307','男','13521786808','hu_hujun307@163.com')
insert into H values('胡钧308',308,'北京308','男','13521786808','hu_hujun308@163.com')
insert into H values('胡钧309',309,'北京309','男','13521786808','hu_hujun309@163.com')
insert into H values('胡钧310',310,'北京310','男','13521786808','hu_hujun310@163.com')
insert into H values('胡钧311',311,'北京311','男','13521786808','hu_hujun311@163.com')
insert into H values('胡钧312',312,'北京312','男','13521786808','hu_hujun312@163.com')
insert into H values('胡钧313',313,'北京313','男','13521786808','hu_hujun313@163.com')
insert into H values('胡钧314',314,'北京314','男','13521786808','hu_hujun314@163.com')
insert into H values('胡钧315',315,'北京315','男','13521786808','hu_hujun315@163.com')
insert into H values('胡钧316',316,'北京316','男','13521786808','hu_hujun316@163.com')
insert into H values('胡钧317',317,'北京317','男','13521786808','hu_hujun317@163.com')
insert into H values('胡钧318',318,'北京318','男','13521786808','hu_hujun318@163.com')
insert into H values('胡钧319',319,'北京319','男','13521786808','hu_hujun319@163.com')
insert into H values('胡钧320',320,'北京320','男','13521786808','hu_hujun320@163.com')
insert into H values('胡钧321',321,'北京321','男','13521786808','hu_hujun321@163.com')
insert into H values('胡钧322',322,'北京322','男','13521786808','hu_hujun322@163.com')
insert into H values('胡钧323',323,'北京323','男','13521786808','hu_hujun323@163.com')
insert into H values('胡钧324',324,'北京324','男','13521786808','hu_hujun324@163.com')
insert into H values('胡钧325',325,'北京325','男','13521786808','hu_hujun325@163.com')
insert into H values('胡钧326',326,'北京326','男','13521786808','hu_hujun326@163.com')
insert into H values('胡钧327',327,'北京327','男','13521786808','hu_hujun327@163.com')
insert into H values('胡钧328',328,'北京328','男','13521786808','hu_hujun328@163.com')
insert into H values('胡钧329',329,'北京329','男','13521786808','hu_hujun329@163.com')
insert into H values('胡钧330',330,'北京330','男','13521786808','hu_hujun330@163.com')
insert into H values('胡钧331',331,'北京331','男','13521786808','hu_hujun331@163.com')
insert into H values('胡钧332',332,'北京332','男','13521786808','hu_hujun332@163.com')
insert into H values('胡钧333',333,'北京333','男','13521786808','hu_hujun333@163.com')
insert into H values('胡钧334',334,'北京334','男','13521786808','hu_hujun334@163.com')
insert into H values('胡钧335',335,'北京335','男','13521786808','hu_hujun335@163.com')
insert into H values('胡钧336',336,'北京336','男','13521786808','hu_hujun336@163.com')
insert into H values('胡钧337',337,'北京337','男','13521786808','hu_hujun337@163.com')
insert into H values('胡钧338',338,'北京338','男','13521786808','hu_hujun338@163.com')
insert into H values('胡钧339',339,'北京339','男','13521786808','hu_hujun339@163.com')
insert into H values('胡钧340',340,'北京340','男','13521786808','hu_hujun340@163.com')
insert into H values('胡钧341',341,'北京341','男','13521786808','hu_hujun341@163.com')
insert into H values('胡钧342',342,'北京342','男','13521786808','hu_hujun342@163.com')
insert into H values('胡钧343',343,'北京343','男','13521786808','hu_hujun343@163.com')
insert into H values('胡钧344',344,'北京344','男','13521786808','hu_hujun344@163.com')
insert into H values('胡钧345',345,'北京345','男','13521786808','hu_hujun345@163.com')
insert into H values('胡钧346',346,'北京346','男','13521786808','hu_hujun346@163.com')
insert into H values('胡钧347',347,'北京347','男','13521786808','hu_hujun347@163.com')
insert into H values('胡钧348',348,'北京348','男','13521786808','hu_hujun348@163.com')
insert into H values('胡钧349',349,'北京349','男','13521786808','hu_hujun349@163.com')
insert into H values('胡钧350',350,'北京350','男','13521786808','hu_hujun350@163.com')
insert into H values('胡钧351',351,'北京351','男','13521786808','hu_hujun351@163.com')
insert into H values('胡钧352',352,'北京352','男','13521786808','hu_hujun352@163.com')
insert into H values('胡钧353',353,'北京353','男','13521786808','hu_hujun353@163.com')
insert into H values('胡钧354',354,'北京354','男','13521786808','hu_hujun354@163.com')
insert into H values('胡钧355',355,'北京355','男','13521786808','hu_hujun355@163.com')
insert into H values('胡钧356',356,'北京356','男','13521786808','hu_hujun356@163.com')
insert into H values('胡钧357',357,'北京357','男','13521786808','hu_hujun357@163.com')
insert into H values('胡钧358',358,'北京358','男','13521786808','hu_hujun358@163.com')
insert into H values('胡钧359',359,'北京359','男','13521786808','hu_hujun359@163.com')
insert into H values('胡钧360',360,'北京360','男','13521786808','hu_hujun360@163.com')
insert into H values('胡钧361',361,'北京361','男','13521786808','hu_hujun361@163.com')
insert into H values('胡钧362',362,'北京362','男','13521786808','hu_hujun362@163.com')
insert into H values('胡钧363',363,'北京363','男','13521786808','hu_hujun363@163.com')
insert into H values('胡钧364',364,'北京364','男','13521786808','hu_hujun364@163.com')
insert into H values('胡钧365',365,'北京365','男','13521786808','hu_hujun365@163.com')
insert into H values('胡钧366',366,'北京366','男','13521786808','hu_hujun366@163.com')
insert into H values('胡钧367',367,'北京367','男','13521786808','hu_hujun367@163.com')
insert into H values('胡钧368',368,'北京368','男','13521786808','hu_hujun368@163.com')
insert into H values('胡钧369',369,'北京369','男','13521786808','hu_hujun369@163.com')
insert into H values('胡钧370',370,'北京370','男','13521786808','hu_hujun370@163.com')
insert into H values('胡钧371',371,'北京371','男','13521786808','hu_hujun371@163.com')
insert into H values('胡钧372',372,'北京372','男','13521786808','hu_hujun372@163.com')
insert into H values('胡钧373',373,'北京373','男','13521786808','hu_hujun373@163.com')
insert into H values('胡钧374',374,'北京374','男','13521786808','hu_hujun374@163.com')
insert into H values('胡钧375',375,'北京375','男','13521786808','hu_hujun375@163.com')
insert into H values('胡钧376',376,'北京376','男','13521786808','hu_hujun376@163.com')
insert into H values('胡钧377',377,'北京377','男','13521786808','hu_hujun377@163.com')
insert into H values('胡钧378',378,'北京378','男','13521786808','hu_hujun378@163.com')
insert into H values('胡钧379',379,'北京379','男','13521786808','hu_hujun379@163.com')
insert into H values('胡钧380',380,'北京380','男','13521786808','hu_hujun380@163.com')
insert into H values('胡钧381',381,'北京381','男','13521786808','hu_hujun381@163.com')
insert into H values('胡钧382',382,'北京382','男','13521786808','hu_hujun382@163.com')
insert into H values('胡钧383',383,'北京383','男','13521786808','hu_hujun383@163.com')
insert into H values('胡钧384',384,'北京384','男','13521786808','hu_hujun384@163.com')
insert into H values('胡钧385',385,'北京385','男','13521786808','hu_hujun385@163.com')
insert into H values('胡钧386',386,'北京386','男','13521786808','hu_hujun386@163.com')
insert into H values('胡钧387',387,'北京387','男','13521786808','hu_hujun387@163.com')
insert into H values('胡钧388',388,'北京388','男','13521786808','hu_hujun388@163.com')
insert into H values('胡钧389',389,'北京389','男','13521786808','hu_hujun389@163.com')
insert into H values('胡钧390',390,'北京390','男','13521786808','hu_hujun390@163.com')
insert into H values('胡钧391',391,'北京391','男','13521786808','hu_hujun391@163.com')
insert into H values('胡钧392',392,'北京392','男','13521786808','hu_hujun392@163.com')
insert into H values('胡钧393',393,'北京393','男','13521786808','hu_hujun393@163.com')
insert into H values('胡钧394',394,'北京394','男','13521786808','hu_hujun394@163.com')
insert into H values('胡钧395',395,'北京395','男','13521786808','hu_hujun395@163.com')
insert into H values('胡钧396',396,'北京396','男','13521786808','hu_hujun396@163.com')
insert into H values('胡钧397',397,'北京397','男','13521786808','hu_hujun397@163.com')
insert into H values('胡钧398',398,'北京398','男','13521786808','hu_hujun398@163.com')
insert into H values('胡钧399',399,'北京399','男','13521786808','hu_hujun399@163.com')
insert into H values('胡钧400',400,'北京400','男','13521786808','hu_hujun400@163.com')
insert into H values('胡钧401',401,'北京401','男','13521786808','hu_hujun401@163.com')
insert into H values('胡钧402',402,'北京402','男','13521786808','hu_hujun402@163.com')
insert into H values('胡钧403',403,'北京403','男','13521786808','hu_hujun403@163.com')
insert into H values('胡钧404',404,'北京404','男','13521786808','hu_hujun404@163.com')
insert into H values('胡钧405',405,'北京405','男','13521786808','hu_hujun405@163.com')
insert into H values('胡钧406',406,'北京406','男','13521786808','hu_hujun406@163.com')
insert into H values('胡钧407',407,'北京407','男','13521786808','hu_hujun407@163.com')
insert into H values('胡钧408',408,'北京408','男','13521786808','hu_hujun408@163.com')
insert into H values('胡钧409',409,'北京409','男','13521786808','hu_hujun409@163.com')
insert into H values('胡钧410',410,'北京410','男','13521786808','hu_hujun410@163.com')
insert into H values('胡钧411',411,'北京411','男','13521786808','hu_hujun411@163.com')
insert into H values('胡钧412',412,'北京412','男','13521786808','hu_hujun412@163.com')
insert into H values('胡钧413',413,'北京413','男','13521786808','hu_hujun413@163.com')
insert into H values('胡钧414',414,'北京414','男','13521786808','hu_hujun414@163.com')
insert into H values('胡钧415',415,'北京415','男','13521786808','hu_hujun415@163.com')
insert into H values('胡钧416',416,'北京416','男','13521786808','hu_hujun416@163.com')
insert into H values('胡钧417',417,'北京417','男','13521786808','hu_hujun417@163.com')
insert into H values('胡钧418',418,'北京418','男','13521786808','hu_hujun418@163.com')
insert into H values('胡钧419',419,'北京419','男','13521786808','hu_hujun419@163.com')
insert into H values('胡钧420',420,'北京420','男','13521786808','hu_hujun420@163.com')
insert into H values('胡钧421',421,'北京421','男','13521786808','hu_hujun421@163.com')
insert into H values('胡钧422',422,'北京422','男','13521786808','hu_hujun422@163.com')
insert into H values('胡钧423',423,'北京423','男','13521786808','hu_hujun423@163.com')
insert into H values('胡钧424',424,'北京424','男','13521786808','hu_hujun424@163.com')
insert into H values('胡钧425',425,'北京425','男','13521786808','hu_hujun425@163.com')
insert into H values('胡钧426',426,'北京426','男','13521786808','hu_hujun426@163.com')
insert into H values('胡钧427',427,'北京427','男','13521786808','hu_hujun427@163.com')
insert into H values('胡钧428',428,'北京428','男','13521786808','hu_hujun428@163.com')
insert into H values('胡钧429',429,'北京429','男','13521786808','hu_hujun429@163.com')
insert into H values('胡钧430',430,'北京430','男','13521786808','hu_hujun430@163.com')
insert into H values('胡钧431',431,'北京431','男','13521786808','hu_hujun431@163.com')
insert into H values('胡钧432',432,'北京432','男','13521786808','hu_hujun432@163.com')
insert into H values('胡钧433',433,'北京433','男','13521786808','hu_hujun433@163.com')
insert into H values('胡钧434',434,'北京434','男','13521786808','hu_hujun434@163.com')
insert into H values('胡钧435',435,'北京435','男','13521786808','hu_hujun435@163.com')
insert into H values('胡钧436',436,'北京436','男','13521786808','hu_hujun436@163.com')
insert into H values('胡钧437',437,'北京437','男','13521786808','hu_hujun437@163.com')
insert into H values('胡钧438',438,'北京438','男','13521786808','hu_hujun438@163.com')
insert into H values('胡钧439',439,'北京439','男','13521786808','hu_hujun439@163.com')
insert into H values('胡钧440',440,'北京440','男','13521786808','hu_hujun440@163.com')
insert into H values('胡钧441',441,'北京441','男','13521786808','hu_hujun441@163.com')
insert into H values('胡钧442',442,'北京442','男','13521786808','hu_hujun442@163.com')
insert into H values('胡钧443',443,'北京443','男','13521786808','hu_hujun443@163.com')
insert into H values('胡钧444',444,'北京444','男','13521786808','hu_hujun444@163.com')
insert into H values('胡钧445',445,'北京445','男','13521786808','hu_hujun445@163.com')
insert into H values('胡钧446',446,'北京446','男','13521786808','hu_hujun446@163.com')
insert into H values('胡钧447',447,'北京447','男','13521786808','hu_hujun447@163.com')
insert into H values('胡钧448',448,'北京448','男','13521786808','hu_hujun448@163.com')
insert into H values('胡钧449',449,'北京449','男','13521786808','hu_hujun449@163.com')
insert into H values('胡钧450',450,'北京450','男','13521786808','hu_hujun450@163.com')
insert into H values('胡钧451',451,'北京451','男','13521786808','hu_hujun451@163.com')
insert into H values('胡钧452',452,'北京452','男','13521786808','hu_hujun452@163.com')
insert into H values('胡钧453',453,'北京453','男','13521786808','hu_hujun453@163.com')
insert into H values('胡钧454',454,'北京454','男','13521786808','hu_hujun454@163.com')
insert into H values('胡钧455',455,'北京455','男','13521786808','hu_hujun455@163.com')
insert into H values('胡钧456',456,'北京456','男','13521786808','hu_hujun456@163.com')
insert into H values('胡钧457',457,'北京457','男','13521786808','hu_hujun457@163.com')
insert into H values('胡钧458',458,'北京458','男','13521786808','hu_hujun458@163.com')
insert into H values('胡钧459',459,'北京459','男','13521786808','hu_hujun459@163.com')
insert into H values('胡钧460',460,'北京460','男','13521786808','hu_hujun460@163.com')
insert into H values('胡钧461',461,'北京461','男','13521786808','hu_hujun461@163.com')
insert into H values('胡钧462',462,'北京462','男','13521786808','hu_hujun462@163.com')
insert into H values('胡钧463',463,'北京463','男','13521786808','hu_hujun463@163.com')
insert into H values('胡钧464',464,'北京464','男','13521786808','hu_hujun464@163.com')
insert into H values('胡钧465',465,'北京465','男','13521786808','hu_hujun465@163.com')
insert into H values('胡钧466',466,'北京466','男','13521786808','hu_hujun466@163.com')
insert into H values('胡钧467',467,'北京467','男','13521786808','hu_hujun467@163.com')
insert into H values('胡钧468',468,'北京468','男','13521786808','hu_hujun468@163.com')
insert into H values('胡钧469',469,'北京469','男','13521786808','hu_hujun469@163.com')
insert into H values('胡钧470',470,'北京470','男','13521786808','hu_hujun470@163.com')
insert into H values('胡钧471',471,'北京471','男','13521786808','hu_hujun471@163.com')
insert into H values('胡钧472',472,'北京472','男','13521786808','hu_hujun472@163.com')
insert into H values('胡钧473',473,'北京473','男','13521786808','hu_hujun473@163.com')
insert into H values('胡钧474',474,'北京474','男','13521786808','hu_hujun474@163.com')
insert into H values('胡钧475',475,'北京475','男','13521786808','hu_hujun475@163.com')
insert into H values('胡钧476',476,'北京476','男','13521786808','hu_hujun476@163.com')
insert into H values('胡钧477',477,'北京477','男','13521786808','hu_hujun477@163.com')
insert into H values('胡钧478',478,'北京478','男','13521786808','hu_hujun478@163.com')
insert into H values('胡钧479',479,'北京479','男','13521786808','hu_hujun479@163.com')
insert into H values('胡钧480',480,'北京480','男','13521786808','hu_hujun480@163.com')
insert into H values('胡钧481',481,'北京481','男','13521786808','hu_hujun481@163.com')
insert into H values('胡钧482',482,'北京482','男','13521786808','hu_hujun482@163.com')
insert into H values('胡钧483',483,'北京483','男','13521786808','hu_hujun483@163.com')
insert into H values('胡钧484',484,'北京484','男','13521786808','hu_hujun484@163.com')
insert into H values('胡钧485',485,'北京485','男','13521786808','hu_hujun485@163.com')
insert into H values('胡钧486',486,'北京486','男','13521786808','hu_hujun486@163.com')
insert into H values('胡钧487',487,'北京487','男','13521786808','hu_hujun487@163.com')
insert into H values('胡钧488',488,'北京488','男','13521786808','hu_hujun488@163.com')
insert into H values('胡钧489',489,'北京489','男','13521786808','hu_hujun489@163.com')
insert into H values('胡钧490',490,'北京490','男','13521786808','hu_hujun490@163.com')
insert into H values('胡钧491',491,'北京491','男','13521786808','hu_hujun491@163.com')
insert into H values('胡钧492',492,'北京492','男','13521786808','hu_hujun492@163.com')
insert into H values('胡钧493',493,'北京493','男','13521786808','hu_hujun493@163.com')
insert into H values('胡钧494',494,'北京494','男','13521786808','hu_hujun494@163.com')
insert into H values('胡钧495',495,'北京495','男','13521786808','hu_hujun495@163.com')
insert into H values('胡钧496',496,'北京496','男','13521786808','hu_hujun496@163.com')
insert into H values('胡钧497',497,'北京497','男','13521786808','hu_hujun497@163.com')
insert into H values('胡钧498',498,'北京498','男','13521786808','hu_hujun498@163.com')
insert into H values('胡钧499',499,'北京499','男','13521786808','hu_hujun499@163.com')
go
create procedure prop_Select
as
select * from H


-----------------------------------------------------------------------------------------------------------------
Entity实体类 H

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Entity
{
    public class H
    {
        public int id { get; set; }
        public string name { get; set; }
        public int age { get; set; }
        public string address { get; set; }
        public string sex { get; set; }
        public string phone { get; set; }
        public string emial { get; set; }
    }
}

----------------------------------------------------------------------------------------------------------------
DAL层 SqlHelper.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Reflection;
using System.Data;

namespace DAL
{
    public class SqlHelper
    {
        //private const string CONNECTION_SQL = @"Data Source=.\sql2008;Initial Catalog=JDDB;User ID=sa";
        private const string CONNECTION_SQL = @"Data Source=MICROSO-OIQ0VNG;Initial Catalog=DemoInfo;Integrated Security=True";
        public static List<T> ExecuteList<T>(string sql)
        {
            List<T> lists = new List<T>();
            using (SqlConnection con = new SqlConnection(CONNECTION_SQL))
            {
                if (con.State != System.Data.ConnectionState.Open)
                {
                    con.Open();
                }
                using (SqlCommand cmd = new SqlCommand(sql, con))
                {
                    using (SqlDataReader dr = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection))
                    {
                        while (dr.Read())
                        {
                            T obj = ExecuteReader<T>(dr);
                            if (obj != null)
                            {
                                lists.Add(obj);
                            }
                        }
                    }
                }
            }
            return lists;
        }
        private static T ExecuteReader<T>(SqlDataReader dr)
        {
            T obj = default(T);
            Type type = typeof(T);
            obj = Activator.CreateInstance<T>();
            PropertyInfo[] propertyInfos = type.GetProperties();
            int columnCount = dr.FieldCount;
            foreach (PropertyInfo propertyInfo in propertyInfos)
            {
                for (int i = 0; i < columnCount; i++)
                {
                    string columnName = dr.GetName(i);
                    string propertyName = propertyInfo.Name;
                    if (string.Compare(columnName, propertyName, true) == 0)
                    {
                        object value = dr[i];
                        if (value != null
                            && value != DBNull.Value)
                        {
                            propertyInfo.SetValue(obj, value, null);
                            break;
                        }
                    }
                }
            }
            return obj;
        }
        /// <summary>
        /// 根据实体类查询数据
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="commandText"></param>
        /// <param name="commandType"></param>
        /// <param name="values"></param>
        /// <returns></returns>
        public static T ExecuteEntity<T>(string commandText, CommandType commandType = CommandType.Text, params SqlParameter[] values)
        {
            T obj = default(T);
            using (SqlConnection con = new SqlConnection(CONNECTION_SQL))
            {
                if (con.State != System.Data.ConnectionState.Open)
                {
                    con.Open();
                }
                using (SqlCommand cmd = new SqlCommand(commandText, con))
                {
                    cmd.CommandType = commandType;
                    cmd.Parameters.AddRange(values);
                    using (SqlDataReader dr = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection))
                    {
                        while (dr.Read())
                        {
                            obj = ExecuteReader<T>(dr);
                            break;
                        }
                    }
                }
            }
            return obj;
        }
       /// <summary>
        /// 执行不查询的操作
       /// </summary>
       /// <param name="commandText"></param>
       /// <param name="commandType"></param>
       /// <param name="values"></param>
       /// <returns></returns>
        public static int ExecuteNonQuery(string commandText, CommandType commandType = CommandType.Text, params SqlParameter[] values)
        {
            int count = 0;
            using (SqlConnection con = new SqlConnection(CONNECTION_SQL))
            {
                if (con.State != System.Data.ConnectionState.Open)
                {
                    con.Open();
                }
                using (SqlCommand cmd = new SqlCommand(commandText, con))
                {
                    cmd.CommandType = commandType;
                    cmd.Parameters.AddRange(values);
                    count = cmd.ExecuteNonQuery();
                }
            }
            return count;
        }
     
        /// <summary>
        /// 执行返回一行一列的操作（聚合函数的操作）
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static int ExecuteScalar(string commandText, CommandType commandType = CommandType.Text, params SqlParameter[] values)
        {
            int count = 0;
            using (SqlConnection con = new SqlConnection(CONNECTION_SQL))
            {
                if (con.State != System.Data.ConnectionState.Open)
                {
                    con.Open();
                }
                using (SqlCommand cmd = new SqlCommand(commandText, con))
                {
                    cmd.CommandType = commandType;
                    cmd.Parameters.AddRange(values);
                    count = (int)cmd.ExecuteScalar();
                }
            }
            return count;
        }
       
        /// <summary>
        /// 查询所有的数据
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="commandText"></param>
        /// <param name="commandType"></param>
        /// <param name="values"></param>
        /// <returns></returns>
        public static List<T> ExecuteList<T>(string commandText, CommandType commandType = CommandType.Text, params SqlParameter[] values)
        {
            List<T> list = new List<T>();
            using (SqlConnection con = new SqlConnection(CONNECTION_SQL))
            {
                if (con.State != System.Data.ConnectionState.Open)
                {
                    con.Open();
                }
                using (SqlCommand cmd = new SqlCommand(commandText, con))
                {
                    cmd.CommandType = commandType;
                    cmd.Parameters.AddRange(values);
                    using (SqlDataReader dr = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection))
                    {
                        while (dr.Read())
                        {
                            T obj = ExecuteReader<T>(dr);
                            list.Add(obj);
                        }
                    }
                }
            }
            return list;
        }
    }
}



DAL层 HDAL.cs


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;

namespace DAL
{
    public static class HDAL
    {
        public static List<Entity.H> Select() {
            List<Entity.H> list = null;
            list = SqlHelper.ExecuteList<Entity.H>("prop_Select", System.Data.CommandType.StoredProcedure);
            return list;
        }
    }
}




---------------------------------------------------------------------
BLL层 HBLL.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace BLL
{
    public static  class HBLL
    {
        public static List<Entity.H> Select()
        {
            return DAL.HDAL.Select();
        }
    }
}


-----------------------------------------------------------------------

页面 Index.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Index.aspx.cs" Inherits="pagination.Index" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <title></title>
    <script src="js/jquery.min.js" type="text/javascript"></script>
    <script src="js/jquery.pagination.js" type="text/javascript"></script>
    <script src="js/members.js" type="text/javascript"></script><!--从数据库中读取的数据 供页面显示!-->
    <link href="css/pagination.css" rel="stylesheet" type="text/css" />
   
    <script type="text/javascript">

        //这个文件显示分页插件不同的选项
        //还演示了如何使用JavaScript数据结构
        //生成分页的内容以及如何显示一个以上的
        //项目每页items_per_page。

        /**
        *回调函数，显示内容。
        *被称为每一次一个分页链接用户点击。
        * @param { int } page_index新页面索引
        * @param { jQuery } JQ容器与分页的链接作为一个jQuery对象
        */
        function pageselectCallback(page_index, jq) {
            // 让每pagionation页元素的表格编号
            var items_per_page = $("#items_per_page").val(); //每页显示的条数
            var iArray = new Array();
            iArray = members.split("|");

            var max_elem = Math.min((page_index + 1) * items_per_page, iArray.length);
            var newcontent = '';
            // 通过对内容的选择和建立一个HTML字符串迭代
            newcontent += '<tr><td>ID</td><td>姓名</td><td>年龄</td><td>性别</td><td>地址</td><td>电话</td></tr>';
            for (var i = page_index * items_per_page; i < max_elem; i++) {
                var item = new Array();
                item = iArray[i].split(",");
                newcontent += '<tr>';
                newcontent += '<td>' + item[0] + '</td>';
                newcontent += '<td>' + item[1] + '</td>';
                newcontent += '<td>' + item[2] + '</td>';
                newcontent += '<td>' + item[3] + '</td>';
                newcontent += '<td>' + item[4] + '</td>';
                newcontent += '<td>' + item[5] + '</td>';
                newcontent += '</tr>';
            }
            function DeleteId(id) {
                alert(id);
            }

            // 以新的内容替换旧的内容
            $('#Searchresult').html(newcontent);
            // 预防点击eventpropagation
            return false;
        }

        //表单包含许多pagiantion optiosn领域你可以
        //很快看到的不同选择的结果。
        //这个函数创建的分页功能的一个选择对象。
        //这将在你的应用程序在你设置的是不必要的一旦/选项。
        function getOptionsFromForm() {
            var opt = { callback: pageselectCallback };
            // 收集选项的文本域的域命名选择他们的同行一样
            $("input:text").each(function () {
                opt[this.name] = this.className.match(/numeric/) ? parseInt(this.value) : this.value;
            });
            //避免在这个演示HTML注射
            var htmlspecialchars = { "&": "&amp;", "<": "&lt;", ">": "&gt;", '"': "&quot;" }
            $.each(htmlspecialchars, function (k, v) {
                opt.prev_text = opt.prev_text.replace(k, v);
                opt.next_text = opt.next_text.replace(k, v);
            })
            return opt;
        }

        // 当文件已经加载，初始化分页表
        $(document).ready(function () {
            // 创建窗体分页单元选项
            var iArray = new Array();
            iArray = members.split("|");
            var optInit = getOptionsFromForm();
            $("#Pagination").pagination(iArray.length, optInit);

            // 事件处理程序的按钮
            $("#setoptions").click(function () {
                var opt = getOptionsFromForm();
                // 重新创建页码内容与新的参数
                $("#Pagination").pagination(iArray.length, opt);
            });

        });

    </script>
</head>
<body style="margin-left:20%">
    <div id="content">
        <h1>
            分页显示</h1>
        <div id="Pagination" class="pagination">
            <!--显示分页!-->
        </div>
        <br style="clear: both;" />
        <br />
        <table id="Searchresult" style="width: 800px"  class="dataList mt10">
        </table><br />
        <span style="color:Red">每页显示的条数</span><input type="text" value="5" name="items_per_page" id="items_per_page" /><br />
        <span style="color:Red">一些分页链接显示</span><input type="text" value="10" name="num_display_entries" id="num_display_entries"/><br />
        <span style="color:Red">开始和结束点的数目</span><input type="text" value="2" name="num_edge_entries" id="num_edge_entries"/> <br />
        <span style="color:Red">上一页显示的标识</span><input type="text" value="上一页" name="prev_text"id="prev_text" /> <br />
        <span style="color:Red">下一页显示的标识</span><input type="text" value="下一页" name="next_text" id="next_text" /><br /><br />
        <input type="button" id="setoptions" value="提交重置页面显示" />
    </div>
</body>
</html>





一般处理程序 IndexDo.ashx
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Text;

namespace pagination
{
    /// <summary>
    /// IndexDo 的摘要说明
    /// </summary>
    public class IndexDo : IHttpHandler
    {

        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";
            List<Entity.H> list = BLL.HBLL.Select();
            string item = "";
            //['张三32', '18', '男', '朝阳', '13521786808', '未婚']
            //['a16','16']] [['a1','1'],['a2','2'],['a3','3'],['a4','4'],['a5','5'],['a6','6'],['a7','7'],['a8','8'],['a9','9'],['a10','10'],['a11','11'],['a12','12'],['a13','13'],['a14','14'],['a15','15'],['a16','16']]
            for (int i = 0; i < list.Count; i++)
            {
                item +=  list[i].id+","+list[i].name+","+list[i].age+","+list[i].sex+","+list[i].address+","+list[i].phone + "|";//累加数据表中有多少条数据
            }

            item = item.Substring(0, item.LastIndexOf('|'));
            
            context.Response.Write(item);
        }

        public bool IsReusable
        {
            get
            {
                return false;
            }
        }
    }
}










----------------------------------------------------------------------------------------------
页面用到的JS
1.jquery.js的文件自己随便找个就可以了

2.jquery.pagination.js分页用的
/**
 * This jQuery plugin displays pagination links inside the selected elements.
 *
 * @author Gabriel Birke (birke *at* d-scribe *dot* de)
 * @version 1.2
 * @param {int} maxentries Number of entries to paginate
 * @param {Object} opts Several options (see README for documentation)
 * @return {Object} jQuery Object
 */
jQuery.fn.pagination = function(maxentries, opts){
    opts = jQuery.extend({
        items_per_page:10,
        num_display_entries:10,
        current_page:0,
        num_edge_entries:0,
        link_to:"#",
        prev_text:"Prev",
        next_text:"Next",
        ellipse_text:"...",
        prev_show_always:true,
        next_show_always:true,
        callback:function(){return false;}
    },opts||{});
    
    return this.each(function() {
        /**
         * Calculate the maximum number of pages
         */
        function numPages() {
            return Math.ceil(maxentries/opts.items_per_page);
        }
        
        /**
         * Calculate start and end point of pagination links depending on
         * current_page and num_display_entries.
         * @return {Array}
         */
        function getInterval()  {
            var ne_half = Math.ceil(opts.num_display_entries/2);
            var np = numPages();
            var upper_limit = np-opts.num_display_entries;
            var start = current_page>ne_half?Math.max(Math.min(current_page-ne_half, upper_limit), 0):0;
            var end = current_page>ne_half?Math.min(current_page+ne_half, np):Math.min(opts.num_display_entries, np);
            return [start,end];
        }
        
        /**
         * This is the event handling function for the pagination links.
         * @param {int} page_id The new page number
         */
        function pageSelected(page_id, evt){
            current_page = page_id;
            drawLinks();
            var continuePropagation = opts.callback(page_id, panel);
            if (!continuePropagation) {
                if (evt.stopPropagation) {
                    evt.stopPropagation();
                }
                else {
                    evt.cancelBubble = true;
                }
            }
            return continuePropagation;
        }
        
        /**
         * This function inserts the pagination links into the container element
         */
        function drawLinks() {
            panel.empty();
            var interval = getInterval();
            var np = numPages();
            // This helper function returns a handler function that calls pageSelected with the right page_id
            var getClickHandler = function(page_id) {
                return function(evt){ return pageSelected(page_id,evt); }
            }
            // Helper function for generating a single link (or a span tag if it's the current page)
            var appendItem = function(page_id, appendopts){
                page_id = page_id<0?0:(page_id<np?page_id:np-1); // Normalize page id to sane value
                appendopts = jQuery.extend({text:page_id+1, classes:""}, appendopts||{});
                if(page_id == current_page){
                    var lnk = jQuery("<span class='current'>"+(appendopts.text)+"</span>");
                }
                else
                {
                    var lnk = jQuery("<a>"+(appendopts.text)+"</a>")
                        .bind("click", getClickHandler(page_id))
                        .attr('href', opts.link_to.replace(/__id__/,page_id));
                        
                        
                }
                if(appendopts.classes){lnk.addClass(appendopts.classes);}
                panel.append(lnk);
            }
            // Generate "Previous"-Link
            if(opts.prev_text && (current_page > 0 || opts.prev_show_always)){
                appendItem(current_page-1,{text:opts.prev_text, classes:"prev"});
            }
            // Generate starting points
            if (interval[0] > 0 && opts.num_edge_entries > 0)
            {
                var end = Math.min(opts.num_edge_entries, interval[0]);
                for(var i=0; i<end; i++) {
                    appendItem(i);
                }
                if(opts.num_edge_entries < interval[0] && opts.ellipse_text)
                {
                    jQuery("<span>"+opts.ellipse_text+"</span>").appendTo(panel);
                }
            }
            // Generate interval links
            for(var i=interval[0]; i<interval[1]; i++) {
                appendItem(i);
            }
            // Generate ending points
            if (interval[1] < np && opts.num_edge_entries > 0)
            {
                if(np-opts.num_edge_entries > interval[1]&& opts.ellipse_text)
                {
                    jQuery("<span>"+opts.ellipse_text+"</span>").appendTo(panel);
                }
                var begin = Math.max(np-opts.num_edge_entries, interval[1]);
                for(var i=begin; i<np; i++) {
                    appendItem(i);
                }
                
            }
            // Generate "Next"-Link
            if(opts.next_text && (current_page < np-1 || opts.next_show_always)){
                appendItem(current_page+1,{text:opts.next_text, classes:"next"});
            }
        }
        
        // Extract current_page from options
        var current_page = opts.current_page;
        // Create a sane value for maxentries and items_per_page
        maxentries = (!maxentries || maxentries < 0)?1:maxentries;
        opts.items_per_page = (!opts.items_per_page || opts.items_per_page < 0)?1:opts.items_per_page;
        // Store DOM element for easy access from all inner functions
        var panel = jQuery(this);
        // Attach control functions to the DOM element
        this.selectPage = function(page_id){ pageSelected(page_id);}
        this.prevPage = function(){
            if (current_page > 0) {
                pageSelected(current_page - 1);
                return true;
            }
            else {
                return false;
            }
        }
        this.nextPage = function(){
            if(current_page < numPages()-1) {
                pageSelected(current_page+1);
                return true;
            }
            else {
                return false;
            }
        }
        // When all initialisation is done, draw the links
        drawLinks();
        // call callback function
        opts.callback(current_page, this);
    });
}


3.members.js 获取数据表中的数据
var members =
    $.ajax({
    type: "POST",
    url: "/IndexDo.ashx",
    data: "",
    cache: false,
    async: false
}).responseText



--------------------------------------
CSS pagination.css

.pagination {
            font-size: 80%;
        }
        
.pagination a {
    text-decoration: none;
    border: solid 1px #AAE;
    color: #15B;
}

.pagination a, .pagination span {
    display: block;
    float: left;
    padding: 0.3em 0.5em;
    margin-right: 5px;
    margin-bottom: 5px;
}

.pagination .current {
    background: #26B;
    color: #fff;
    border: solid 1px #AAE;
}

.pagination .current.prev, .pagination .current.next{
    color:#999;
    border-color:#999;
    background:#fff;
}