天天看點

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

                                     //這裡加 的作用是即使從資料庫中取出的不夠四個,table的cell之間還是可以看見是有線分割着的

                                <td align="center" style="width: 20%" id="tbsj2" runat="server">

                                     

                                <td align="center" style="width: 20%" id="tbsj3" runat="server">

                                <td align="center" style="width: 20%" id="tbsj4" runat="server">

                            </tr>

                                <td align="center" style="font-weight: bold; height: 30px; width: 5%">

                                    <asp:Label ID="Label27" runat="server" Text="主機組"></asp:Label>

                                <td align="center" style="font-weight: bold; height: 30px; width: 15%">

                                    <asp:Label ID="Label1" runat="server" Text="油位、氣味、聲音、震動、溫度"></asp:Label>

                                <td align="center" style="width: 20%" id="tbzjz1" runat="server">

                                <td align="center" style="width: 20%" id="tbzjz2" runat="server">

                                <td align="center" style="width: 20%" id="tbzjz3" runat="server">

                                <td align="center" style="width: 20%" id="tbzjz4" runat="server">

                                    <asp:Label ID="Label2" runat="server" Text="供水系統"></asp:Label>

                                    <asp:Label ID="Label3" runat="server" Text="壓力、聲音、滴漏、震動"></asp:Label>

                                <td align="center" style="width: 20%" id="tbgsxt1" runat="server">

                                <td align="center" style="width: 20%" id="tbgsxt2" runat="server">

                                <td align="center" style="width: 20%" id="tbgsxt3" runat="server">

                                <td align="center" style="width: 20%" id="tbgsxt4" runat="server">

                                    <asp:Label ID="Label4" runat="server" Text="供氣系統"></asp:Label>

                                    <asp:Label ID="Label5" runat="server" Text="壓力、聲音、洩漏"></asp:Label>

                                <td align="center" style="width: 20%" id="tbgqxt1" runat="server">

                                <td align="center" style="width: 20%" id="tbgqxt2" runat="server">

                                <td align="center" style="width: 20%" id="tbgqxt3" runat="server">

                                <td align="center" style="width: 20%" id="tbgqxt4" runat="server">

                                    <asp:Label ID="Label6" runat="server" Text="高低壓櫃"></asp:Label>

                                     <asp:Label ID="Label7" runat="server" Text=""></asp:Label>

                                <td align="center" style="width: 20%" id="tbgdyg1" runat="server">

                                <td align="center" style="width: 20%" id="tbgdyg2" runat="server">

                                <td align="center" style="width: 20%" id="tbgdyg3" runat="server">

                                <td align="center" style="width: 20%" id="tbgdyg4" runat="server">

                                    <asp:Label ID="Label8" runat="server" Text="上遊液壓門"></asp:Label>

                                     <asp:Label ID="Label9" runat="server" Text=""></asp:Label>

                                <td align="center" style="width: 20%" id="tbsyyym1" runat="server">

                                <td align="center" style="width: 20%" id="tbsyyym2" runat="server">

                                <td align="center" style="width: 20%" id="tbsyyym3" runat="server">

                                <td align="center" style="width: 20%" id="tbsyyym4" runat="server">

                                    <asp:Label ID="Label10" runat="server" Text="下遊檢修門"></asp:Label>

                                    <asp:Label ID="Label12" runat="server" Text="吊  挂"></asp:Label>

                                <td align="center" style="width: 20%" id="tbxyjxm1" runat="server">

                                <td align="center" style="width: 20%" id="tbxyjxm2" runat="server">

                                <td align="center" style="width: 20%" id="tbxyjxm3" runat="server">

                                <td align="center" style="width: 20%" id="tbxyjxm4" runat="server">

                                    <asp:Label ID="Label13" runat="server" Text="拍   門"></asp:Label>

                                    <asp:Label ID="Label14" runat="server" Text="絞座、拐臂、銷"></asp:Label>

                                <td align="center" style="width: 20%" id="tbpm1" runat="server">

                                <td align="center" style="width: 20%" id="tbpm2" runat="server">

                                <td align="center" style="width: 20%" id="tbpm3" runat="server">

                                <td align="center" style="width: 20%" id="tbpm4" runat="server">

                                    <asp:Label ID="Label15" runat="server" Text="10KV 站變"></asp:Label>

                                    <asp:Label ID="Label16" runat="server" Text="聲音、溫度"></asp:Label>

                                <td align="center" style="width: 20%" id="tbzb1" runat="server">

                                <td align="center" style="width: 20%" id="tbzb2" runat="server">

                                <td align="center" style="width: 20%" id="tbzb3" runat="server">

                                <td align="center" style="width: 20%" id="tbzb4" runat="server">

                      </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();

        }

繼續閱讀