ArrayList的问题

Question

我DataGrid分页是用ＳＱＬ语句控制实现的，现在完成数据修改，怎么才能将数据（不同页中）放到ArrayList中？

Answer 1

修改完成了，干吗要放到ArrayList中？如果要得到修改后的数据，直接操作数据库获取数据就是了

Answer 2

因为我的DataGrid是分页的，修改的数据在不同的页，我想将修改后的数据全部得到，然后在插入数据库．

Answer 3

忘了说了，我第一列是checkbox列

Answer 4

你可以写到一个SQL临时表中，也可以写入Cookie中存起来

Answer 5

DataGrid的显示如下CheckBox  |  科目编码　｜　科目名称
　cb      |     001    ｜　　 a
  cb      |     002    ｜     b

Answer 6

DataGrid的显示如下:
CheckBox  |  科目编码　｜　科目名称
　cb      |     001    ｜　　 a
  cb      |     002    ｜     b如何保存选中的数据？

Answer 7

<asp:datagrid   id="dgUserList"   runat="server"   Width="640px"   BorderColor="White"   PagerStyle-HorizontalAlign="Right"   
                                    AllowPaging="True"   AllowSorting="True"   AutoGenerateColumns="False">   
                                    <AlternatingItemStyle   BackColor="#F5F5F5"></AlternatingItemStyle>   
                                    <ItemStyle   HorizontalAlign="Center"></ItemStyle>   
                                    <HeaderStyle   HorizontalAlign="Center"   ForeColor="White"   BackColor="#4A95FD"   Height="8"></HeaderStyle>   
                                    <PagerStyle   HorizontalAlign="Right"   Mode="NumericPages"></PagerStyle>   
                                    <Columns>   
                                      <asp:TemplateColumn>   
                                        <HeaderTemplate>   
                                          <asp:CheckBox   id="chkAll"   runat="server"></asp:CheckBox>   
                                        </HeaderTemplate>   
                                        <ItemTemplate>   
                                          <asp:CheckBox   id="chkItem"   runat="server"></asp:CheckBox>   
                                        </ItemTemplate>   
                                      </asp:TemplateColumn>   
                                      <asp:BoundColumn   DataField="id"   HeaderText="序号"></asp:BoundColumn>   
                                      <asp:BoundColumn   DataField="username"   HeaderText="用户名"></asp:BoundColumn>   
                                      <asp:BoundColumn   DataField="workno"   HeaderText="工号"></asp:BoundColumn>   
                                      <asp:BoundColumn   DataField="dept"   HeaderText="部门"></asp:BoundColumn>   
                                    </Columns>   
                                    <PagerStyle   Visible="False"   HorizontalAlign="Right"   Mode="NumericPages"></PagerStyle>   
                                  </asp:datagrid>   
    
      
    
      
    
  后台代码:   
    
    private   void   dgUserList_PreRender(object   sender,   System.EventArgs   e)   
      {   
        foreach   (DataGridItem   item   in   dgUserList.Controls[0].Controls)   
        {   
          if   (item.ItemType   ==   ListItemType.Header)   
          {   
            CheckBox   chkAll=(CheckBox)item.FindControl("chkAll");   
            System.Text.StringBuilder   strScript   =   new   System.Text.StringBuilder("<script   language='javascript'>   \n");   
            strScript.Append("         function   checkStatus()   {   \n");   
            strScript.Append("                 var   bAll   =   true;   \n");   
            strScript.Append("                 bAll   =   document.all('"   +   chkAll.ClientID   +   "').checked;   \n");   
    
            for(int   i=0;   i<dgUserList.Items.Count   ;   i++)   
            {   
              strScript.Append("                 document.all('"   +   dgUserList.Items[i].Cells[0].FindControl("chkItem").ClientID   +   "').checked   =   bAll;   \n");   
            }   
            strScript.Append("         }   \n");   
            strScript.Append("</script>   \n");   
    
            if(!Page.IsClientScriptBlockRegistered("checkStatus"))   
              Page.RegisterClientScriptBlock("checkStatus",strScript.ToString());   
    
            chkAll.Attributes.Add("onclick","checkStatus()");   
            return;   
          }   
        }