Archive

Archive for the ‘Silverlight’ Category

Using LINQ to get roll-up data from SharePoint List (DataSet, DataTable, Excel, etc.)

September 27, 2013 Leave a comment

Hey Guys,

You may find lots of topics and questions posted by [Me] onto the internet for this particular question.

How to use LINQ to get roll-up data?

So, here is the scenario.

I have one SharePoint List as below (you can make DataSet, DataTable, Excel anything you want)

ColumnA     ColumnB      Status

Project1      Task1.1           Completed
Project1      Task1.2           Pending
Project1      Task1.3           Completed
Project2      Task2.1           Completed
Project3      Task3.1           Completed
Project3      Task3.2           Completed
Project3      Task3.3           Completed
Project3      Task3.4           Pending
Project3      Task3.5           Pending

What I need from the above data is:

Project1 66.67 ((Completed Task / Total Task) * 100)
Project2 100
Project3 60

So basically, all I am looking for is rolling up the data and finding the total percentage of project completion.

Easy, huh?

Let’s see, so here’s the code: (Thanks to Paul Choquette)

var returndata = (from geo in dt.AsEnumerable()

orderby geo["ColumnA"] descending

group geo by geo["ColumnA"] into itemgroup

select new

{

Project = itemgroup.Key,

Percentage = (double)itemgroup.Count(i => (string)i["Status"] == “Complete”) / (double)itemgroup.Count() * 100,

}).ToList();

That’s it!!

Let me know in case you want anything more from this code ;)

Have fun!!

E-Book Gallery for Microsoft Technologies

Download content for ASP.NET, Office, SQL Server, Windows Azure, SharePoint Server and other Microsoft technologies in e-book formats. Reference, guide, and step-by-step information are all available. All the e-books are free. New books will be posted as they become available at here

E-Books in English

Lync Microsoft Lync Server 2013 Step by Step for Anyone 
Office Deployment guide for Office 2013
First Look: Microsoft Office 2010
Microsoft Office 365: Connect and Collaborate Virtually Anywhere, Anytime
Microsoft Office 365 for professionals and small businesses: Help and How To
Security and Privacy for Microsoft Office 2010 Users
SharePoint Explore SharePoint 2013
Deployment guide for SharePoint 2013
Create a Balanced Scorecard
Configure Kerberos Authentication for SharePoint 2010 Products
SharePoint Server for Business Intelligence
Get started with SharePoint Server 2010
Deployment guide for SharePoint Server 2010
Upgrading to SharePoint Server 2010
Profile synchronization guide for SharePoint Server 2010
Remote BLOB storage for Microsoft SharePoint Server 2010
Governance guide for Microsoft SharePoint Server 2010
Business continuity management for SharePoint Server 2010
Technical reference for Microsoft SharePoint Server 2010
SQL Server 5 Tips for a Smooth SSIS Upgrade to SQL Server 2012
A Hitchiker’s Guide to Microsoft StreamInsight Queries
Books Online: Backup and Restore of SQL Server Databases
Books Online: Data Analysis Expressions (DAX) Reference
Books Online: Data Mining Extensions (DMX) Reference
Books Online: Data Quality Services
Books Online: High Availability Solutions
Books Online: Master Data Services
Books Online: Monitor and Tune for Performance
Books Online: Multidimensional Expressions (MDX) Reference
Books Online: SQL Server Distributed Replay
Books Online: Transact-SQL Data Definition Language (DDL) Reference
Books Online: Transact-SQL Data Manipulation Language (DML) Reference
Books Online: XQuery Language Reference
Extracting and Loading SharePoint Data in SQL Server Integration Services
Introducing Microsoft SQL Server 2008 R2
Introducing Microsoft SQL Server 2012
Master Data Services Capacity Guidelines
Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery
Microsoft SQL Server Analysis Services Multidimensional Performance and Operations Guide
Optimized Bulk Loading of Data into Oracle
Planning Disaster Recovery for Microsoft SQL Server Reporting Services in SharePoint Integrated Mode
QuickStart: Learn DAX Basics in 30 Minutes
SQL Server 2012 Tutorials: Analysis Services – Data Mining
SQL Server 2012 Tutorials: Analysis Services – Multidimensional Modeling
SQL Server 2012 Tutorials: Analysis Services – Tabular Modeling
SQL Server 2012 Tutorials: Reporting Services
SQL Server 2012 Tutorials: Writing Transact-SQL Statements
SQL Server 2012 Upgrade Technical Guide
SQL Server Community FAQs Manual
Visual Studio Moving to Microsoft Visual Studio 2010
Upgrade Team Foundation Server 2012: the ultimate upgrade guide
Web Development Deploying an ASP.NET Web Application to a Hosting Provider using Visual Studio
Developing Modern Mobile Web Apps
The Entity Framework 4.0 and ASP.NET Web Forms – Getting Started
Getting Started with ASP.NET 4.5 Web Forms (Beta)
Getting Started with the Entity Framework 4.1 using ASP.NET MVC
Intro to ASP.NET MVC 4 with Visual Studio (Beta)
Introducing ASP.NET Web Pages 2
Project Silk: Client-Side Web Development for Modern Browsers
Windows Deploying Windows 7: Essential Guidance
Programming Windows 8 Apps with HTML, CSS, and JavaScript
Windows Azure Autoscaling Application Block and Transient Fault Handling Application Block Reference
Building Elastic and Resilient Cloud Applications – Developer’s Guide to the Enterprise Library 5.0 Integration Pack for Windows Azure
Building Hybrid Applications in the Cloud on Windows Azure
Create Your First Application – Node.js and Windows Azure
Drupal on Windows Azure
Migrating Data-Centric Applications to Windows Azure
Moving Applications to the Cloud, 2nd Edition
Using Windows Azure Mobile Services to Cloud-Enable your iOS Apps
Using Windows Azure Mobile Services to Cloud-Enable Your Windows Phone 8 Apps
Using Windows Azure Mobile Services to Cloud-Enable your Windows Store Apps in C#
Using Windows Azure Mobile Services to Cloud-Enable Your Windows Store Apps in JavaScript
Windows Azure and SQL Database Tutorials
Windows Azure Prescriptive Guidance
Windows Azure Service Bus Reference
Windows Phone Developing an Advanced Windows Phone 7.5 App that Connects to the Cloud
Programming Windows Phone 7
Windows Server A Guide to Claims-Based Identity and Access Control, Second Edition
Introducing Windows Server 2008 R2
Introducing Windows Server 2012
Understanding Microsoft Virtualization Solutions: From the Desktop to the Datacenter, Second Edition
Career Own Your Future: Update Your Skills with Resources and Career Ideas from Microsoft

