/// <summary>
/// 联盟链接实体类
/// </summary>
public class Union_LinkInfo
{
    private string _Title;
    private string _Url;

    public Union_LinkInfo()
    { }

    public Union_LinkInfo(string title, string url)
    {
        _Title = title;
        _Url = url;
    }

    /// <summary>
    /// 站点名称
    /// </summary>
    public string Title
    {
        get { return _Title; }
        set { _Title = value; }
    }

    /// <summary>
    /// 站点地址
    /// </summary>
    public string Url
    {
        get { return _Url; }
        set { _Url = value; }
    }
}

/// <summary>
/// 获取联盟链接列表
/// </summary>
/// <returns>对象集合</returns>
public IList<Union_LinkInfo> GetUnion_LinkList()
{
    IList<Union_LinkInfo> union_LinkList = new List<Union_LinkInfo>();

    using (SqlConnection conn = new SqlConnection("server=192.168.0.111;database=union_0119;user id=sa;password=sa;"))
    {
        conn.Open();
        SqlCommand cmd = new SqlCommand("Select title,url FROM Union_Link", conn);
        SqlDataReader sdr = cmd.ExecuteReader();
        while (sdr.Read())
        {
            Union_LinkInfo linkInfo = new Union_LinkInfo();

            linkInfo.Title = sdr.GetString(0);
            linkInfo.Url = sdr.GetString(1);

            union_LinkList.Add(linkInfo);
        }
        sdr.Close();
        conn.Close();
    }

    return union_LinkList;
}

IList<Union_LinkInfo> union_LinkList = GetUnion_LinkList();
for (int i = 0; i < union_LinkList.Count; i++)
{
    Response.Write(string.Format("{0}:{1}<br/>", union_LinkList[i].Title, union_LinkList[i].Url));
}