categorydb.cs

microsoft公司在进行ASP.NET 2.0培训课时课堂操作演示代码。

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;
using System.Data.SqlClient;
/// <summary>
/// CategoryDB 的摘要说明
/// </summary>
public class CategoryDB
{
	public CategoryDB()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}

    public DataSet GetCategoryData()
    {
        string sql = "select * from Categories";
        DB db = new DB();
        DataSet Ds = db.GetSqlDataSet(sql, "Categories");
        return Ds;
    }
    public void InsertCategoryData(string cname)
    {
        string sql = "insert into Categories(CategoryName) values(@categoryname)";
        SqlParameter parm = new SqlParameter("@categoryname", cname);
        DB db = new DB();
        db.ExcuteOneSqlData(sql, parm);
    }

    public void UpdateCategoryData(string cname,int cid)
    {
        string sql = "update Categories set CategoryName=@categoryname where CategoryId=@categoryid";
        SqlParameter[] param=new SqlParameter[2];
        param[0] = new SqlParameter("@categoryname",cname);
        param[1] = new SqlParameter("@categoryid",cid);
        DB Db = new DB();
        Db.ExcuteMultSqlData(sql, param);
    }
    
    public void DeleteCategoryData(int cid)
    {
        string sql = "delete from Categories where CategoryId=@categoryid";
        SqlParameter parm = new SqlParameter("@categoryid",cid );
        DB db = new DB();
        db.ExcuteOneSqlData(sql, parm);
    }
}