Pluralsight for MSDN Subscribers Worldwide

October 17, 2012 Leave a comment

Back in June,  Pluralsight announced a special training benefit for MSDN designed to provide MSDN subscribers with access to 20 of their most popular courses.

Previously only available in the US, today they’re expanding this benefit to MSDN subscribers worldwide through December 11, 2012. Now you can access this benefit across the globe, regardless of location! See the notes below on who is eligible.

Based on our feedback, they’ve also worked with Microsoft to enhance this custom 12 month training subscription with several new Visual Studio 2012 courses.

The Pluralsight Starter Subscription for MSDN now contains 25 popular courses. The five new courses they added include:

  • Introduction to Visual Studio 2012 – Part 1
  • ALM with TFS 2012 Fundamentals
  • ALM for Developers with Visual Studio 2012
  • Microsoft Fakes Fundamentals
  • Intelllitrace

They’ve simply added these new titles to the original set of courses made available in June. If you’ve already taken advantage of this offer, you don’t have to do anything to get these – you’ll see the new courses show up in your account next time you login to Pluralsight.

 

 

 

To take advantage of this limited-time training benefit, redeem your Pluralsight Starter Subscription for MSDN by December 11, 2012:

Verify your MSDN subscription and register!

Feel free to download this PDF describing the benefit and email it to your friends and coworkers so they can take advantage of this offer too.

The Pluralsight Team hope we enjoy this MSDN training benefit!


Who is not eligible for this offer?

Large collection of Free Microsoft eBooks for you, including: SharePoint, Visual Studio, Windows Phone, Windows 8, Office 365, Office 2010, SQL Server 2012, Azure, and more by Eric Ligman

Throughout the year Eric has tried to share resources and information with us that he think will be helpful for us. Often times these resources will include links to free eBooks that they make available on a variety of topics. Today, Eric thought he would post a large collection of eBooks for us on his blog so that we can find them in one place and consume them as we see fit. Also, if you find this list helpful, please share it with your peers and colleagues so that they too can benefit from these resources.

 

