Telerik Forums
UI for ASP.NET AJAX Forum
5 answers
387 views

I’m using RadGrid for ASP.NET AJAX with LinqDataSource.

I’m amazed with amount of functionality I can accomplish in this combination with just declarative programming in ASCX and without single line in code behind.

What I really like is that sorting and paging is done on SQL server. Here is example of T-SQL I got from SQL Server Profiler:

exec sp_executesql N'SELECT [t1].[Id], [t1].[ParentId], [t1].[Name]
FROM (
    SELECT ROW_NUMBER() OVER (ORDER BY [t0].[Name]) AS [ROW_NUMBER], [t0].[Id], [t0].[ParentId], [t0].[Name]
    FROM [dbo].[Things] AS [t0]
    ) AS [t1]
WHERE [t1].[ROW_NUMBER] BETWEEN @p0 + 1 AND @p0 + @p1
ORDER BY [t1].[ROW_NUMBER]',N'@p0 int,@p1 int',@p0=8,@p1=8
 

Now, I would like to utilize RadGrid filtering with AllowFilteringByColumn="True".

When I execute some filter I got this T-SQL code in SQL Profiler:

SELECT TOP (2147483647) [t0].[Id], [t0].[ParentId], [t0].[Name]
FROM [dbo].[Things] AS [t0]
ORDER BY [t0].[Name]

This means that in this case filtering and paging is not done by SQL server, but on web server with in RadGrid control. In this case it is possible that huge amount of rows is sent form SQL to web server and I would like to avoid this too. (I see that with canretrievealldata="False" I can preserve SQL Server paging, but in this case filtering is preformed only over current page, so this is not a solution for me.)

If I understand correctly by default data filtering is executed with in RadGrid control with LINQ.

I would like to use LINQ to SQL for this in my project because I think it is more optimal.

Do I miss something here?

What is best way to accomplish use of LINQ to SQL with RadGrid for ASP.NET AJAX and LinqDataSource for filtering also?

Rosen
Telerik team
 answered on 29 Apr 2008
2 answers
156 views

Exception of type 'System.OutOfMemoryException' was thrown.

can anyone gve me the reason for this error. While i m using 3 level her. RadGrid

Nikhil
Top achievements
Rank 1
 answered on 29 Apr 2008
5 answers
325 views

For some reason if I define the ClientCallBack function of a window with java script it does not execute, If I define the same function as the client call back function of the RadWindowManager it operates properly.

 

            var radWindow = window.radopen(url, null ); 

            radWindow.SetTitle(title);

            radWindow.ClientCallBackFunction = "PCEReturn";

            alert(radWindow.ClientCallBackFunction);

Any thoughts?

Kyle

Georgi Tunev
Telerik team
 answered on 29 Apr 2008
1 answer
101 views
Hello,

I create RadGrid dynamically in OnInit. Everything seems to be fine. But I need to store data source in ViewState. This turns to be impossible due to that fact that it is not loaded at this stage (only after OnInit). How can be this accomplished?
Yavor
Telerik team
 answered on 29 Apr 2008
1 answer
143 views
I ran into an interesting issue this morning that I could use an opinion on.

I have the following event defined to fire OnClientNodeChecking:

function AfterClientCheck(sender, eventArgs)
{
 var node = eventArgs.get_node(); 
 var secondTreeView = $find('RadTreeView4');
 secondTreeView.get_nodes().add(node);
}

The code is supposed to make a copy of a node from one treeview and add it to a second treeview.

Only it doesn't just Add it, it actually MOVES it from one treeview to the other.

Is this by design?

Anyway, the solution I found to work around this issue is to create a new node:

var node3 = new Telerik.Web.UI.RadTreeNode();
node3.set_text(node.get_text());
secondTreeView.get_nodes().add(node3);

Thanks, Mitch
Veselin Vasilev
Telerik team
 answered on 29 Apr 2008
2 answers
93 views
Hi,

Did you know that findItemByValue isn't in the online documentation, but actually works for the toolbar.

I don't want text on the button, so cant use findItemByText

Regards

Bobby
Shinu
Top achievements
Rank 2
 answered on 29 Apr 2008
1 answer
243 views
I've got a splitter which contains a radgrid in one pane and a radtreeview in the other. I have a function which resizes the splitter when certain controls are clicked (using radajaxmanager). This works fine but there is a delay between the loading being done and the splitter resizing and becoming accessible (there are many images in the grid, it appears to be frozen until all of the images have loaded although I am not 100% what it is waiting for).

Is there anyway to have the grid resize immediately? I did see a post referring to putting the pane contents in a certain div, however this didn't work. I'm using the release (latest) version of radcontrols for asp.net ajax.
Ubong
Telerik team
 answered on 29 Apr 2008
1 answer
134 views
Hi,
I wanted to know if there's an easy way to disable the entire tree, on the client side, without traversing it node by node.
What I actually need is a way to stop the user from clicking another node in the tree, after clicking a certain node. The node click causes another pane to load, and during the page load I want the tree to "wait". If there's another way to provide the same functionality, I'd be happy to hear about it.

Thanks!
Nir.
Veselin Vasilev
Telerik team
 answered on 29 Apr 2008
1 answer
98 views
Am in right in saying that the online documentation is wrong for a toolbar button? It says "check" and "uncheck" but it appears to be "check" and "unCheck"

Regards

Bobby
Helen
Telerik team
 answered on 29 Apr 2008
2 answers
130 views
<telerik:RadSplitBar ID="RadSplitbar" runat="server" CollapseMode="None" SkinID="Telerik">

I already set the SkinID="Telerik", but nothing change.
Please tell me how to solve this probem.
Mnay thanks for your replying.
Vinix
Top achievements
Rank 1
 answered on 29 Apr 2008
Narrow your results
Selected tags
Tags
+? more
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?