asp.net and datagrid 动态绑定数据列与存取特定列的值

来源：互联网发布：speedgrade什么软件编辑：程序博客网时间：2024/04/28 07:23

5.动态绑定数据列

<asp:datagrid id="DataGrid1" style="Z-INDEX: 101; LEFT: 232px; POSITION: absolute; TOP: 128px"
    runat="server" PageSize="3" AllowPaging="True" AutoGenerateColumns="False" BorderColor="#E7E7FF"
    BorderStyle="Double" BorderWidth="1px" BackColor="White" CellPadding="3" GridLines="Horizontal"
    Width="376px" DataKeyField="B010101">
    <SelectedItemStyle Font-Bold="True" ForeColor="#F7F7F7" BackColor="#738A9C"></SelectedItemStyle>
    <AlternatingItemStyle BackColor="#F7F7F7"></AlternatingItemStyle>
    <ItemStyle ForeColor="#4A3C8C" BackColor="#E7E7FF"></ItemStyle>
    <HeaderStyle Font-Bold="True" ForeColor="#F7F7F7" BackColor="#4A3C8C"></HeaderStyle>
    <FooterStyle ForeColor="#4A3C8C" BackColor="#B5C7DE"></FooterStyle>
    <Columns>
     <asp:TemplateColumn HeaderText="选择">
      <ItemTemplate>
       <asp:CheckBox ID="chk" Enabled="true" runat="server" />
      </ItemTemplate>
     </asp:TemplateColumn>
                   <asp:BoundColumn DataField="B010101" Visible=False >///为checkbox使用服务，因为下一列无法提取 *****************
      <ItemStyle HorizontalAlign="Center"></ItemStyle>
     </asp:BoundColumn>
     <asp:TemplateColumn HeaderText="行政县代码">
      <ItemTemplate>
       <a href="YGDZ_xianedit.aspx?sXianCode=<%#DataBinder.Eval(Container.DataItem,"B010101")%>&sXianName=<%#DataBinder.Eval(Container.DataItem,"B010102")%>" style="TEXT-DECORATION: none" ><%#DataBinder.Eval(Container.DataItem,"B010101")%></a>
      </ItemTemplate>
     </asp:TemplateColumn>
     <asp:TemplateColumn HeaderText="行政县名称">
      <ItemTemplate>
       <a href="YGDZ_xianedit.aspx?sXianCode=<%#DataBinder.Eval(Container.DataItem,"B010101")%>&sXianName=<%#DataBinder.Eval(Container.DataItem,"B010102")%>" style="TEXT-DECORATION: none"><%#DataBinder.Eval(Container.DataItem,"B010102")%></a>
      </ItemTemplate>
     </asp:TemplateColumn>
     <asp:BoundColumn DataField="B000006" HeaderText="是否失效">
      <ItemStyle HorizontalAlign="Center"></ItemStyle>
     </asp:BoundColumn>
    </Columns>
    <PagerStyle Visible="False" NextPageText="下一页" PrevPageText="上一页" HorizontalAlign="Right" PageButtonCount="5"></PagerStyle>
   </asp:datagrid>

6. 在datagrid中使用checkbox控件（与第五相匹配：）

private void BTXianDelete_Click(object sender, System.EventArgs e)
{
foreach(DataGridItem item in DataGrid1.Items )

   {
    CheckBox selection;
    selection = (CheckBox)item.FindControl("chk");
    if (selection.Checked)
    {
     string sXianCode=item.Cells[1].Text;//*************************
     YGDZ.WKR_T01_01_1Service objService2=new YGDZ.WKR_T01_01_1Service();
     YGDZ.WKR_T01_01_1Set dset= objService2.GetbySQL("delete WKR_T01_01_1 where B010101="+sXianCode);
    }

   }
  //
   DataGrid1.DataSource=new YGDZ.WKR_T01_01_1Service().GetAll();
   DataGrid1.DataBind();
   Label6.Text="第"+((Int32) DataGrid1.CurrentPageIndex +1)+"页"+"/共"+DataGrid1.PageCount +"页";

  }