yellowpage.aspx.cs

通过微软的最新技术ASP.NET2.0开发一个类似BtoC、CtoC的企业产品信息发布系统。 整体设计思想与规划： 用Firework设计图形

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.OleDb;
using System.Collections;


public partial class Yellowpage : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //设置连接
        db.con();

        //读取Categories表填充ds父表
        OleDbDataAdapter cmd1 = new OleDbDataAdapter("select * from Catalogs", db.con());
        DataSet ds = new DataSet();
        cmd1.Fill(ds, "Catalogs");

        //读取books表填充ds子表
        OleDbDataAdapter cmd2 = new OleDbDataAdapter("select * from SubCatalogs", db.con());
        cmd2.Fill(ds, "SubCatalogs");


        // 创建父表和子表关系.
        ds.Relations.Add("myrelation",
            ds.Tables["Catalogs"].Columns["Catalogid"],
            ds.Tables["SubCatalogs"].Columns["Catalogid"]);

        // 绑定Categories到父Repeater
        this.Repeater1.DataSource = ds.Tables["Catalogs"];
        this.Repeater1.DataBind();
    }

   


}