Hi
I'm using radrgid in my application inside the radpanelbar as one of the radpanelitem.
I need to get the data from database on regular interval of 2 minutes and need to show in grid without need of refreshing the page.
For the I'm using Timer and updating the panelbar using asp:updatepanel with conditional updatemode and calling needdatasource event from pageload for every 2 minutes.
So to have the chages on interval basis I'm rebing the grid.
But paging is not working. If I dnt rebind the grid I'm not able to see the new chages.
 here is my code of needdatasource event
Please help me as early as possible.

Thanks for ur quick reply.
But if don't rebind the grid I'm not able to see the new entry that just added.
In the table that which I binding to grid has the new entry but in grid its not showing.
I'm calling the needdatasource event for every 2 or 3 minutes.
After doing paging only I'm able to see new entry else its not showing
what should I do.

Hello,

you can use Advanced Data Binding for automatically handling the paging or handle manually paging.

Note : for manually binding
OnPageIndexChanged()
{
e.canceld = true;
dtConsole = accessData.GetData("select consolename from CONSOLE");
consloeGrid.MasterTableView.CurrentPageIndex =0 ; // new page index }

But i suggest you to use advance data binding.

You can store your data in viewstate/session/cache and achieve your requirement.
for ex.
try



Thanks,
Jayesh Goyani

Hii thanks for ur answer.
Still its not working.
I don't that  whether I was able to express my problem or not.
My requirement is.

First time when page load I will bind table to grid like in needdatasource.
consolegrid.datasource=dtconsole;
after 2 or 3 minutes(not refreshing wholepage) I'm calling needdatasource event to bind data and this time datatable having entry if any new data has inserted but for grid its not binding I think.
But If I call console.rebind() immedialtly after  consolegrid.datasource=dtconsole then its showing new record.
This time if I do paging its not moving to first page to second means paging not working.
If I dont call rebind its working.

Hi shinu here is my code

protected

 

 

void Page_load(object sender, EventArgs e)

 

{

 

 

//set the timer interval

 

refreshTimer.Interval = 10 * 60 *50;

 

 

if (Page.IsPostBack)

 

{

 

 

GridNeedDataSourceEventArgs GDE = null;

 

consloeGrid_NeedDataSource(

 

null, GDE);

 

}

 

}

 

 

 

protected void refreshTimer_Tick1(object sender, EventArgs e)

 

{

}

protected

 

 

void consloeGrid_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)

 

{

 

 

DataTable dtConsole=bindGrids("select consolename from CONSOLE");

 

consloeGrid.DataSource = dtConsole;

 

if (dtConsole.Rows.Count > 10)

 

{

consloeGrid.AllowPaging =

 

true;

 

}

 

 

else

 

{

consloeGrid.AllowPaging =

 

false;

 

}
//Here if I rebind() I'm able to see new records. but If rebind the grid paging is not working.Even though I handled pageindexchaged event, its not calling. If I dont rebind paging is working and new records showing only after do paging.
consoleGrid.Rebind();

}
Pleas help me as early as possible since its urgent for me.

Hello Ram,

If you are using Advanced data binding, the grid will rebind each time after any operation. If you are using timer for rebinding the grid, call Rebind() method in the timer tick event. Check the following demo for more on this.
Ajax / Ajaxify Timer.

Thanks,
Shinu.

Thanks very much.
It did trik.

i was able to get this to work for pageindexchanged. but i can't do this for pagesizechanged, it put me into an infinite loop and then crash with "Insufficient stack to continue executing the program safely. This can happen from having too many functions on the call stack or function on the stack using too much stack space." error. any idea how to resolve the pagesizechanged Jayesh? thank you for your help.

Hello,

If possible then can you please provide your code?

Thanks,
Jayesh Goyani

Thank you Yayesh

Hi Duy,

Please note that using DataBind() is not recommended. Performing complex grid operations such as Inserting, Deleting, Updating, Hierarchy relations, Grouping, Paging, Sorting, Filtering, etc. require accommodating appropriate database operations.  Therefore, we suggest you to avoid Simple Databinding and strongly recommend the use of more advanced databinding methods, which automatically handle the aforementioned functions:
Declarative DataSource
Advanced Data Binding

Hope this helps.

Regards,
Eyup
Telerik

Hello,

RadGrid will manage all things automatically we do not need manage it manually for Declarative DataSource and Advance Data Binding.

Please check below link.
Commands that invoke Rebind() implicitly

Thanks,
Jayesh Goyani

