Want to build the ChatGPT based Apps? Start here
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
diamond diamond
2.1k
133
52.2k
Compute average via linq after group
Oct 24 2014 5:10 AM
Hi
I have a such a code blew, I want after grouping, acquire average of duration variable.
var qry = from dr in dt.AsEnumerable()
group dr by new { source = dr["saddr"] } into rowsGroup
select new
{
saddr = rowsGroup.Key,
value = rowsGroup,
daddr = rowsGroup.Count(),
dport = string.Join(",", rowsGroup.Select(av => av["dport"].ToString()).ToList()),
dstip = string.Join(",", rowsGroup.Select(aj => aj["CDaddr"].ToString()).ToList()),
duration = string.Join(",", rowsGroup.Select(av => av["dur"].ToString()).ToList()),
bytes = string.Join(",", rowsGroup.Select(av => av["bytes"].ToString()).ToList()),
pkt = string.Join(",", rowsGroup.Select(av => av["pkts"].ToString()).ToList())
};
Reply
Answers (
4
)
C# SQL Select from multiple tables
Random number Generator