Adapted from the php version. first, create the database table test, insert some test data, and then create an html file. If you are interested, refer to the following, we hope you can help us to adapt to the php version:
JQuery + PHP implement browsing more content http://www.helloweba.com/view-blog-130.html
The implementation in. net is recorded here.
1. Create a database table test and insert some test data.:
The Code is as follows:
Go
If exists (select * from sysobjects where name = 'test ')
Drop table [test]
Go
Create table [test] (
[Id] [int] IDENTITY (1, 1 ),
[Author] [varchar] (50 ),
[Content] [varchar] (2000 ),
[CreateOn] [datetime]
)
Declare @ index int;
Set @ index = 1;
While (@ index <1000)
Begin
Insert into test ([author], [content], [createOn])
Values
('Author' + cast (@ index as varchar (4), 'content' + cast (@ index as varchar (4), DATEADD (DAY, @ index, getdate ()))
Set @ index = @ index + 1
End
Go
2. Create an html file
The Code is as follows: