Radgrid paging

[Maksut]

Hi,

My codes is here.

protected void Button1_Click(object sender, EventArgs e)
       {

 DataTable dt = new DataTable();
           OleDbDataAdapter da=new OleDbDataAdapter("Select NAME, PHONE FROM TBL_CITY WHERE POP='"+TextBox1.Text+"' and ROWNUM<150",conn);
           da.Fill(dt);
           RadGrid1.DataSource = dt;
           RadGrid1.DataBind();
       }

<telerik:RadGrid ID="RadGrid2" runat="server" AllowPaging="True">
    </telerik:RadGrid>

When I click the button1 its ok. Radgrid is working.

But when I click the Next page or any page number, I can't see radgrid. 


For example:

I click the button1. Radgrid is ok.

When I click the 5. page number. I cant see radgrid.

After when ı click the button1. I am seeing 5. page radgrid :) 



How can I do? 

Sorry for my english.

[Andrey]

Hello,

As this help topic says you should not use simple databinding(calling DataBind method when you are using advanced functionality of RadGrid as paging, sorting, grouping, filtering, etc.

Instead you should use advanced databinding with NeedDataSource or declarative datasource.

Regards,
Andrey
the Telerik team