后台:

protected void Page_Load(object sender, EventArgs e)
    {
        DataSet ds;
        OleDbDataAdapter dr;
        DataColumn wenzhangtype;

        //Grab the Categories and Products table
        ds = new DataSet();
        string strDBPath = System.Configuration.ConfigurationSettings.AppSettings["DBPath"];
        string strConn = System.Configuration.ConfigurationSettings.AppSettings["Connection"] + Server.MapPath(strDBPath);
        OleDbConnection myConnection = new OleDbConnection(strConn);

        dr = new OleDbDataAdapter("Select * From ArticleType", myConnection);
        myConnection.Open();
        dr.Fill(ds, "ArticleType");
        dr.SelectCommand = new OleDbCommand("Select * From Article", myConnection);
        dr.Fill(ds, "Article");
        myConnection.Close();

        //Add Parent/Child Relationship
        ds.Relations.Add("catprods", ds.Tables["ArticleType"].Columns["typeid"], ds.Tables["Article"].Columns["typeid"]);

        //Add the aggregate column
        wenzhangtype = new DataColumn(("文章数"), System.Type.GetType("System.Decimal"));
        wenzhangtype.Expression = "Count( Child.NewsID )";
        ds.Tables["ArticleType"].Columns.Add(wenzhangtype);

        //Bind to the DataGrid
        DataGrid1.DataSource = ds;
        DataGrid1.DataMember = "ArticleType";
        DataGrid1.DataBind();

    }

前台:

<asp:DataGrid
  ID="DataGrid1"
  Runat="Server" /> 

发表于 @ 2007年02月26日 09:40:00|评论(loading...)