hi,
I am trying to implement paging in rad grid , but when i click from 1st page to 2nd radgrid is not dispalying any data.
what i am doing iin aspx page below:-
<form id="form1" runat="server">
<div>
<telerik:RadGrid ID="radgrdidemo" OnNeedDataSource="RadGrid1_NeedDataSource" AutoGenerateColumns="false" runat="server" >
<MasterTableView AllowPaging="true" AutoGenerateColumns="false">
<Columns>
<telerik:GridBoundColumn DataField="Inno_ID_Key" HeaderText="userid" Visible="true">
</telerik:GridBoundColumn>
</Columns>
</MasterTableView>
</telerik:RadGrid>
</div>
<div>
<telerik:RadAjaxLoadingPanel ID="LP1" runat="server"></telerik:RadAjaxLoadingPanel>
</div>
<div>
<telerik:RadAjaxManager runat="server">
<AjaxSettings>
<telerik:AjaxSetting AjaxControlID="radgrdidemo">
<UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="radgrdidemo" LoadingPanelID="LP1" />
</UpdatedControls>
</telerik:AjaxSetting>
</AjaxSettings>
</telerik:RadAjaxManager>
</div>
<div>
<telerik:RadScriptManager runat="server">
</telerik:RadScriptManager>
</div>
</form>
and i am binding grid in page load
public partial class WebForm5 : System.Web.UI.Page
{
public SqlDataReader dr;
protected void Page_Load(object sender, EventArgs e)
{
var conString = System.Configuration.ConfigurationManager.ConnectionStrings["Amscan-ProdConnectionString"];
string strConnString = conString.ConnectionString;
SqlConnection sqlCon = new SqlConnection(strConnString);
sqlCon.Open();
SqlCommand CMD = new SqlCommand(" SELECT Inno_ID_Key from DimAhiEvent ", sqlCon);
dr = CMD.ExecuteReader();
radgrdidemo.DataSource = dr;
radgrdidemo.DataBind();
}
protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
radgrdidemo.DataSource = dr;
}
}
and one thing there i see that when i am going from 1st pge to 2nd whole page loads again that i want to avoid .
I am trying to implement paging in rad grid , but when i click from 1st page to 2nd radgrid is not dispalying any data.
what i am doing iin aspx page below:-
<form id="form1" runat="server">
<div>
<telerik:RadGrid ID="radgrdidemo" OnNeedDataSource="RadGrid1_NeedDataSource" AutoGenerateColumns="false" runat="server" >
<MasterTableView AllowPaging="true" AutoGenerateColumns="false">
<Columns>
<telerik:GridBoundColumn DataField="Inno_ID_Key" HeaderText="userid" Visible="true">
</telerik:GridBoundColumn>
</Columns>
</MasterTableView>
</telerik:RadGrid>
</div>
<div>
<telerik:RadAjaxLoadingPanel ID="LP1" runat="server"></telerik:RadAjaxLoadingPanel>
</div>
<div>
<telerik:RadAjaxManager runat="server">
<AjaxSettings>
<telerik:AjaxSetting AjaxControlID="radgrdidemo">
<UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="radgrdidemo" LoadingPanelID="LP1" />
</UpdatedControls>
</telerik:AjaxSetting>
</AjaxSettings>
</telerik:RadAjaxManager>
</div>
<div>
<telerik:RadScriptManager runat="server">
</telerik:RadScriptManager>
</div>
</form>
and i am binding grid in page load
public partial class WebForm5 : System.Web.UI.Page
{
public SqlDataReader dr;
protected void Page_Load(object sender, EventArgs e)
{
var conString = System.Configuration.ConfigurationManager.ConnectionStrings["Amscan-ProdConnectionString"];
string strConnString = conString.ConnectionString;
SqlConnection sqlCon = new SqlConnection(strConnString);
sqlCon.Open();
SqlCommand CMD = new SqlCommand(" SELECT Inno_ID_Key from DimAhiEvent ", sqlCon);
dr = CMD.ExecuteReader();
radgrdidemo.DataSource = dr;
radgrdidemo.DataBind();
}
protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
radgrdidemo.DataSource = dr;
}
}
and one thing there i see that when i am going from 1st pge to 2nd whole page loads again that i want to avoid .