link.cs

这个是个未完成品 演示地址：http://www.yyzyq.com 仅以此例给正在学习编程爱好.net的朋友 希望能给大家带来帮助

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>
/// 友情链接类
/// </summary>
public class Link:SqlDataBase
{
	public Link()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}

    public DataView Dv_UserLink()
    {
        return GetDv("select '<a href=\"' + url + '\" target=\"_blank\">' + ISNULL(pic, name) + '</a>' AS superlink from link order by pic desc,adddate desc");
    }

    /// <summary>
    /// 显示友情链接
    /// </summary>
    /// <returns></returns>
    public DataView Dv_Link()
    {
        return GetDv("select * from link order by pic desc,adddate desc");
    }

    /// <summary>
    /// 添加友情链接
    /// </summary>
    /// <param name="name">名称</param>
    /// <param name="url">地址</param>
    /// <param name="alt">描述</param>
    public void AddLink(string name, string url, string alt)
    {
        string strSql = "insert into link(name,url,alt)values('" + name + "','" + url + "','" + alt + "')";
        RunSql(strSql);
    }
    
    /// <summary>
    /// 添加友情链接
    /// </summary>
    /// <param name="name">名称</param>
    /// <param name="url">地址</param>
    /// <param name="alt">描述</param>
    /// <param name="pic">图片地址</param>
    public void AddLink(string name, string url, string alt, string pic)
    {
        string strSql = "insert into link(name,url,alt,pic)values('" + name + "','" + url + "','" + alt + "','" + pic + "')";
        RunSql(strSql);
    }

    /// <summary>
    /// 删除友情链接
    /// </summary>
    /// <param name="id">编号</param>
    public void DelLink(string id)
    {
        string strSql = "delete link where id = " + id;
        RunSql(strSql);
    }
}