This is a migrated thread and some comments may be shown as answers.

Radgrid Pagination not working when databinded from serverside

4 Answers 421 Views

Grid

This is a migrated thread and some comments may be shown as answers.

mahesh asked on 03 Aug 2011, 09:14 AM

I have two radgrid , for the first radgrid i am binding the data from serverside , and for the second radgrid i am binding the data through sqldatasource from clientside.
The radgrid2 for which i bind the data through clientside,pagination property works fine , and my grid gets refresh each time.
But the major problem is when bind the radgrid from serverside my pagination property is not working,is their any property i have to set for pagination to work when i am binding the data from serverside, can any one please help to figure out the problem.

This is my aspx page code which contains the radgrid

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="RadGridRefreshTest.aspx.cs" Inherits="RadGridTest.RadGridRefreshTest" enableEventValidation="false" %><

br> <br

>    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><

br> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> </head> <body> <form id="form1" runat="server"> <div> <telerik:RadScriptManager ID="RadScriptManager1" runat="server" EnablePageMethods="true"> </telerik:RadScriptManager> <telerik:RadGrid ID="RadGrid1" runat="server" AllowPaging="true" PageSize="10" AllowCustomPaging="True" onpageindexchanged="RadGrid1PageIndexChanged" > <PagerStyle Mode="NextPrevAndNumeric" /> </telerik:RadGrid> second grid <telerik:RadGrid ID="RadGrid2" runat="server" CellSpacing="0"  DataSourceID="SqlDataSource" GridLines="None" onpageindexchanged="RadGrid2PageIndexChanged" > <MasterTableView AutoGenerateColumns="False" DataKeyNames="CustomerID"  DataSourceID="SqlDataSource" AllowPaging="true" PageSize="10" > <CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings> <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column"> <HeaderStyle Width="20px"></HeaderStyle> </RowIndicatorColumn> <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column"> <HeaderStyle Width="20px"></HeaderStyle> </ExpandCollapseColumn> <Columns> <telerik:GridBoundColumn DataField="CustomerID"  FilterControlAltText="Filter CustomerID column" HeaderText="CustomerID" ReadOnly="True" SortExpression="CustomerID" UniqueName="CustomerID"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CompanyName"  FilterControlAltText="Filter CompanyName column" HeaderText="CompanyName" SortExpression="CompanyName" UniqueName="CompanyName"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ContactName"  FilterControlAltText="Filter ContactName column" HeaderText="ContactName" SortExpression="ContactName" UniqueName="ContactName"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ContactTitle"  FilterControlAltText="Filter ContactTitle column" HeaderText="ContactTitle" SortExpression="ContactTitle" UniqueName="ContactTitle"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Address"  FilterControlAltText="Filter Address column" HeaderText="Address" SortExpression="Address" UniqueName="Address"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="City"  FilterControlAltText="Filter City column" HeaderText="City" SortExpression="City" UniqueName="City"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Region"  FilterControlAltText="Filter Region column" HeaderText="Region" SortExpression="Region" UniqueName="Region"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="PostalCode"  FilterControlAltText="Filter PostalCode column" HeaderText="PostalCode" SortExpression="PostalCode" UniqueName="PostalCode"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Country"  FilterControlAltText="Filter Country column" HeaderText="Country" SortExpression="Country" UniqueName="Country"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Phone"  FilterControlAltText="Filter Phone column" HeaderText="Phone" SortExpression="Phone" UniqueName="Phone"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Fax"  FilterControlAltText="Filter Fax column" HeaderText="Fax" SortExpression="Fax" UniqueName="Fax"> </telerik:GridBoundColumn> </Columns> <EditFormSettings> <EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn> </EditFormSettings> </MasterTableView> <FilterMenu EnableImageSprites="False"></FilterMenu> <HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu> </telerik:RadGrid> <asp:SqlDataSource ID="SqlDataSource" runat="server"  ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString2 %>" SelectCommand="SELECT * FROM [Customers]"></asp:SqlDataSource> </div> </form> </body> </html>

