Post New Web Links

Linq to SQL GroupBy with Nested Repeaters

Posted By: Posted Date: September 02, 2010 Points: 0 Category :ASP.Net

Hello, After a few hours of searching I couldn't find a solution to this issue so I figured I'd try a post. I have stored procedure that queries 3 tables and retuns 1 set of results. When I execute the sproc using the following code db.GET_TRAININGS(userID).GroupBy(s=>s.COURSE_TITLE); I get back an IGrouping container where the course title is the key and contains 2 GET_TRAINING_RESULT elements. Then I bind using rptCourses.DataSource=trainings; then databind(),etc. What I'm trying to do is have the parent repeater show the course titles and the nested repeater show the modules for that course for the particular logged in user. Basically trying to turn a flat piece of data into heirchical data. The stored procedure returns the following SQL Columns Course_Title, Module_Path, Module_Name,Sequence. The sproc code is below: SELECT C.COURSE_TITLE, B.MODULE_PATH, B.MODULE_NAME, B.SEQUENCE FROM USER_ACCESS A JOIN MODULES B on A.MODULE_ID = B.MODULE_ID JOIN COURSES C on B.COURSE_ID = C.COURSE_ID WHERE A.USER_ID= @USER_ID AND A.EXPIRATION_DATE > GetDate() ORDER BY B.SEQUENCE The repeaters look like this of course:<asp:Repeater runat="server" ID="rptCourses" EnableViewState="false"> <ItemTemplate> <div> &l

View Complete Post

More Related Resource Links

Nested Linq in form of sublists

Hi,I am new here, so do not have much background knowledge about linq. Is it possible to form a nested query to retrieve the DB data in the form of list of lists? For example, if given a blog role, and several comments within it, is it possible to retrieve the list of blogs, along with lists comments without doing a flat join operation?The Model (I am using MVC2 for the implementation) to be fetched would look somewhat like this: public class BlogXtraModel { public Models.Blog BlogInstance { get; set; } public List<Models.Comment> CommentList { get; set; } }and I would like to retrive the data on these lines: var blogs = from b in { .... } select b as BlogInstance, List<Comment> as CommentListI need suggestions/help figuring out what might go in place of the dots, if such an approach is supported. PS: Even though, this is a simple example of blogs and comments, I need to implement a similar structure (one to many relations) which is 5 levels deep, and would have tonz of data on each level. Doing a 5-level join seems very wasteful and ineffecient for the bandwidth as well as front end formatting. Hence, this question. Thanks in advance for the help

How to bind GroupBy Values in Nested Repater Control

In a dataset i m getting values like this

IdApplication ApplicationDesc Permissions

1 User Add

1 User Delete

1 User Update

2 Role Add

2 Role&n

Asynchronously Load LINQ Queries/Repeaters in Sections with Web Service

Hello,

I'm trying to figure out the best way to load my main page faster. What I'd like to do is have the bare bones of the master page display right away and on the Default.aspx Page_Load, call some web services that would query the rest of the items, in chunks, and then display. I have 3 or 4 queries, which would be the chunks I am talking about.

How would I accomplish this? I tried putting Update Panels around the repeaters, but that didn't make the page show any faster, and the page still only displayed once all the data was queried.

I found this article, http://msdn.microsoft.com/en-us/library/2e08f6yc.aspx. Could I call a web service and return a Linq Query and populate a Repeater on Default.aspx? Would I need an Update Panel around the Repeater still?

I also found this article, which was very interesting in that it parsed and returned the actual HTML to plug into the page, http://encosia.com/2008/02/05/boost-aspnet-performance-with-deferred-content-loading/.

I've been reading both of these for a while to try to understand which may be the best method to proceed with. I'd really appreciate any a

Playing with Linq grouping: GroupByMany?

One of its features is grouping. Many people understand grouping like it is defined in Sql. Linq is implementing grouping quite the same way. Let's discover this syntax and how to make consecutive groups easier.

LINQ : Implementing IN and NOT IN

I got tried of typing

var result = from s in source
where items.Contains(s)
select s;and so I implemented the IN and NOT IN methods as extension methods:

101 LINQ Samples Tutorials

101 LINQ Example with sample code snippets....This sample prints each element of an input integer array whose value is less than 5. The sample uses a query expression to create a new sequence of integers and then iterates over each element in the sequence, printing its value

Linq: how to share parameters between lambda expressions ?

When using Linq to objects, you will quickly feel the need to pass some parameters from a method to another but it's not so easy because each Linq method is not calling the following one. In a Linq sequence, each method is using the result computed by the previous one. So, local contexts are not visible from one method to another.
The compiler is using two technical different ways to let parameters go out of a method.

Linq to Sql CompiledQuery container

Ok now let's go. Here is just a little trick but with some interesting patterns that could be useful in some other contexts not connected to Linq to Sql.

