Access The Group Of A Linq Group - By Query From A Nested Repeater Control?

Mar 26, 2010

I'm using a linq group by query (with two grouping parameters) and would like to use the resulting data in a nested repeater.

var dateGroups = from row in data.AsEnumerable()
group row by new { StartDate = row["StartDate"], EndDate = row["EndDate"] };
"data" is a DataTable from an SqlDataAdapter-filled DataSet. "dateGroups" is used in the parent repeater, and I can access the group keys using Eval("key.StartDate") and Eval("key.EndDate").

Since dateGroups actually contains all the data rows grouped neatly by Start/End date, I'd like to access those rows to display the data in a child repeater. To what would I set the child repeater's DataSource? I have tried every expression in markup I could think of; I think the problem is that I'm trying to access an anonymous member (and I don't know how.) In case it doesn't turn out to be obvious, what would be the expression to access the elements in each iteration of the child repeater? Is there an expression that would let me set the DataSource in the markup, or will it have to be in the codebehind on some event in the parent repeater?

View 3 Replies

Similar Messages:

DataSource Controls :: LINQ Query To Grab The Last 5 Rows From A Group?

Jan 8, 2010

i have the following objects:


- EventID (PK)
- GroupID (FK)
- StartDate


- GroupID (PK)
- GroupName

What i need to do is select the last 5 events for each group using LINQ to Objects. I tried starting with:


But i'm not sure how i only take the last 5 per group.

The simple way of doing this is to get the groups and then have a property on that which returns the last 5 events but if i databind this i will have to use a nested Repeater/ListView. Ideally i would like to have a row foreach event.

View 3 Replies

ADO.NET :: How To Access The Grouping Resulted From A Entity Framework Query With Group

Mar 26, 2011

I'm currently learning entity framework (from the Julia Lerman book "Programming Entity Framework") and got really confused at the grouping part.

var contacts = from c in context.Contacts
group c by c.Title into myGroup
select myGroup;

This is supposed to return a Grouping<K,T> type, but the book didn't give an example on how exactly do I access this "contacts" query and I can't figure it out. When I did foreach(var contact in contacts), my "contact' variable has no knowledge of any of the properties of the Contact type (contact.FirstName etc).

View 1 Replies

Forms Data Controls :: Using A Nested Listview To Display A Seperate Grid For Each Group Of Data Returned From Db Query

Jan 13, 2011

I am using a nested listview to display a seperate grid for each group of data returned from my db query. To get this working, I have adapted a piece of code to group the data prior to it being bound:


I am then using the following html markup:



This works as I want it to however some of the fields within the nested table need to be formatted as currency so I am trying to use Eval and {0:c} to do this however the moment I use Eval, the data items cannot be found

DataBinding: 'System.Data.DataRow' does not contain a property with the name '0'.

View 4 Replies

C# - Select DataTable (only Some Values) From _GetDisplayData And GROUP Data By Days Where Group Rules Is Different For Different Columns

Mar 4, 2010

Stack-Overflow :3 I've got a kind of hard-case question.

So I'll try clearly explain my idea with my poor english :/ need select to DataTable SOME values from ???_**GetDisplayData **procedure for each day of previos month (GROUP IT) where group rules for different columns is different

I need to select some values in stored procedure from other stored procedure like this :

SELECT X FROM Y_Procedure(@ProcedureParameters)Also I need to select from dynamic SQL Procedure like

SELECT X FROM Y_Procedure(@ProcedureParameters)

Also I need to load it to DataTable :-/INSERT INTO @Report (CellHorizontal, CellVertical, CellValue) --to TABLE
SELECT Date,X2,X3 FROM Y_GetDisplayData(@Param)

FROM @Report

GetDisplayData works as select with parameters and that doesn't returns SQL DataTable
And there is no way to recode GetDisplayData's procedures, it's just constant procedures for me.Finally I need to Group nodes from this table

INSERT INTO @Report (CellHorizontal, CellVertical, CellValue)
IF ((Select grouptype...)=1) T1.X2 + T2.X2
ELSE IF ((Select grouptype...)=2) AVG(T1.X2,T2.X2),
IF ((Select grouptype...)=1) T1.X3 + T2.X3
ELSE IF ((Select grouptype...)=2) AVG(T1.X3,T2.X3),
(SELECT T2.Date,X2,X3 FROM Y_GetDisplayData(@Param) T2
WHERE T2.Date>T1.Date AND T2.Date>=T1.Date)
FROM Y_GetDisplayData(@Param) T1
GROUP BY EVERY DAY ???--and here is epic fail

I can make all stuff on asp server :And C# allows me to use something like SelectCommand = IzmProc + "_GetDisplayData"; And then I will work (select special data) with DataTables on ASP.NET Server but it's better to make all on SQL ... But looking like it's just unrealizable on SQL >_<

I gonna think about C# realization,but my code is very weird , got errors and doesn't works >_<

public static DataTable GetReport(string Param)
System.Configuration.ConnectionStringSettings connSetting = ConfigurationManager.ConnectionStrings["FlowServerConnectionString"]; [code].....