This is the code behind file where i am writing the code for grid binding using datasource

>            protected void RadGrid1PageIndexChanged(object sender, Telerik.Web.UI.GridPageChangedEventArgs e)<

br> { int index = e.NewPageIndex; int current = RadGrid1.CurrentPageIndex; } <br

>            protected void RadGrid2PageIndexChanged(object sender, Telerik.Web.UI.GridPageChangedEventArgs e)<

br> { int index = e.NewPageIndex; int current = RadGrid1.CurrentPageIndex; } }

4 Answers, 1 is accepted

Accepted

answered on 03 Aug 2011, 12:56 PM

Hi Shinu,
Thanks for the reply , my grid pagination is now working fine,But i have grid refresh problem ,after inserting some data through the Radwindow and closing the RadWindow,

I have a Radgrid in my aspx page which should automatically get refreshed after closing radwindow but i have some problem with ajax call , the datasource which i am binding to grid is updated , but the grid is not being refreshed ,can you please help to figure out the problem. I am using northwind database .

This is my aspx page which contains the grid

<%@
Page Language="C#" AutoEventWireup="true"
CodeBehind="RadGridRefreshTest.aspx.cs"
Inherits="RadGridTest.RadGridRefreshTest" enableEventValidation="false"
%><

br><br

><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><

br> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> </head> <body> <form id="form1" runat="server"> <div> <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server"> <script type="text/javascript"> function ShowInsertForm() { var sourcesystemfileid = 0;<br

>                                window.radopen("RadInsertWindow.aspx", "UserListDialog");<

br> return false; } function refreshGrid() {<br

>                                $find("<%= RadAjaxManager1.ClientID %>").ajaxRequest("Rebind");<

br> } function closeRadWindow() {<br

>                                $find("<%= RadAjaxManager1.ClientID %>").ajaxRequest("RebindAndNavigate");<

br> } </script> </telerik:RadCodeBlock> <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" OnAjaxRequest="RadAjaxManager1_AjaxRequest" EnableAJAX="true"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="RadAjaxManager1"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadGrid1" /> </UpdatedControls> </telerik:AjaxSetting> <telerik:AjaxSetting AjaxControlID="RadGrid1"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadGrid1" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <telerik:RadScriptManager ID="RadScriptManager1" runat="server" EnablePageMethods="true"> </telerik:RadScriptManager> <telerik:RadGrid ID="RadGrid1" runat="server" AllowPaging="true" PageSize="10" OnNeedDataSource="RadGrid1_NeedDataSource"> <PagerStyle Mode="NextPrevAndNumeric" /> <MasterTableView CommandItemDisplay="Bottom" PageSize="14" Width="100%"  AllowFilteringByColumn="True"> <CommandItemTemplate> <a href="#" onclick="return ShowInsertForm();">Add New Record</a> </CommandItemTemplate> </MasterTableView> </telerik:RadGrid> <telerik:RadWindowManager ID="RadWindowManager1" runat="server" EnableShadow="true" Skin="Black"> <Windows> <telerik:RadWindow ID="UserListDialog" runat="server" Height="620px" Width="620px"

<br>                               
ReloadOnShow="true" ShowContentDuringLoad="false" Modal="true"
OnClientClose="closeRadWindow" /><

br> </Windows> </telerik:RadWindowManager> </div> </form> </body> </html>

