Questions on UI for ASP.NET AJAX Forum

2 answers

84 views

I have a paginated radgrid that connects to a table with 23k records, of which I have 500 records displayed per page. Now, it takes a long time to get this first display, as I would expect for such a large DataSet. The problem is that it takes just as long to display another page of the radgrid, like it is going back to the database, refilling the DataSet, and then paging the data into the new display.

I am using the object source design pattern (simplified MVC), where (1) view (ASPX) requests data -> (2) controller (ASP .NET) invokes data access object -> (3) DAO queries database and stores DataSet as model in Application scope if it is not already present -> (4) controller delivers requested data to view

When radgrid needs another page of data, isn't that data readily available in the DataSet? Is the entire DataSet sent to the client (which is what I want) for quicker page transitions?

Relevant ASPX:

    
            <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">  
        
                <AjaxSettings> 
        
                    <telerik:AjaxSetting AjaxControlID="RadGrid1">  
        
                        <UpdatedControls> 
        
                            <telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1" UpdatePanelRenderMode="block" /> 
        
                        </UpdatedControls> 
        
                    </telerik:AjaxSetting> 
        
                </AjaxSettings> 
        
            </telerik:RadAjaxManager> 
        
            <telerik:RadGrid ID="radGrid1" runat="server">  
        
                <MasterTableView> 
        
                <Columns> 
        
                    <telerik:GridHyperLinkColumn DataTextField = "LIN" HeaderText = "LIN" DataNavigateUrlFields = "LIN" UniqueName = "lin"></telerik:GridHyperLinkColumn> 
        
                * * *  
        
                </Columns> 
        
                </MasterTableView> 
        
            </Telerik:RadGrid>

Relevant Codebehind:

    
            Protected Sub radGrid1_Load( sender As Object, e As EventArgs) Handles radGrid1.Load  
        
                Try  
        
                    If Application( "lins" ) Is Nothing Then  
        
                        Application( "lins" ) = dao_LIN.Get_LINs()  
        
                    End If  
        
                    radGrid1.DataSource = DirectCast( Application( "lins" ), DataSet )  
        
                    radGrid1.DataBind()  
        
                Catch ex As HttpException   
        
                    RadAjaxManager1.Alert( "Communication with the database failed: " & ex.Message())  
        
                    Response.Redirect( "/Lexis/Lexis_error.aspx?module=rcm" )  
        
                End Try  
        
            End Sub

The DAO (without exception code):

    
            <DataObject( True )> _  
        
            Public Class dao_LIN  
        
                <DataObjectMethod( DataObjectMethodType.Fill )> _  
        
                Public Shared Function Get_LINs() As DataSet  
        
                    Dim ds As DataSet = New DataSet()  
        
                    Dim cmd As OracleCommand = New OracleCommand( "select * from VW_LIN_REF_WITH_COSTS order by LIN", dao_Conn.Instance( "OracleConnectionString" ))  
        
                    Dim da As OracleDataAdapter = New OracleDataAdapter( cmd )  
        
                    da.Fill( ds )  
        
                    Return ds  
        
            End Function

Seems pretty straight-forward to me. What am I missing so that I can get the pagination on the client to be very fast?

Cheers!
Mark

Grid

answered on 19 Feb 2010

1 answer

91 views

a.Month is undefined

We're having an issue with a calendar implementation. When the user navigates to the page with the calendar on it, everything works fine. But after clicking the back button (to go to the previous page) and then clicking the forward button (to go back to the calendar page), all JavaScript on the calendar stops working. In the error console, I see the following error: "a.Month is undefined." Is anybody else having trouble with this? Is there a workaround?

Scheduler

answered on 19 Feb 2010

2 answers

175 views

GRID EXPORT ERROR

This functionality works great on my local machine. However, on our dev server it's blowing up when I try to export the grid to the body of an email in outlook.

Why is this happening?

Error: System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {0006F03A-0000-0000-C000-000000000046} failed due to the following error: 80040154. at pricing_refresh_RefreshSummary.SendMail(Stream msOffers) at pricing_refresh_RefreshSummary.RadGrid1_GridExporting(Object source, GridExportingArgs e) at Telerik.Web.UI.RadGrid.OnGridExporting(GridExportingArgs e) at Telerik.Web.UI.Grid.Export.TableViewExporter.ExcelExportRenderForm(HtmlTextWriter nullWriter, Control form) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) at Telerik.Web.UI.Grid.Export.TableViewExporter.ExcelExportRenderPage(HtmlTextWriter nullWriter, Control page) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Page.Render(HtmlTextWriter writer) at System.Web.UI.Adapters.ControlAdapter.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at Telerik.Web.UI.RadAjaxControl.RenderPageInAjaxMode(HtmlTextWriter writer, Control page) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Page.Render(HtmlTextWriter writer) at System.Web.UI.Adapters.ControlAdapter.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace --- at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.pricing_reports_refreshsummary_aspx.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Grid

