table伪动态数据绑定

2024-03-17 13:32
文章标签 绑定 table 动态数据

本文主要是介绍table伪动态数据绑定,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!

要实现如下图的效果

                   

 

前台FormView控件的项模板用table来简单布局下:

     <asp:FormView ID="FormView1" runat="server" DataKeyNames="ID"  Width="100%">
             <ItemTemplate> 

                    <table width="100%" cellpadding="0" cellspacing="0">
                            <tr>
                                <td colspan="2" style="background-color: #D7E8F8">
                                    <asp:Image ImageUrl="~/AQJDGL/Security/jzyx.jpg" runat="server" ID="Image1" />
                                </td>
                                <td align="center" style="width: 20%" id="tbsj1" runat="server">
                                 &nbsp;   //这里加&nbsp;的作用是即使从数据库中取出的不够四个,table的cell之间还是可以看见是有线分割着的
                                </td>
                                <td align="center" style="width: 20%" id="tbsj2" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbsj3" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbsj4" runat="server">
                                    &nbsp;
                                </td>
                            </tr>
                            <tr>
                                <td align="center" style="font-weight: bold; height: 30px; width: 5%">
                                    <asp:Label ID="Label27" runat="server" Text="主机组"></asp:Label>
                                </td>
                                <td align="center" style="font-weight: bold; height: 30px; width: 15%">
                                    <asp:Label ID="Label1" runat="server" Text="油位、气味、声音、震动、温度"></asp:Label>
                                </td>
                                <td align="center" style="width: 20%" id="tbzjz1" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbzjz2" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbzjz3" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbzjz4" runat="server">
                                    &nbsp;
                                </td>
                            </tr>
                            <tr>
                                <td align="center" style="font-weight: bold; height: 30px; width: 5%">
                                    <asp:Label ID="Label2" runat="server" Text="供水系统"></asp:Label>
                                </td>
                                <td align="center" style="font-weight: bold; height: 30px; width: 15%">
                                    <asp:Label ID="Label3" runat="server" Text="压力、声音、滴漏、震动"></asp:Label>
                                </td>
                                <td align="center" style="width: 20%" id="tbgsxt1" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbgsxt2" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbgsxt3" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbgsxt4" runat="server">
                                    &nbsp;
                                </td>
                            </tr>
                            <tr>
                                <td align="center" style="font-weight: bold; height: 30px; width: 5%">
                                    <asp:Label ID="Label4" runat="server" Text="供气系统"></asp:Label>
                                </td>
                                <td align="center" style="font-weight: bold; height: 30px; width: 15%">
                                    <asp:Label ID="Label5" runat="server" Text="压力、声音、泄漏"></asp:Label>
                                </td>
                                <td align="center" style="width: 20%" id="tbgqxt1" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbgqxt2" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbgqxt3" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbgqxt4" runat="server">
                                    &nbsp;
                                </td>
                            </tr>
                            <tr>
                                <td align="center" style="font-weight: bold; height: 30px; width: 5%">
                                    <asp:Label ID="Label6" runat="server" Text="高低压柜"></asp:Label>
                                </td>
                                <td align="center" style="font-weight: bold; height: 30px; width: 15%">
                                    &nbsp;<asp:Label ID="Label7" runat="server" Text=""></asp:Label>
                                </td>
                                <td align="center" style="width: 20%" id="tbgdyg1" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbgdyg2" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbgdyg3" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbgdyg4" runat="server">
                                    &nbsp;
                                </td>
                            </tr>
                            <tr>
                                <td align="center" style="font-weight: bold; height: 30px; width: 5%">
                                    <asp:Label ID="Label8" runat="server" Text="上游液压门"></asp:Label>
                                </td>
                                <td align="center" style="font-weight: bold; height: 30px; width: 15%">
                                    &nbsp;<asp:Label ID="Label9" runat="server" Text=""></asp:Label>
                                </td>
                                <td align="center" style="width: 20%" id="tbsyyym1" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbsyyym2" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbsyyym3" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbsyyym4" runat="server">
                                    &nbsp;
                                </td>
                            </tr>
                            <tr>
                                <td align="center" style="font-weight: bold; height: 30px; width: 5%">
                                    <asp:Label ID="Label10" runat="server" Text="下游检修门"></asp:Label>
                                </td>
                                <td align="center" style="font-weight: bold; height: 30px; width: 15%">
                                    <asp:Label ID="Label12" runat="server" Text="吊  挂"></asp:Label>
                                </td>
                                <td align="center" style="width: 20%" id="tbxyjxm1" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbxyjxm2" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbxyjxm3" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbxyjxm4" runat="server">
                                    &nbsp;
                                </td>
                            </tr>
                            <tr>
                                <td align="center" style="font-weight: bold; height: 30px; width: 5%">
                                    <asp:Label ID="Label13" runat="server" Text="拍   门"></asp:Label>
                                </td>
                                <td align="center" style="font-weight: bold; height: 30px; width: 15%">
                                    <asp:Label ID="Label14" runat="server" Text="绞座、拐臂、销"></asp:Label>
                                </td>
                                <td align="center" style="width: 20%" id="tbpm1" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbpm2" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbpm3" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbpm4" runat="server">
                                    &nbsp;
                                </td>
                            </tr>
                            <tr>
                                <td align="center" style="font-weight: bold; height: 30px; width: 5%">
                                    <asp:Label ID="Label15" runat="server" Text="10KV 站变"></asp:Label>
                                </td>
                                <td align="center" style="font-weight: bold; height: 30px; width: 15%">
                                    <asp:Label ID="Label16" runat="server" Text="声音、温度"></asp:Label>
                                </td>
                                <td align="center" style="width: 20%" id="tbzb1" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbzb2" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbzb3" runat="server">
                                    &nbsp;
                                </td>
                                <td align="center" style="width: 20%" id="tbzb4" runat="server">
                                    &nbsp;
                                </td>
                            </tr>

                      </table>

                </ItemTemplate>
          </asp:FormView>

