Paging in repeater control causing query problem

public partial class SearchResults : System.Web.UI.Page
{ 

	public int CurrentPage
	{
		get
		{
			// look for current page in ViewState
			object o = this.ViewState["_CurrentPage"];
			if (o == null)
				return 0; // default page index of 0
			else
				return (int)o;
		} 
		set
		{
			this.ViewState["_CurrentPage"] = value;
		}
	} 
	protected void Page_Load(object sender, EventArgs e)
	{
		ItemsGet();
	} 
    private void ItemsGet()
    {
        // Define ADO.NET objects.
        string selectSQL;
        selectSQL = "SELECT * FROM Members ";
        selectSQL += "WHERE ";
        selectSQL += Session["Search.gender"].ToString() == string.Empty ? "" : "gender=@gender"; 
		string connectionString = WebConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString;
		SqlConnection con = new SqlConnection(connectionString);
		SqlCommand cmd = new SqlCommand(selectSQL, con);
		SqlDataAdapter adapter = new SqlDataAdapter(cmd);
    	DataSet dsSearch = new DataSet(); 
        // Add the parameters
        cmd.Parameters.AddWithValue("@gender", Session["Search.gender"]); 
		// Try to open database and read information.
		try
		{
            con.Open();
			// All the information in transferred with one command.
			// This command creates a new DataTable (named Search)
			// inside the DataSet.
			adapter.Fill(dsSearch,"Search"); 
			
		}
		catch (Exception err)
		{
			lblStatus.Text = err.Message;
		}
		finally
		{
            // Close the connection.
            con.Close();
		} 
		// Populate the PagedDataSource control with the DataSet
        PagedDataSource pgResults = new PagedDataSource();
        pgResults.DataSource = dsSearch.Tables["Search"].DefaultView;
 
        // Indicate that the data should be paged
        pgResults.AllowPaging = true;
 
        // Set the number of items you wish to display per page
        pgResults.PageSize = 20;
 
        // Set the PagedDataSource's current page
        pgResults.CurrentPageIndex = CurrentPage;
 
        lblCurrentPage.Text = "Page: " + (CurrentPage + 1).ToString() + " of " + pgResults.PageCount.ToString();
 
        // Disable Prev or Next buttons if necessary
        cmdPrev.Enabled = !pgResults.IsFirstPage;
        cmdNext.Enabled = !pgResults.IsLastPage;
 
        rptSearch.DataSource = pgResults;
        rptSearch.DataBind();
    } 
    protected void  cmdPrev_Click1(object sender, EventArgs e)
	{
		// Set viewstate variable to the previous page
        CurrentPage -= 1;
 
        // Reload control
        ItemsGet();
	}
	protected void  cmdNext_Click1(object sender, EventArgs e)
	{
		// Set viewstate variable to the next page
        CurrentPage += 1;
 
        // Reload control
        ItemsGet();
	}
}