View 3 Replies

How To Check Whether A User Belongs To An AD Group And Nested Groups

Apr 21, 2010

I have an ASP.NET 3.5 application using Windows Authentication and implementing our own RoleProvider.

Problem is we want to restrict access to a set of pages to a few thousand users and rathern than inputing all of those one by one we found out they belong to an AD group.

The answer is simple if the common group we are checking membership against the particular user is a direct member of it but the problem I'm having is that if the group is a member of another group and then subsequently member of another group then my code always returns false.

For example: Say we want to check whether User is a member of group E, but User is not a direct member of *E", she is a member of "A" which a member of "B" which indeed is a member of E, therefore User is a member of *E"

One of the solutions we have is very slow, although it gives the correct answer

using (var context = new PrincipalContext(ContextType.Domain))
using (var group = GroupPrincipal.FindByIdentity(context, IdentityType.Name, "DL-COOL-USERS"))
var users = group.GetMembers(true); // recursively enumerate
return users.Any(a => a.Name == "userName");

The original solution and what I was trying to get to work, using .NET 3.5 System.DirectoryServices.AccountManagement and it does work when users are direct members of the group in question is as follows:

public bool IsUserInGroup(string userName, string groupName)
var cxt = new PrincipalContext(ContextType.Domain, "DOMAIN");
var user = UserPrincipal.FindByIdentity(cxt, IdentityType.SamAccountName, userName);
if (user == null)
return false;
var group = GroupPrincipal.FindByIdentity(cxt, groupName);
if (group == null)
return false;
return user.IsMemberOf(group);

The bottom line is, we need to check for membership even though the groups are nested in many levels down.

View 3 Replies

ADO.NET :: Create SQL Into LINQ - Group By

Jan 25, 2011

I want to create a LINQ SQL-Group-Query... This is my LINQ-Query:


I want to Group this, like this normal SQL-Query do it?


