//Article.cs
using System;

namespace News_Articles.Data
{
///

/// Summary description for Article.
///

public class Article
{
private int _id; //文章编号
private string _author; //文章的作者
private string _topic; //文章的标题
private DateTime _postTime; //文章的发表时间
private string _content; //文章内容

public int ID
{
get { return _id;}
set { _id = value;}
}
public string Author
{
get { return _author; }
set { _author = value; }
}
public string Topic
{
get { return _topic; }
set { _topic = value; }
}
public string Content
{
get { return _content; }
set { _content = value; }
}
public DateTime PostTime
{
get { return _postTime; }
set { _postTime = value; }
}
}
}

//ArticleCollection.cs
using System;
using System.Collections;

namespace News_Articles.Data
{
///

/// 文章的集合类，继承于 ArrayList
///

public class ArticleCollection : ArrayList
{
public ArticleCollection() : base()
{
}

public ArticleCollection(ICollection c) : base(c)
{
}
}
}

//ArticleDb.cs
using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;

namespace News_Articles.Data
{
/**////

/// 数据库操作类，实现文章数据库的读取，插入，更新，删除
///

public class ArticleDb
{
private SqlConnection _conn; //SQL Server 数据库连接
private string _articledb = "News_Articles"; //SQL Server 文章数据库表

/**////

/// 类的初始化，设置数据库连接
///

public ArticleDb()
{
_conn = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);
}

/**////

/// 打开数据库连接
///

public void Open()
{
if(_conn.State == ConnectionState.Closed)
_conn.Open();
}

/**////

/// 关闭数据库连接
///

public void Close()
{
if(_conn.State == ConnectionState.Open)
_conn.Close();
}

/**////

/// 读取数据库中所有的 文章
///

/// ArticleCollection
public ArticleCollection GetArticles()
{
ArticleCollection articles = new ArticleCollection();
string sql = "Select * FROM " + _articledb;
SqlCommand cmd = new SqlCommand(sql,_conn);
SqlDataReader dr = cmd.ExecuteReader();
while(dr.Read())
{
Article art = PopulateArticle(dr);
articles.Add(art);
}
dr.Close();
return articles;
}

/**////

/// 给定一个文章编号， 读取数据库中的一篇文章
///

/// Article
public Article GetArticle(int articleId)
{
string sql = "Select * FROM " + _articledb + "Where ID='" + articleId + "'";
SqlCommand cmd = new SqlCommand(sql,_conn);
SqlDataReader dr = cmd.ExecuteReader();