[Video] Niuke News Publishing System

I made a news publishing system. I plan to record it as a video and share it with you for comments. Please bring your own eggs and bricks. Thank you!
The function of the whole news publishing system is very simple. It only needs to add, query, modify, and delete databases. It can be used in combination with other fancy features...
In the specific video, we will first release some interface diagrams for your appreciation! The entire video is recorded in four parts:

• Software Installation, database design, documentation
• . Net layer-3 BackgroundCodeWrite
• Div + CSS Front-End Interface Design (compatible with IE6, 7,8, Firefox, opera, Chrome)
• Integration of background code with the front-end interface and other fancy functions (Ajax and jquery)

Video:

01st lecture-software installation http://www.rayfile.com/files/a5550928-ad4f-11dd-ab5e-0014221b798a/
02nd lecture-Database Design 1 http://www.rayfile.com/files/fb31c85c-ae68-11dd-8338-0019d11a795f/
03rd lecture-Database Design 2 http://www.rayfile.com/files/345d2054-ae67-11dd-88eb-0019d11a795f/
04th lecture-interface simulation diagram design http://www.rayfile.com/files/fa6d8957-afef-11dd-86ca-0014221b798a/
05th lecture-data table operation design http://www.rayfile.com/files/db4257cf-aff8-11dd-945e-0014221b798a/
About sqlhelper http://www.rayfile.com/files/5bcf2ee8-b180-11dd-8d3e-0014221b798a/
07th lecture-writing Category Table operation class http://www.rayfile.com/files/4fe06ebd-b199-11dd-8f56-0014221b798a/
Lecture 08th-rebuilding sqlhelperhttp: // www.rayfile.com/files/40d1aedc-b19a-11dd-921d-0019d11a795f/
09th lecture-simple SQL Injection http://www.rayfile.com/files/3cd44d51-b19b-11dd-977c-0014221b798a/
10th lecture-building news category entity http://www.rayfile.com/files/58bda657-b2ec-11dd-94d9-0019d11a795f/
11th introduction-simple SQL trigger http://www.rayfile.com/files/980f82f5-b2ed-11dd-9556-0019d11a795f/
12th lecture-writing a News Comment http://www.rayfile.com/files/147693b8-b3e4-11dd-b112-0019d11a795f/
13th lecture-light-in-light storage process http://www.rayfile.com/files/dce3d0f5-b3e4-11dd-9786-0014221b798a/
14th-refactoring sqlhelper2 http://www.rayfile.com/files/3142de3d-b57b-11dd-8ed5-0014221b798a/
15th-Write the remaining Stored Procedure http://www.rayfile.com/files/a5ed6ba3-b57c-11dd-a29b-0019d11a795f/
16th lecture-complete news table operation class http://www.rayfile.com/files/85828d0c-b644-11dd-a60e-0019d11a795f/
17th-write BLL layer http://www.rayfile.com/files/f52b3e1e-b645-11dd-95ef-0014221b798a/

18th lecture-interface production essential software http://www.rayfile.com/files/32344c2b-b708-11dd-b743-0014221b798a/
19th-CSS introduction http://www.rayfile.com/files/a01f6299-b7d9-11dd-8996-0014221b798a/
20th-CSS core content http://www.rayfile.com/files/1c483005-b8a0-11dd-9c50-0014221b798a/
21st lecture-making home 1 http://www.rayfile.com/files/46ac852b-ba0d-11dd-912a-0014221b798a/
22nd lecture-production home 2 http://www.rayfile.com/files/fbde78cc-ba0f-11dd-b5cf-0014221b798a/
23rd lecture-production home 3 http://www.rayfile.com/files/6cc62f8c-ba36-11dd-9658-0014221b798a/
24th lecture-home made 4 http://www.rayfile.com/files/11c86f28-bafe-11dd-979f-0014221b798a/
25th lecture-home production 5 http://www.rayfile.com/files/a3302be8-bb00-11dd-a0b3-0014221b798a/
26th lecture-make master page http://www.rayfile.com/files/dc5885ae-bbb2-11dd-bd4c-0019d11a795f/
27th lecture-other pages make 1 http://www.rayfile.com/files/3a048435-bbc8-11dd-9732-0019d11a795f/
28th lecture-other page production 2 http://www.rayfile.com/files/aeb93c5e-bbcb-11dd-9a87-0019d11a795f/
29th lecture-create 1 http://www.rayfile.com/files/b1683af5-bd09-11dd-8482-0019d11a795f/ with border rounded corner Frame
30th lecture-create 2 http://www.rayfile.com/files/2842347d-bd0c-11dd-b8d0-0019d11a795f/ with border rounded corner Frame
31st lecture-make error page http://www.rayfile.com/files/511a68a6-bd2f-11dd-a1a8-0014221b798a/
32nd lecture-corner frame with variable width make 1 http://www.rayfile.com/files/de7282a1-bde4-11dd-8d63-0019d11a795f/
33rd lecture-corner frame with variable width to create 2 http://www.rayfile.com/files/f2b806ae-bde7-11dd-a162-0014221b798a/
34th lecture-complete category management page make http://www.rayfile.com/files/6b3390e3-be03-11dd-8839-0019d11a795f/
35th lecture-complete interface production http://www.rayfile.com/files/5104c528-be06-11dd-9c90-0014221b798a/