Furtermore, when iam using this normal sql query the programm needs a Type .. for example Dim reqdata(of Iqueryable(of xxx)("sql query...") ... whats the Type of this ? When i select more tables than ones ? there is said thats <anonymous type> ?

View 1 Replies

ADO.NET :: Group By Date In Linq?

Mar 28, 2011

I've a table with datetime null field in sql server. I'm trying to group the results based on the year in that field. But, when I wrote linq query, I didn't get intellisense for Year when I type that field. It only shows HasValue and Value. I think because it is converted nullable type. How do I do the grouping in this case?

View 5 Replies

C# - SQL Group By Column Value In LINQ?

Jun 25, 2010

I am trying to translate this:

SELECT IDNum, Max(Convert(varchar(20), (TimeOut - TimeIn), 108))
FROM IO_Times Group by IDNum
order by Max(Convert(varchar(20), (TimeOut - TimeIn), 108)) desc";

Into LINQ in C#. The above returns a list of the maximum value of (TimeOut-TimeIn) that corresponds to each unique IDNum (There are multiple TimeOut-TimeIn values for every IDNum).Here is what I am trying now:

from IO_Time in db.IO_Times
orderby SqlMethods.DateDiffMinute(IO_Time.TimeIn, IO_Time.TimeOut) descending
group IO_Time by IO_Time.IDNum into list
select new
ID = list.Key,
Time = list

This returns the correct IDs in the correct order, but the "list" contains everything in the database entry (which makes sense). I have also tried group by IDNum and Time, but then I get unique time entries and multiple IDs returned.I could do a foreach loop and manually sort it all out, but I would really rather not do that.

View 2 Replies

Forms Data Controls :: User Group List Like Graph / Get The List Of Users Under A Group

Oct 26, 2010

I need to develop a page in my applicaiton like the image for the user lists.

I need to get the list of users under a group and need to show likw this.

View 4 Replies

ADO.NET :: Can't Group With Linq When Join Several Tables

Dec 9, 2010

I have T_articles to save the articles.

each article has authorCode , and categoryCode.

each article can be modified by the author several times.

and I save every modification in the T_articles in a difference row.

now I want to dislpay for each autor:

author name, article name , article category's name, last modified date

In SQL I should to it like that:


I try to write it in Linq so:


so I got error:


and again I got an error:


View 4 Replies

C# - Linq - Group By Multiple Tables?

Aug 8, 2010

Using Linq to Sql how do i group the following 2 tables.

Orders Table:

CustomerID | Name |Date
1 | order1 | 2010-01-01
2 | order2 | 2010-01-01
2 | order3 | 2010-04-01

Calls Table:

CustomerID | Name |Date
1 | call1 | 2010-01-01
3 | call2 | 2010-06-01
2 | call3 | 2010-05-01

I want to group the two tables by date , Result:

Date | Orders | Calls
2010-01-01 | 2 | 1
2010-04-01 | 1 | 0
2010-05-01 | 0 | 1
2010-06-01 | 0 | 1

i know how to group a single table ,from o in Orders group o by o.Date.Date into og select new {Date = og.Key,Orders= og.Count()};

View 2 Replies

Visual Studio :: Group Profiles Settings - Users In The Group Update The Same Settings?

Jan 19, 2010

We have many different clients, and each client can have multiple user accounts.Right now, we have user settings set up on the ASP project, and a WinForms application can see these settings, depending on which user logs into the winforms application. They are specific to the user. I want to make them specific to the client, so users can be in "groups" by their client, and all users in the group would see/update the same settings.

View 1 Replies

SQL Server :: How To Group The Data Query

Dec 22, 2010

I am using SQL Server 2005. I have below table:

CompanyNo CompanyName Product


100 C1 P11

100 C1 P12

100 C1 P13

200 C2 P21

200 C2 P22


And I want my sproc returns like...



100 - C1 - P11, P12, P13

200 - C2 - P21, P22


View 3 Replies

ADO.NET :: Get Distinct Value From A Group-Join Syntax Linq?

Sep 9, 2010

I have this group-join syntax but I couldn't get the distinct value from the relational tables below.


key_1 t1_value
1 Food
2 Sports
3 Leisure
4 Trip
5 Zoo


key_2 key_1 t2_boolean
15 1 True
16 1 True
17 1 True
18 2 True
19 2 True
20 2 False

desire result:


View 3 Replies

ADO.NET :: Linq To SQL Group By Category And Count Each Subcategory?

Sep 30, 2010

I am wonder how I can generate a result table from linq to sql as below

Car sales table
Toyota small
Toyota passenger
Toyota small
Honda small
Honda small
Honda passenger
Honda small

result table
Brand small passenger total
Toyata 2 1 3
Honda 3 1 4

GridView1.DataSource = (from dtCarSales.AsEnumerable() .....

View 3 Replies

DataSource Controls :: Linq Group Cannot Get The Data Returned

Feb 8, 2010

I'm attempting to further reduce a dataset/table by various user input. Part of this process is grouping the data by a timestamp prior to a summation. I'm trying to use LINQ and cannot get the data returned that I need.


View 7 Replies

DataSource Controls :: Order By Count And Group By In LINQ?

Mar 14, 2010

How do I translate the following query into LINQ to SQL?


View 1 Replies

Forms Data Controls :: How To Make The Repeater Like Group By Col Instead Of Dispaly All Record

Feb 28, 2010

after i select data from datatabe and store to datatable finally bind to the repeater to display. but grid is always display what the datatable store there is many duplicate data appear in the repeater. i would like to show specifc col once and hidden other name which appears more than 1.

for example in repeater:

section desc seq no
A NT 1
A BT 2
A KK 3
B PP 1

then A appear more than 1. i would like to hidden A except the first record as belows:

section desc seq no
A NT 1
BT 2
KK 3
B PP 1

View 1 Replies

Datetime Column Messes Whole Query Up When Inserted Into Group By

Jan 18, 2011

We have a webservice which stores data in sql server 2008R2.I am trying to build a billing system and struggling with the next sql query.

* X.UnitPrice)
AS ExtendedPrice

View 15 Replies

Active Directory/LDAP :: LDAP Query To Check If An User Is In A Group Or Not. Creation Of A Portal | Query = Null

Jul 7, 2010

I'm working on a portal, and I need to check users conection on the ldap.

And if users are members of a special group then it works.

I've exactly used this link to make it works : (almost work)

My point is : my ldap path seems good, no error anymore, when I log with my username and password.But when I querry it, it returns null, but I'm sure my user is in the group :

// Bind to the native AdsObject to force authentication. Object obj = entry.NativeObject; DirectorySearcher search = new DirectorySearcher(entry); search.Filter = "(SAMAccountName=" + username + ")"; search.PropertiesToLoad.Add("cn"); SearchResult result = search.FindOne(); if(null == result) { return false; }

I'm a normal user, i test with my account. I'm a member of the group that I'm looking for.

View 8 Replies

ADO.NET :: Object Must Implement IConvertible Error In LINQ To Entities With Group By?

Oct 25, 2010

down vote

View 2 Replies

C# - How To Allow Only A Group Of IPs Access The Site From Code Behind

Jan 11, 2011

I have this website where I want just only the computers in our office have access to it. How can I write code to do this? I've been looking all over the web but I couldn't find anything like this. Sorry I couldn't write any code about this before posting this question.I will be using this part of code in the header.aspx file.

View 4 Replies

Forms Data Controls :: Group Data,- The Group's Header Be On The Top ?

Feb 5, 2010

I'd like to gruop data from a table, for example, by DATE or CATEGORY, something like this:
News 1
News 2
News 3

News 1
News 2
News 3

or group by CATEGORY, like this:

News 1
News 2
News 3

News 1
News 2
News 3

View 4 Replies

DataSource Controls :: Change File Group Using Alter Table Query?

May 6, 2010

I have a table that contains image data type and has more than 20,000 records.I want to change its file group to the new file group. I tried to change it using table designer, but everytime I wanted to save it, it occured an error with this message:


Does anyone know how to change file group using Alter Table query? I'm using SQL Server 2005.

View 2 Replies

Copyrights 2005-15, All rights reserved