后台cs文件中给这些td赋值:

 首先需要添加引用:

using System.Web.UI.HtmlControls;

        DM dm = new DM();
        string strSQL = "SELECT top 4 * FROM [机组运行巡视检查记录附表] WHERE 主表ID=" + int.Parse(id.ToString()) + " order by ID";
        DataSet ds = dm.getsql(strSQL);

        //获取数据集中数据个数
        int summ = ds.Tables[0].Rows.Count;
        for (int i = 1; i < summ + 1; i++)
        {

             //通过循环遍历给td单元格赋值
            ((HtmlTableCell)FormView1.FindControl("tbsj" + i.ToString())).InnerText = ds.Tables[0].Rows[i - 1]["检查时段"].ToString();
            ((HtmlTableCell)FormView1.FindControl("tbzjz" + i.ToString())).InnerText = ds.Tables[0].Rows[i-1]["主机组情况"].ToString();
            ((HtmlTableCell)FormView1.FindControl("tbgsxt" + i.ToString())).InnerText = ds.Tables[0].Rows[i-1]["供水系统情况"].ToString();
            ((HtmlTableCell)FormView1.FindControl("tbgqxt" + i.ToString())).InnerText = ds.Tables[0].Rows[i-1]["供气系统情况"].ToString();
            ((HtmlTableCell)FormView1.FindControl("tbgdyg" + i.ToString())).InnerText = ds.Tables[0].Rows[i-1]["高低压柜情况"].ToString();
            ((HtmlTableCell)FormView1.FindControl("tbsyyym" + i.ToString())).InnerText = ds.Tables[0].Rows[i-1]["上游液压门情况"].ToString();
            ((HtmlTableCell)FormView1.FindControl("tbxyjxm" + i.ToString())).InnerText = ds.Tables[0].Rows[i - 1]["下游检修门情况"].ToString();
            ((HtmlTableCell)FormView1.FindControl("tbpm" + i.ToString())).InnerText = ds.Tables[0].Rows[i - 1]["拍门情况"].ToString();
            ((HtmlTableCell)FormView1.FindControl("tbzb" + i.ToString())).InnerText = ds.Tables[0].Rows[i - 1]["站变情况"].ToString();
        }

 

 

这篇关于table伪动态数据绑定的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



