摘要:
Default.aspx<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication1._Default" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transit 阅读全文
摘要:
创建测试数据:/* 文章表:Article */CREATE TABLE Article(ID int,TypeID int,Title nvarchar(50),AddDate datetime)INSERT Article SELECT 1, 1, N'文章1','2009-10-2'UNION ALL SELECT 2, 1, N'文章2','2009-10-11'UNION ALL SELECT 3, 1, N'文章3','2009-10-21'UNION ALL SELECT 4, 1, 阅读全文