Why does Telerik have "Simple Data Binding", if it is apparently such a problem?  Quite often, on many of the forum threads, it is recommended to use Advanced.  They also recommended Adv. DB when getting the Insufficient Stack errors below.  It happens when the user does multiple (4 or more) filter and sort operations on RadGrid.  I switched to OnNeedDataSource, which then points to my BLL, then DAL; but, still no good about 80% of the time.  It will intermittently behave about 20% of the time, whether I use NeedData... or Declarative.  

 

Some of the forum blogs point to RadScriptManager, as the culprit.  In my Master Page, I have ...

<telerik:RadScriptManager runat="server" EnableCdn="true" ID="RadScriptManager1" EnablePageMethods="true" />​

 With EnableCdn="true", I get the first error below.  When I set EnableCdn="false", I get the second error message below.  I also set both to false and got the second error message as well.

 

Another forum blog suggested to view the Call Stack, so I put Breaks in the RadGrid ItemCommand, if (e.CommandName == "Filter" || e.CommandName == "Sort").  The VS Call Stack listed about 20 items.  Stepping beyond the ItemCommand event, it leaves my code and crashes, with an Unhandled exception somewhere in the Telerik assemblies.  How anyone is supposed to diagnose ​an error inside a Telerik dll ... I don't know.  Anyway, it looks like Telerik ASP.Net Ajax is having difficulty with Garbage Collection.  I use version Q3 2014, but, it seems to be happening across multiple versions, because there are many posts about the same thing.  And, to be fair, this might not be a Telerik issue.  It might just be the underlying, less than perfect platform: A​SP.Net/AJAX.

 

Any help will be appreciated.

-john-

 

 

Error #1 ...

Unhandled exception at line 881, column 13 in http://ajax.aspnetcdn.com/ajax/4.5.1/1/MicrosoftAjaxWebForms.debug.js

0x800a139e - JavaScript runtime error: Sys.WebForms.PageRequestManagerServerErrorException: Insufficient stack to continue executing the program safely. This can happen from having too many functions on the call stack or function on the stack using too much stack space.




Error #2 ...

Unhandled exception at line 15, column 16485 in http://localhost:49721/Telerik.Web.UI.WebResource.axd?_TSM_HiddenField_=RadScriptManager1_TSM&compress=1&_TSM_CombinedScripts_=;;System.Web.Extensions,+Version=4.0.0.0,+Culture=neutral,+PublicKeyToken=31bf3856ad364e35:en-US:88fd0407-24cf-4abd-9df5-22f81b2bc835:ea597d4b:b25378d2;Telerik.Web.UI,+Version=2014.3.1209.45,+Culture=neutral,+PublicKeyToken=121fae78165ba3d4:en-US:cd668efa-682a-4e93-b784-26f0724f247c:16e4e7cd:86526ba7:f7645509:24ee1bba:c128760b:19620875:874f8ea2:f46195d3:92fe8ea0:fa31b949:490a9d4e:bd8f85e4:11a04f7e:1e771326:88144a7a:4cacbc31:2a8622d7:e330518b:2003d0b8:c8618e41:1a73651d:333f8d94:ed16cbdc:8e6f0d33:6a6d718d:58366029:aa288e2d:258f1c72:e4f8f289

0x800a139e - JavaScript runtime error: Sys.WebForms.PageRequestManagerServerErrorException: Insufficient stack to continue executing the program safely. This can happen from having too many functions on the call stack or function on the stack using too much stack space.​

 

Hello John,

Please refer to the answer in the support ticket that you have opened for the same issue: Ticked ID: 967217.

If any further questions arise, I would like to suggest that we continue our conversation in the support ticket.


Regards,
Konstantin Dikov
Telerik

This turned out to be some bad code, on my part.  I was recursively calling FindControl of an inner-container that was not uniquely named.

In a support ticket, Konstantin suggested:
1) "...the error that you are receiving could be due to a infinite loop or endless recursion in your code-behind..."
2) "...disable the AJAX on your page (by setting the EnableAJAX property of your RadAjaxManager/RadAjaxPanelto false) and see the full stack trace of the error."

... which lead me to the resolution.  

Upon disabling Ajax, I re-tested and caused it to crash with the Insufficient Stack error.  The Stack Trace had 2400+ calls, indicating an infinite loop, mostly of RenderControl event.  Upon some minor Googling, that lead me to FindControl , which lead me to ItemCreate.  My ItemCreate was shared by all (3) RadGrids on (3) tabs, in the same page.  All (3) RadGrids have a NestedViewTemplate, with the same ID="InnerContainer".    I then made the ID unique for each (ie. InnerContainer
_RadGrid1). 

 

Thanks, Konstantin!