image
Moving to Microsoft Visual Studio 2010
image
Programming Windows 8 Apps
image
Programming Windows Phone 7
image
Programming Windows Phone 7 (Special Excerpt 2)
image
Office 365 – Connect and Collaborate virtually anywhere, anytime
image
Microsoft Office 2010 First Look
image
Security and Privacy for Microsoft Office 2010 Users
image
Getting started with
Microsoft Office 2010 – For IT Professionals
image
Planning guide for Microsoft Office 2010 – For IT professionals
image
Deployment guide for Microsoft Office 2010 – For IT professionals
image
Operations guide for Microsoft Office 2010 – For IT professionals
image
Technical reference for Microsoft Office 2010 – For IT professionals
clip_image001
Understanding Microsoft Virtualization R2 Solutions
image
Introducing Windows Server 2012
image
Introducing Microsoft SQL Server 2012
image
Introducing Microsoft SQL Server 2008 R2

Configure Kerberos Authentication for SharePoint 2010 Products

Business continuity management for SharePoint Server 2010

Deployment guide for SharePoint Server 2010

Get started with SharePoint Server 2010

Governance guide for Microsoft SharePoint Server 2010

Profile synchronization guide for SharePoint Server 2010

Remote BLOB storage for Microsoft SharePoint Server 2010

Technical reference for Microsoft SharePoint Server 2010

Upgrading to SharePoint Server 2010
image
Getting Started with SharePoint Server 2010
image
Planning guide for sites and solutions for Microsoft SharePoint Server 2010, Part 1
image
Planning guide for sites and solutions for Microsoft SharePoint Server 2010, Part 2
image
Planning guide for server farms and environments for Microsoft SharePoint Server 2010
image
Capacity planning for Microsoft SharePoint Server 2010
   

SQL Server 2012 Tutorials: Analysis Services – Tabular Modeling

Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery

Transact-SQL Data Manipulation Language (DML) Reference

QuickStart: Learn DAX Basics in 30 Minutes

SQL Server 2012 Tutorials: Analysis Services – Data Mining

Microsoft SQL Server Analysis Services Multidimensional Performance and Operations Guide

Data Analysis Expressions (DAX) Reference

SQL Server 2012 Upgrade Technical Guide

Backup and Restore of SQL Server Databases

SQL Server 2012 Tutorials: Analysis Services – Multidimensional Modeling

Master Data Services Capacity Guidelines
 
In The Classroom - Digital Storytelling
Digital Storytelling
In The Classroom - Free Tools
Free Tools in the Classroom
In The Classroom - Movie Maker
Windows Live Movie Maker in the Classroom
In The Classroom - Windows 7
Windows 7 in the Classroom
In The Classroom - Web Apps
Microsoft Office Web Apps Teaching Guide
In The Classroom - Office
Microsoft Office in the Classroom
Critical Thinking - In The Classroom
Developing Critical Thinking through Web Research Skills
In The Classroom - Bing
Bing in the Classroom

Moving Applications to the Cloud, 2nd Edition

Windows Azure Prescriptive Guidance

Windows Azure Service Bus Reference

Intro to ASP.NET MVC 4 with Visual Studio (Beta)

Deploying an ASP.NET Web Application to a Hosting Provider using Visual Studio

Getting Started with ASP.NET 4.5 Web Forms (Beta)

Introducing ASP.NET Web Pages 2
image
Own Your Future
W7PUG Cover-free
Windows 7 Power Users Guide
eBook
Deploying Windows 7 Essential Guidance
image
Welcome to Windows 7
image
What You Can Do Before You Call Tech Support (Windows 7)

Source : http://blogs.msdn.com/b/mssmallbiz/archive/2012/07/27/large-collection-of-free-microsoft-ebooks-for-you-including-sharepoint-visual-studio-windows-phone-windows-8-office-365-office-2010-sql-server-2012-azure-and-more.aspx

Get the Microsoft Partner Info Mobile App and get access to the latest from all of those plus: product teams, MPN teams, Microsoft News and hundreds more resources here at Microsoft right on your phone:

image

Introducing Debugger Canvas : Released Now!!

About Debugger Canvas

Debugger Canvas is a new user experience for the debugger in Visual Studio Ultimate. It pulls together the code you’re exploring onto a single pan-and-zoom display. As you hit breakpoints or step into code, Debugger Canvas shows just the methods that you’re debugging, with call lines and local variables, to help you see the bigger picture.

Get Debugger Canvas

Try out Debugger Canvas, a new user experience for the debugger in Visual Studio Ultimate.

Install Debugger Canvas

Get Started

Download and Install Debugger Canvas.
Read the Guide to get started with Debugger Canvas.

Requirements

  • Visual Studio 2010 Ultimate SP1 (works with C# and Visual Basic)

Source : http://research.microsoft.com/en-us/projects/debuggercanvas/