• ASP.NET GridView绑定数据


    <asp:GridView ID="AeroDataListGridView" runat="server" AutoGenerateColumns="False" 
                  CellPadding="3" ForeColor="#333333" GridLines="None" 
                  onrowdatabound="AeroDataListGridView_RowDataBound" AllowPaging="True" 
                  onpageindexchanging="AeroDataListGridView_PageIndexChanging" BackColor="White" 
                  BorderColor="Silver" BorderStyle="Ridge" CellSpacing="1" Width="1003px" 
                  DataKeyNames="aero_Id" PageSize="20">
                  <AlternatingRowStyle BackColor="#E6F7FE" />
                <Columns>
                   <asp:TemplateField HeaderText="平台" ItemStyle-Width="80px">
                      <ItemTemplate>
                        
                      </ItemTemplate>
                   </asp:TemplateField>
                   <asp:TemplateField HeaderText="型号名称">
                      <ItemTemplate>
                         <%#Eval("aero_Name")%>
                      </ItemTemplate>
                   </asp:TemplateField>
                   <asp:TemplateField HeaderText="在研状态">
                      <ItemTemplate>
                         <%#Eval("state")%>
                      </ItemTemplate>
                   </asp:TemplateField>
                   <asp:TemplateField HeaderText="总工作量">
                      <ItemTemplate>
                         <%#Eval("workload")%>
                      </ItemTemplate>
                   </asp:TemplateField>
                   <asp:TemplateField HeaderText="总正式工艺工作量">
                      <ItemTemplate>
                         <%#Eval("planned_step")%>
                      </ItemTemplate>
                   </asp:TemplateField>
                   <asp:TemplateField HeaderText="总临时工艺工作量">
                      <ItemTemplate>
                         <%#Eval("temp_step")%>
                      </ItemTemplate>
                   </asp:TemplateField>
                   <asp:TemplateField HeaderText="总工序">
                      <ItemTemplate>
                         <%#Eval("procedure")%>
                      </ItemTemplate>
                   </asp:TemplateField>
                   <asp:TemplateField HeaderText="总技术问题处理单数量">
                      <ItemTemplate>
                         <%#Eval("question")%>
                      </ItemTemplate>
                   </asp:TemplateField>
                   <asp:TemplateField HeaderText="总工期">
                      <ItemTemplate>
                         <%#Eval("duration")%>
                      </ItemTemplate>
                   </asp:TemplateField>
                   <asp:TemplateField HeaderText="日均工作量">
                      <ItemTemplate>
                         <%#Eval("dailywork")%>
                      </ItemTemplate>
                   </asp:TemplateField>
                   <asp:TemplateField HeaderText="操 作">
                      <ItemTemplate>
                          <asp:LinkButton ID="LinkButton1" runat="server" onclick="LinkButton1_Click">查看</asp:LinkButton>
                      </ItemTemplate>
                   </asp:TemplateField>
                </Columns>
                  <EditRowStyle BackColor="#2461BF" />
                  <FooterStyle BackColor="#B5CAE7" Font-Bold="True" ForeColor="White" />
                  <HeaderStyle BackColor="#B5CAE7" Font-Bold="True" ForeColor="White" 
                      HorizontalAlign="Center" />
                  <PagerStyle BackColor="#B5CAE7" ForeColor="White" HorizontalAlign="Center" />
                  <RowStyle BackColor="#B5CAE7" HorizontalAlign="Center" ForeColor="#305A68" />
                  <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                  <SortedAscendingCellStyle BackColor="#F5F7FB" />
                  <SortedAscendingHeaderStyle BackColor="#6D95E1" />
                  <SortedDescendingCellStyle BackColor="#E9EBEF" />
                  <SortedDescendingHeaderStyle BackColor="#4870BE" />
              </asp:GridView>

      protected void AeroDataListGridView_RowDataBound(object sender, GridViewRowEventArgs e)
            {
                if (e.Row.RowType == DataControlRowType.DataRow)
                {
                    AeroData t = (AeroData)e.Row.DataItem;
                    string aeroId =  t.aero_Id;
                    var re = from tt in context.SRC_DEF_PLATFORM_AEROCRAFT
                             where tt.AEROCRAFT_ID == aeroId
                             select tt;
                    if (re.Count() != 0)
                    {
                        decimal pId = (re.ToList())[0].PLATFORM_ID;
                        string pName = (context.SRC_DEF_PLATFORM.Where(item => item.PLATFORM_ID == pId)).Single().PLATFORM_NAME;
                        e.Row.Cells[0].Text = pName;
                    }
                    else
                    {
                        e.Row.Cells[0].Text = "";
                    }
                }
            }

  • 相关阅读:
    ERROR Function not available to this responsibility.Change responsibilities or contact your System Administrator.
    After Upgrade To Release 12.1.3 Users Receive "Function Not Available To This Responsibility" Error While Selecting Sub Menus Under Diagnostics (Doc ID 1200743.1)
    产品设计中先熟练使用铅笔 不要依赖Axure
    12.1.2: How to Modify and Enable The Configurable Home Page Delivered Via 12.1.2 (Doc ID 1061482.1)
    Reverting back to the R12.1.1 and R12.1.3 Homepage Layout
    常见Linux版本
    网口扫盲二:Mac与Phy组成原理的简单分析
    VMware 8安装苹果操作系统Mac OS X 10.7 Lion正式版
    VMware8安装MacOS 10.8
    回顾苹果操作系统Mac OS的发展历史
  • 原文地址:https://www.cnblogs.com/liuxinls/p/3075898.html
Copyright © 2020-2023  润新知