DropDownList is empty.

Hello there.

First of all I must say that I am a newbie when it comes to net.
Here is my problem.

In this net code I don't have error but the `DropDownList ddlPages` is empty.

If you have link for similar task, please give it me.

Your help would be very appreciated.
thanks for your time and hints.


protected void GridView1_DataBound(Object sender, EventArgs e)
{
GridViewRow gvrPager = GridView1.BottomPagerRow;

if (gvrPager == null) return;

// get your controls from the gridview
DropDownList ddlPages = (DropDownList)gvrPager.Cells[0].FindControl("ddlPages");
Label lblPageCount = (Label)gvrPager.Cells[0].FindControl("lblPageCount");

if (ddlPages != null)
{
// populate pager
for (int i = 0; i < GridView1.PageCount; i++)
{

int intPageNumber = i + 1;
ListItem lstItem = new ListItem(intPageNumber.ToString());

if (i == GridView1.PageIndex)
lstItem.Selected = true;

ddlPages.Items.Add(lstItem);
}
}

// populate page count
if (lblPageCount != null)
lblPageCount.Text = GridView1.PageCount.ToString();
}


protected void ddlPages_SelectedIndexChanged(Object sender, EventArgs e)
{
GridViewRow gvrPager = GridView1.BottomPagerRow;
DropDownList ddlPages = (DropDownList)gvrPager.Cells[0].FindControl("ddlPages");

GridView1.PageIndex = ddlPages.SelectedIndex;

// a method to populate your grid
GridView1.DataSourceID = "SqlDataSource1";
GridView1.DataBind();
}


protected void Paginate(object sender, CommandEventArgs e)
{
// get the current page selected
int intCurIndex = GridView1.PageIndex;

switch (e.CommandArgument.ToString().ToLower())
{
case "first":
GridView1.PageIndex = 0;
break;
case "prev":
GridView1.PageIndex = intCurIndex - 1;
break;
case "next":
GridView1.PageIndex = intCurIndex + 1;
break;
case "last":
GridView1.PageIndex = GridView1.PageCount;
break;
}

// popultate the gridview control
GridView1.DataSourceID = "SqlDataSource1";
GridView1.DataBind();
}



ConnectionString="<%$ ConnectionStrings:ConnMySQL %>"
ProviderName="<%$ ConnectionStrings:ConnMySQL.ProviderName %>"
SelectCommand="SELECT * FROM tbl_1 "
DataSourceMode="DataSet"
OldValuesParameterFormatString="{0}"
OnSelected="SqlDataSource1_Selected" >




ImageUrl="/Images/bot_back_doble.gif"
CommandArgument="First" CommandName="Page" />
ImageUrl="/Images/bot_back.gif"
CommandArgument="Prev" CommandName="Page" />


AutoPostBack="True">
of runat="server">

ImageUrl="/Images/bot_next.gif"
CommandArgument="Next" CommandName="Page" />
ImageUrl="/Images/bot_next_doble.gif"
CommandArgument="Last" CommandName="Page" />