http://www.chinasem.cn/article/819110

相关文章

MySQL CTE (Common Table Expressions)示例全解析

《MySQLCTE(CommonTableExpressions)示例全解析》MySQL8.0引入CTE,支持递归查询,可创建临时命名结果集,提升复杂查询的可读性与维护性,适用于层次结构数据处... 目录基本语法CTE 主要特点非递归 CTE简单 CTE 示例多 CTE 示例递归 CTE基本递归 CTE 结

MySQL 8 中的一个强大功能 JSON_TABLE示例详解

《MySQL8中的一个强大功能JSON_TABLE示例详解》JSON_TABLE是MySQL8中引入的一个强大功能,它允许用户将JSON数据转换为关系表格式,从而可以更方便地在SQL查询中处理J... 目录基本语法示例示例查询解释应用场景不适用场景1. ‌jsON 数据结构过于复杂或动态变化‌2. ‌性能要

解决1093 - You can‘t specify target table报错问题及原因分析

《解决1093-Youcan‘tspecifytargettable报错问题及原因分析》MySQL1093错误因UPDATE/DELETE语句的FROM子句直接引用目标表或嵌套子查询导致,... 目录报js错原因分析具体原因解决办法方法一:使用临时表方法二:使用JOIN方法三:使用EXISTS示例总结报错原

Linux进程CPU绑定优化与实践过程

《Linux进程CPU绑定优化与实践过程》Linux支持进程绑定至特定CPU核心,通过sched_setaffinity系统调用和taskset工具实现,优化缓存效率与上下文切换,提升多核计算性能,适... 目录1. 多核处理器及并行计算概念1.1 多核处理器架构概述1.2 并行计算的含义及重要性1.3 并

Linux下进程的CPU配置与线程绑定过程

《Linux下进程的CPU配置与线程绑定过程》本文介绍Linux系统中基于进程和线程的CPU配置方法,通过taskset命令和pthread库调整亲和力,将进程/线程绑定到特定CPU核心以优化资源分配... 目录1 基于进程的CPU配置1.1 对CPU亲和力的配置1.2 绑定进程到指定CPU核上运行2 基于

Java实现自定义table宽高的示例代码

《Java实现自定义table宽高的示例代码》在桌面应用、管理系统乃至报表工具中,表格(JTable)作为最常用的数据展示组件,不仅承载对数据的增删改查,还需要配合布局与视觉需求,而JavaSwing... 目录一、项目背景详细介绍二、项目需求详细介绍三、相关技术详细介绍四、实现思路详细介绍五、完整实现代码

MySQL的ALTER TABLE命令的使用解读

《MySQL的ALTERTABLE命令的使用解读》:本文主要介绍MySQL的ALTERTABLE命令的使用,具有很好的参考价值,希望对大家有所帮助,如有错误或未考虑完全的地方,望不吝赐教... 目录1、查看所建表的编China编程码格式2、修改表的编码格式3、修改列队数据类型4、添加列5、修改列的位置5.1、把列

Pandas透视表(Pivot Table)的具体使用

《Pandas透视表(PivotTable)的具体使用》透视表用于在数据分析和处理过程中进行数据重塑和汇总,本文就来介绍一下Pandas透视表(PivotTable)的具体使用,感兴趣的可以了解一下... 目录前言什么是透视表?使用步骤1. 引入必要的库2. 读取数据3. 创建透视表4. 查看透视表总结前言

GORM中Model和Table的区别及使用

《GORM中Model和Table的区别及使用》Model和Table是两种与数据库表交互的核心方法,但它们的用途和行为存在著差异,本文主要介绍了GORM中Model和Table的区别及使用,具有一... 目录1. Model 的作用与特点1.1 核心用途1.2 行为特点1.3 示例China编程代码2. Tab

基于@RequestParam注解之Spring MVC参数绑定的利器

《基于@RequestParam注解之SpringMVC参数绑定的利器》:本文主要介绍基于@RequestParam注解之SpringMVC参数绑定的利器,具有很好的参考价值,希望对大家有所帮助... 目录@RequestParam注解:Spring MVC参数绑定的利器什么是@RequestParam?@