answered on 19 Feb 2010

3 answers

145 views

Timeline View Height & Calendar

Hello,

As it is said by another user in this thread : http://www.telerik.com/community/forums/aspnet-ajax/scheduler/timeline-view-height.aspx
I am not able to fix the height of the scheduler in timeline view without feeding it with data. So, I cannot see the whole popup calendar to choose a specific date.

Do you know additionnal information on the corrective release date ?
Are there any workaround to get through this ? (I do not want to hide the timeline link)

Scheduler

answered on 19 Feb 2010

1 answer

132 views

Scheduler is slow to load

Hi
Not sure if there is any help you can give me but here goes.

I have a scheduler which loads a number of different resources with different appointments on each resources. There can be up to 20 resources loading in the scheduler but not always. Sometimes only 4.

For a number of our clients the scheduler takes a while to load. Upto 30 seconds sometimes. Is there anyway we can speed this loading up? Some way of deferring the load of scripts or something?

Any ideas would be great
Thanks
Jon

Scheduler

answered on 19 Feb 2010

1 answer

110 views

RadScheduler - columns unaligned

Hi,
I'm having a problem with the RadScheduler, there are several columns, with the first column representing people. However when these people have nothing in the schedule for a particular week then the Scheduler becomes un-aligned. This works fine in firefox, however it I.E 8 the grid lines become offset as you can see in the attached document.

Please help

Robert

Scheduler

answered on 19 Feb 2010

1 answer

155 views

[Solved] FileExplorer Bug?

Hello, I have the latest FileExplorer version (trial).
I want to use a simple FileSystem explorer.
If I set the InitialPath, ViewPaths, UploadPaths, DeletePaths in code (c#), like this
--------------------------------------------------------------------------------

string

path = "~/Fisiere/";

RadFileExplorer1.Configuration.ContentProviderTypeName =

typeof(FileSystemContentProvider).AssemblyQualifiedName;

RadFileExplorer1.InitialPath = path;

RadFileExplorer1.Configuration.ViewPaths =

new string[] { path };

RadFileExplorer1.Configuration.UploadPaths =

new string[] { path };

RadFileExplorer1.Configuration.DeletePaths =

new string[] { path };

RadFileExplorer1.EnableOpenFile =

true;

RadFileExplorer1.EnableCopy =

true;

RadFileExplorer1.DisplayUpFolderItem =

true;

RadFileExplorer1.AllowPaging =

true;

RadFileExplorer1.EnableCreateNewFolder =

true;
-----------------------------------------------------------------------------------------
it doesn't work (I can't upload, delete, create folder)

but if I set these properties like this:
-----------------------------------------------------------------

<telerik:RadFileExplorer ID="RadFileExplorer1" Runat="server">

<Configuration ViewPaths="~/Fisiere/" UploadPaths="~/Fisiere/"

DeletePaths="~/Fisiere/" /> </telerik:RadFileExplorer>

----------------------------------------------------

it works. I want to be able to set these properties in code (read from web.config)
Thank you.

FileExplorer

answered on 19 Feb 2010

1 answer

100 views

Customizing slider tick positions

Hi,

I had created Rad Slider with custom skinning. The problem is, i am not able to position slider tick items directly above the text. At present the text is positioned between two ticks. I am attaching(radslider_01.jpg) the screen shot on my requirement. Please help.

Slider

answered on 19 Feb 2010

1 answer

119 views

Customizing slider tick positions

Hi,

I had created Rad Slider with custom skinning. The problem is, i am not able to position slider tick items directly above the text. At present the text is positioned between two ticks. I am attaching(radslider_01.jpg) the screen shot on my requirement. Please help.

Slider

answered on 19 Feb 2010

0 answers

102 views

Raise sql triggers in asp.net

how can i raise an event in asp.net when i insert one row in sql server using triggers?.
how can i do this??? any ideas...please....

General Discussions

asked on 19 Feb 2010