When using Linq expressions, like with Linq to Sql, translating the expression into something else (sql for example) is taking time and resources. Sometimes it's negligible, sometimes not...

LINQ to SQL Paging using GridView in C# and ASP.NET 3.5

This tutorial will show you how we can extend the LINQ to SQL Class and create methods that will allow us to page data from a SQL database. C# version.

What is Lambda Expressions In LINQ

A lambda expression is an anonymous function that can contain expressions and statements, and can be used to create delegates or expression tree types.

All lambda expressions use the lambda operator =>, which is read as "goes to". The left side of the lambda operator specifies the input parameters (if any) and the right side holds the expression or statement block. The lambda expression x => x * x is read "x goes to x times x." This expression can be assigned to a delegate type as follows:

How to create 3 tier application using LINQ

As you know that in 3 tier architecture there are three layers

User interface layer. (Is our Form in Windows application and .aspx page in Web application)
Data Access layer. (Which provides interface between Business logic layer and Database)
Business Logic layer.(Which stores your application logic)

Building a LINQ Provider

Throughout this article, we will build a simple IQueryable provider similar to the LINQ to SQL provider demonstrating what is needed to build a custom provider that is capable of executing LINQ queries and performing create, update and delete operations.

LINQ to SQL Performance Considerations

As developers we have a wide array of tools at our disposal. One of the most time consuming, but most beneficial tasks we must undertake is to determine which of those tools to use for a given situation.

Passing Linq Statement between master and content page

I usually work with windows forms, and am just starting to work with ASP.Net, so appologies if this is a dumb question!

I have a master page which has a search button on it. The results of this are built up using a Linq statement and if there are any results, I want to display the results in a contents page.

On the masterpage, I have the following code:

Private _res

    Public Overridable ReadOnly Property SearchRes()
        Get
            Return _res
        End Get
    End Property

 Private Sub DoSearch()
   'some code to get a linq result
   'then

    If res.Any Then
            _res = res
            Server.Transfer("SearchResults.aspx", True)
        Else
            'no results
            LabelNoRes.Visible = True
        End If
 End Sub

On the SearchResults.aspx page I have this code.

Dim m As pxSite = CType(Page.Master, MasterPage)
        If m.SearchRes IsNot Nothing Then
            Label1.Text = "Results found = " & m.SearchRes.Count
        End If

m.searchRes is always nothing.

What am I doing wrong here?

Thanks

Binding Nested Listviews in MVC ViewPage

I am a longtime .NET developer but for big applications and services. This is my first asp.net project and I have chosen MVC. I have a need for nesting a ListView within a ListView. In this simple catalog app, I have EF 4 Entities that are Categories, SubCategories, ItemTypes, and Items.

My goal is to display a 5 column layout of SubCategories with their ItemTypes below them in a ViewPage. I did just fine with it done out in C# as server directives such as:

    var subcats = Model.SubCategory.ToArray();
    var nrSubCats = subcats.Count();
    var rows = (nrSubCats/5) + (((nrSubCats % 5) > 0) ? 1 : 0);
    for (var row = 0; row < rows; row++)
    { %>
        <div style="width: 100%; float: left; clear: right;">
        <%
        var start = row * 5;
        for (var i = start; (i < start + 5) && (i < nrSubCats); i++)
        {
        var subcat = subcats[i];
        %>
            <div style="float: left; clear: right; width: 20%; margin-left: 5;">
                <h2> <%:subcat.Name%></h2>
                <ul>
                    <%
                    foreach (var its in subcat.ItemType)
                    {%>
                        <li>
                            <%:Html.

MVC2 issue - Stuck. Trying to create a cms with nested partials

I am currently trying to display multiple items on a single page. I am not sure as to how to tackle this. What I have is a database table that has all the page data in. I have this run as a PagesController and this works fine. However what I would like to do is, if say the Products page is selected via the menu, I want to pull back not only the Products page html but also get all the products, and even be able to pull them through via category. I was trying to use a partial view, but I can't get it to work. The same would be for other pages, having partial views to display the other content, ie if Gallery is selected, the page html for Gallery shows and it then can push to a partial view that pulls all the gallery images from the gallery db table and so on.

Maybe I am tackling this the wrong way. I have the pages stored in the db to allow for a CMS system I have setup. Maybe I need to use models for all the other items(Products, Gallery, Videos and such) and use the partial for the page html?

Any help would be greatly appreciated as I am confused.

Linq - add data to database then email user the details

Hi all

I'm not sure how to structure the code for this but what I want to do is be able to add data to a database, and once this has completed successfully, then email the user to say the details have been added successfully to the database.

I need to:

1. Check that the relevant data has been added into the database then

2. Email the details of the relevant data when completed.

Thanks in advance for your help,

Laura


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All