In gridview second page record not showing

See more:

C#3.5

protected void grdFarmerList_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            BindFarmerList();
            grdFarmerList.PageIndex = e.NewPageIndex;
            grdFarmerList.DataBind();
        }


  private void BindFarmerList()
        {
            try
            {
                dt = new DataTable();
dt = dal.DAL_GetFarmerRegistration_ByOrigin_ApproverID(originname, "", "farmerdata","farmerctscode");
                if (dt.Rows.Count > 0)
                {
                    grdFarmerList.DataSource = dt;
                    grdFarmerList.DataBind();
                }
            else
                  {
                      grdFarmerList.DataSource = dt;
                      grdFarmerList.DataBind();
                      grdFarmerList.EmptyDataText = "No Record Found";
                  }

            }
            catch (Exception ex)
            {
            }
      }


  public DataTable DAL_GetFarmerRegistration_ByOrigin_ApproverID(string originname, string approveheadid, string mastertype,string farmerctscode)
        {
            dataTable = new DataTable();
            try
            {
                sqlConnection = new SqlConnection(connStr);
                openConnection();
                sqlCommand = new SqlCommand();
                sqlCommand.Connection = sqlConnection;
         sqlCommand.CommandText = "sp_get_farmerregistration_by_origin_approveheadid";
                sqlCommand.CommandType = CommandType.StoredProcedure;
                sqlCommand.Parameters.AddWithValue("@originname", originname);
                sqlCommand.Parameters.AddWithValue("@approveheadid", approveheadid);
                sqlCommand.Parameters.AddWithValue("@mastertype", mastertype);
                sqlCommand.Parameters.AddWithValue("@farmerctscode", farmerctscode);
                sqlDataAdapter = new SqlDataAdapter(sqlCommand);
                sqlDataAdapter.Fill(dataTable);
            }
            catch (Exception ex)
            {
            }
            return dataTable;
        }

totally 10 records is there in database.

i have gridveiw, in that girdview paging is there, when i click first page five record shown and but when i click the second page next 5 record is not shown.

it shows the message No record found.


what is the mistake in my above code.

What I have tried:

as above