36th lecture-Integrated Home 1 http://www.rayfile.com/files/38f0a433-c07c-11dd-810a-0014221b798a/
37th lecture-integrated home 2 http://www.rayfile.com/files/3463b4d7-c081-11dd-a7d3-0019d11a795f/
38th lecture-Integrated news list page http://www.rayfile.com/files/b3001f45-c146-11dd-8b3d-0019d11a795f/
39th overview-integrated search page http://www.rayfile.com/files/8733f65e-c143-11dd-851d-0014221b798a/
40th lecture-Integrated news content page 1 http://www.rayfile.com/files/5e0cd4f8-c21c-11dd-bba2-0014221b798a/
41st lecture-Integrated news content page 2 http://www.rayfile.com/files/9d2a5140-c219-11dd-a4bb-0014221b798a/
42nd lecture-Integrated news content page 3 http://www.rayfile.com/files/dffed52b-c216-11dd-ac1b-0014221b798a/
43rd-front-end page debugging http://www.rayfile.com/files/9136ef35-c298-11dd-baf3-0019d11a795f/
44th lecture-integrated login page http://www.rayfile.com/files/14b5f463-c290-11dd-b737-0014221b798a/
45th lecture-integrated Category Management page 1 http://www.rayfile.com/files/aafa769c-c354-11dd-8eb2-0019d11a795f/
46th lecture-integrated Category Management page 2 http://www.rayfile.com/files/1b336d21-caaa-11dd-b141-0014221b798a/
47th lecture-integrated Category Management page 3 http://www.rayfile.com/files/41ab964f-caac-11dd-8925-0019d11a795f/
48th lecture-integrated Category Management page 4 http://www.rayfile.com/files/3dcfac14-caae-11dd-94d9-0014221b798a/
49th lecture-integrated Category Management page 5 http://www.rayfile.com/files/f65c35e1-cab0-11dd-8b40-0019d11a795f/
50th lecture-integrated Category Management page 6 http://www.rayfile.com/files/17e05917-cab5-11dd-9e30-0019d11a795f/
51st lecture-integrated Category Management page 7 http://www.rayfile.com/files/0b430fa6-d162-11dd-b65e-0014221b798a/
52nd lecture-integrated Category Management page 8 http://www.rayfile.com/files/b3361691-d164-11dd-b488-0019d11a795f/
53rd lecture-integrated Category Management page 9 http://www.rayfile.com/files/639da021-d168-11dd-bd61-0019d11a795f/
54th lecture-integrated Category Management page 10 http://www.rayfile.com/files/ff5446c5-d226-11dd-b6bd-0014221b798a/
55th lecture-integrated Category Management page 11 http://www.rayfile.com/files/f781580c-d228-11dd-b5fe-0014221b798a/
56th lecture-Integrated news management page 1 http://www.rayfile.com/files/09f5f6f5-d2f0-11dd-914e-0019d11a795f/
57th lecture-Integrated news management page 2 http://www.rayfile.com/files/ccde000a-d2f2-11dd-a2e2-0019d11a795f/
58th lecture-Integrated news management page 3 http://www.rayfile.com/files/696fde7a-d2f3-11dd-b1e3-0014221b798a/
59th lecture-integrated Add news page 1 http://www.rayfile.com/files/f38bd33a-d359-11dd-9257-0019d11a795f/
60th lecture-integrated Add news page 2 http://www.rayfile.com/files/c8560291-d484-11dd-8f1d-0019d11a795f/
61st lecture-end http://www.rayfile.com/files/efddcd2b-d484-11dd-bd9f-0014221b798a/
62nd lecture-coming to an end http://www.rayfile.com/files/8f3e7cee-d4f4-11dd-99c5-0019d11a795f/
63rd lecture-end to end http://www.rayfile.com/files/e25ee8f5-d4f8-11dd-a86c-0014221b798a/

Note: There seems to be a problem with the microphone, and the recorded video is noisy. Please forgive me!
The standard Mandarin lectures with the characteristics of Guangxi are adopted. Therefore, some friends in the North may have been familiar with it for a long time!
The video format is Avi and compressed in 7z format. rar can be decompressed normally. If RAR cannot be decompressed, you can install and decompress the 7zipsoftware at http://www.7zip.cn/download!

Technologies used:. Net three-layer architecture + sql2005 + jquery + Ajax + Div + CSS
Development Platform: Visual Studio 2008 express + sql2005 express + XP SP3
Development language: ASP. net c #

Final source file
Download: http://www.rayfile.com/files/14d...-be29-0014221b798a/
Note: The database is in the/web/app_data directory. If "read-only" is displayed during appending, follow these steps:
Http://niunan.javaeye.com/blog/265848
Forum address: http://www.tg029.com/viewthread.php? Tid = 1364 & extra = Page % 3d1 another: www.itcast.net