后台生成table表格

最新推荐文章于 2022-09-22 20:20:49 发布

albert528108

最新推荐文章于 2022-09-22 20:20:49 发布

阅读量937

点赞数

分类专栏：项目常用代码文章标签： table dataset border string server asp

本文链接：https://blog.csdn.net/albert528108/article/details/4213187

版权

项目常用代码专栏收录该内容

22 篇文章 0 订阅

订阅专栏

<asp:Table id="myTable" runat="server" width="80%" style="vertical-align:middle; border-color:#999999;" border="2"/>

long infoID = Shove._Convert.StrToLong(Request.QueryString["infoID"].ToString(), -1);
        long companyID = Shove._Convert.StrToLong(Request.QueryString["CompanyID"].ToString(), -1);
        TableRow TabRow = new TableRow();
        TabRow.HorizontalAlign = HorizontalAlign.Center;
        TableCell TabCell = new TableCell();
        TabCell.Text = "选项名称";
        TabRow.Cells.Add(TabCell);
        TabCell = new TableCell();
        TabCell.Text = "选中次数";
        TabRow.Cells.Add(TabCell);
        TabCell = new TableCell();
        TabCell.Text = "选中百分比";
        TabRow.Cells.Add(TabCell);
        myTable.Rows.Add(TabRow);

        string StrMsg = "";
        DataSet ds = new DataSet();
        int Result = DAL.Procedures.P_GetCompanyInfoDetailsByID(ref ds,infoID, companyID, ref StrMsg);

        int TatalCount = 0;
        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        {
            TatalCount += Shove._Convert.StrToInt(ds.Tables[0].Rows[i]["chooseCount"].ToString(), 0);
        }

        for(int i=0;i<ds.Tables[0].Rows.Count;i++)
        {
            TabRow = new TableRow();
            TabCell = new TableCell();
            TabCell.Text = ds.Tables[0].Rows[i]["Name"].ToString();
            TabRow.Cells.Add(TabCell);

            TabCell = new TableCell();
            TabCell.Text = ds.Tables[0].Rows[i]["chooseCount"].ToString();
            TabRow.Cells.Add(TabCell);

            TabCell = new TableCell();
            TabCell.Text = Math.Round(Shove._Convert.StrToDouble(ds.Tables[0].Rows[i]["chooseCount"].ToString(), 0) / TatalCount * 100, 2) + "%";
            TabRow.Cells.Add(TabCell);
            myTable.Rows.Add(TabRow);

}