Click here to Skip to main content
11,428,004 members (58,900 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server ADO.NET database , +
Dear All,

I have a Datatable having following columns
Dates
Type
Users
Lines
DocFile
AudioFile
OriginalAudioFile
DiffLines
OriginalLine

I want to use Datatable Pivot to following format

Dates
Users
TRANSCRIBER
PROOFREADER
EDITOR

Type is my key field it contains 3 value (TRANSCRIBER,PROOFREADER,EDITOR)
Lines I want to summarize
order by Date wise and user wise

I search in net but I am not able to find proper things

Kindly provide some link

Thanks
Asutosha
Posted 24-Jul-12 22:21pm
Asutosha4.4K
Edited 25-Jul-12 0:17am
v2
Comments
Sandeep Mewara at 25-Jul-12 4:21am
   
What it sounds like you need to break the 'type' data and show separately. Not a Pivot!

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web02 | 2.8.150428.2 | Last Updated 25 Jul 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100