datagrid技巧

在datagrid 中使用了itemtemplate之后一定要加入AutoGenerateColumns="False"否则绑定后会出现后面的列

<asp:datagrid id="UserboxGrid" style="Z-INDEX: 102; LEFT: 112px; POSITION: absolute; TOP: 80px"
runat="server" Width="832px" Height="313px" Font-Names="楷体" Font-Name="楷体" Font-Size="8pt"
OnEditCommand="UserBoxGrid_Edit" PagerStyle-HorizontalAlign="Right" PagerStyle-Mode="NumericPages"
PageSize="30" AllowPaging="True" AlternatingItemStyle-BackColor="AliceBlue" HeaderStyle-BackColor="#aaaadd"
AutoGenerateColumns="False" BorderColor="Black" BackColor="#CCCCFF">
<AlternatingItemStyle BackColor="AliceBlue"></AlternatingItemStyle>
<HeaderStyle BackColor="#AAAADD"></HeaderStyle>
<Columns>
<asp:BoundColumn DataField="ID" ReadOnly="True" HeaderText="格子编号">
<HeaderStyle HorizontalAlign="Center" Height="3px" Width="100px"></HeaderStyle>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundColumn>
<asp:BoundColumn DataField="BoxNum" ReadOnly="True" HeaderText="格子数量">
<HeaderStyle HorizontalAlign="Center" Height="3px" Width="100px"></HeaderStyle>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundColumn>
<asp:TemplateColumn HeaderText="格子状态">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
<ItemStyle HorizontalAlign="Center" Width="20px"></ItemStyle>
<ItemTemplate>
<font face="宋体">
<%# (int)DataBinder.Eval(Container,"DataItem.BoxStat")==0?"未使用":((int)DataBinder.Eval(Container,"DataItem.BoxStat")==1?"已使用":((int)DataBinder.Eval(Container,"DataItem.BoxStat")==2?"已过期":"已提交")) %>
</font>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="有效期">
<HeaderStyle HorizontalAlign="Center" Height="3px" Width="100px"></HeaderStyle>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
<ItemTemplate>
<font face="宋体">
<%# DataBinder.Eval(Container,"DataItem.BoxLife")+"天" %>
</font>
</ItemTemplate>
</asp:TemplateColumn>
<asp:BoundColumn DataField="AddDate" ReadOnly="True" HeaderText="获得时间">
<HeaderStyle HorizontalAlign="Center" Height="3px" Width="100px"></HeaderStyle>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundColumn>
<asp:BoundColumn DataField="UseDate" ReadOnly="True" HeaderText="到期时间">
<HeaderStyle HorizontalAlign="Center" Height="3px" Width="100px"></HeaderStyle>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundColumn>
<asp:TemplateColumn HeaderText="操作">
<HeaderStyle HorizontalAlign="Center" Width="100px"></HeaderStyle>
<ItemStyle HorizontalAlign="Center" Width="100px"></ItemStyle>
<ItemTemplate>
<FONT face="宋体"></FONT><FONT face="宋体"></FONT><A href='ApplicationCell.aspx?UserID=<%# DataBinder.Eval(Container, "DataItem.UserID") %>'>
<%# (int)DataBinder.Eval(Container,"DataItem.BoxStat")==0?"使用格子":"----" %>
</A>else
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
<PagerStyle HorizontalAlign="Right" Mode="NumericPages"></PagerStyle>
</asp:datagrid>