This is my code behind file for aspx page which contains the grid

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.Sql; using System.Data.SqlClient; using System.Data; using Telerik.Web.UI; using Telerik.Web.Data; namespace RadGridTest { public partial class RadGridRefreshTest : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void RadGrid2PageIndexChanged(object sender, Telerik.Web.UI.GridPageChangedEventArgs e) { int index = e.NewPageIndex; int current = RadGrid1.CurrentPageIndex; } public DataTable GetDataTable(string query) { String ConnString = "data source=ADMIN-PC1;uid=sa;password=sql;database=NorthWind"; SqlConnection conn = new SqlConnection(ConnString); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = new SqlCommand(query, conn); DataTable myDataTable = new DataTable(); conn.Open(); try { adapter.Fill(myDataTable); } finally { conn.Close(); } return myDataTable; } protected void RadGrid1_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e) {<br

>           
RadGrid1.DataSource = GetDataTable("SELECT CustomerID, CompanyName,
ContactName, ContactTitle, Address, PostalCode FROM Customers");<

br> } protected void RadAjaxManager1_AjaxRequest(object sender, Telerik.Web.UI.AjaxRequestEventArgs e) { if (e.Argument == "Rebind") { RadGrid1.MasterTableView.SortExpressions.Clear(); RadGrid1.MasterTableView.GroupByExpressions.Clear();<br

>               
RadGrid1.DataSource = GetDataTable("SELECT CustomerID, CompanyName,
ContactName, ContactTitle, Address, PostalCode FROM Customers");<

br> RadGrid1.Rebind(); } else if (e.Argument == "RebindAndNavigate") { RadGrid1.MasterTableView.SortExpressions.Clear(); RadGrid1.MasterTableView.GroupByExpressions.Clear();<br

>               
RadGrid1.DataSource = GetDataTable("SELECT CustomerID, CompanyName,
ContactName, ContactTitle, Address, PostalCode FROM Customers");<

br> RadGrid1.MasterTableView.CurrentPageIndex = RadGrid1.MasterTableView.PageCount - 1; RadGrid1.Rebind(); } } } }

This is the my rad window code where i will be performing insertion operation to the northwind customer table,after sucessfull insertion Radgrid has to get updated but this functionality is not working .

<%@
Page Language="C#" AutoEventWireup="true"
CodeBehind="RadInsertWindow.aspx.cs"
Inherits="RadGridTest.RadInsertWindow" %><

br><br

><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><

br> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> </head> <body> <form id="form1" runat="server"> <div> <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server"> <script type="text/javascript"> function CloseAndRebind(args) { GetRadWindow().BrowserWindow.refreshGrid(args); GetRadWindow().close(); } function GetRadWindow() { var oWindow = null;<br

>                       
if (window.radWindow) oWindow = window.radWindow; //Will work in Moz in
all cases, including clasic dialog<

br

>                       
else if (window.frameElement.radWindow) oWindow =
window.frameElement.radWindow; //IE (and Moz as well)<

br> return oWindow; } function CancelEdit() { GetRadWindow().close(); } </script> </telerik:RadCodeBlock> <asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager> <telerik:RadFormDecorator ID="InsertRecordRadFormDecorator" runat="server" Skin="Black" DecoratedControls="All" /> <asp:Label ID="Label1" runat="server" Text="CustomerId"></asp:Label> <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox> <br /> <asp:Label ID="Label2" runat="server" Text="CompanyName"></asp:Label> <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox> <br /> <asp:Label ID="Label3" runat="server" Text="ContactName"></asp:Label> <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox> <br /> <asp:Label ID="Label4" runat="server" Text="ContactTitle"></asp:Label> <asp:TextBox ID="TextBox4" runat="server"></asp:TextBox> <br /> <asp:Button ID="Button1" runat="server" Text="Save" onclick="Button1_Click" /> </div> </form> </body> </html>

This is the code behind file for the Rad insert window

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; namespace RadGridTest { public partial class RadInsertWindow : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { String ConnString = "data source=ADMIN-PC1;uid=sa;password=sql;database=NorthWind"; SqlConnection conn = new SqlConnection(ConnString); conn.Open(); string customerid=TextBox1.Text; string companyname=TextBox2.Text; string contactname=TextBox3.Text; string contacttitle= TextBox4.Text;<br

>           
SqlCommand insert=new SqlCommand("insert into Customers
values('"+customerid+"','"+companyname+"','"+contactname+"','"+contacttitle+"')");<

br> int result= insert.ExecuteNonQuery(); if (result == 1) {<br

>                ClientScript.RegisterStartupScript(Page.GetType(), "mykey1", "CloseAndRebind();", true);<

br> } conn.Close(); } } } 