title: how to get gridview all rows data when using paging
body: <p>I have a gridview with paging (page size 10), which contains Course details. when i am saving gridview data into database it save only 10 record (according to page).
  is there any to get all gridview all rows.
  e.g. if my gridview contains 25 rows with paging and when i save data into database then all 25 rows data insert into database?
  please help...
  Here is my code</p>
  
  <pre><code>          DataTable dt = new DataTable();
          dt.Columns.Add("row_index");
          dt.Columns.Add("edited_value");
          IList&lt;int?&gt; SeqNos = new List&lt;int?&gt;();
  
  
          foreach (GridViewRow gvr in gvViolationCodes.Rows)
          {
              TextBox tb = (TextBox)gvr.FindControl("txtSeqNo");
              Label lblSysid = (Label)gvr.FindControl("lblSysID");
              HiddenField hf = (HiddenField)gvr.FindControl("HiddenField1");
              if (tb.Text != hf.Value)
              {
                  DataRow dr = dt.NewRow();
                  SeqNos.Add(Convert.ToInt32(tb.Text));
                  dr["row_index"] = lblSysid.Text;
                  dr["edited_value"] = tb.Text;
                  dt.Rows.Add(dr);
              }
          }
  </code></pre>