统计文章表中各类别的文章数_文章容量表-优快云博客

本文链接：https://blog.youkuaiyun.com/PConlineSTU/article/details/1514529

本文介绍了一个使用ASP.NET进行数据绑定的例子，演示了如何从数据库中读取数据并将其展示在DataGrid控件上。具体步骤包括配置数据库连接、执行SQL查询、填充数据集以及设置DataGrid的数据源。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

后台:

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" />