Click here to Skip to main content
15,885,216 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: session related issues. Pin
Member 1191972229-Oct-15 23:29
Member 1191972229-Oct-15 23:29 
GeneralRe: session related issues. Pin
F-ES Sitecore29-Oct-15 23:36
professionalF-ES Sitecore29-Oct-15 23:36 
GeneralRe: session related issues. Pin
Member 1191972229-Oct-15 23:44
Member 1191972229-Oct-15 23:44 
Questionhave a problem to print my receipt with the printer epson lx-350 esc/p Pin
atiponj_8328-Oct-15 13:51
atiponj_8328-Oct-15 13:51 
AnswerRe: have a problem to print my receipt with the printer epson lx-350 esc/p Pin
Debojyoti Saha1-Nov-15 22:27
professionalDebojyoti Saha1-Nov-15 22:27 
QuestionMVC, Entity Framework, using a separate dll or assembly for website project. Pin
jkirkerx28-Oct-15 9:33
professionaljkirkerx28-Oct-15 9:33 
AnswerRe: MVC, Entity Framework, using a separate dll or assembly for website project. [solved] Pin
jkirkerx28-Oct-15 9:58
professionaljkirkerx28-Oct-15 9:58 
QuestionConverting Rows in columns Pin
byka28-Oct-15 9:32
byka28-Oct-15 9:32 
I have a datatable where data represented like this
ID Code Effective Date
111 103 01/01/2015
111 104 01/01/2014
111 105 01/01/2013
111 103 01/01/2014
111 103 01/01/2013
111 103 01/01/2012
112 103 01/01/2012
112 103 01/01/2013

I need to create a new table with the latest 3 effective date per each ID and Code:

Result:
ID Code Effective Date1 Effective Date2 Effective Date3
111 103 01/01/2015 01/01/2014 01/01/2013
111 104 01/01/2014
111 105 01/01/2013
112 103 01/01/2013 01/01/2012

How do I do this?
I have started with cloning the table structure(myDataTable already have Columns: Effective Date1 Effective Date2 Effective Date3)
Dim copyDataTable As DataTable
copyDataTable = myDataTable.Clone()

modified 28-Oct-15 15:55pm.

AnswerRe: Converting Rows in columns Pin
Richard Deeming28-Oct-15 10:03
mveRichard Deeming28-Oct-15 10:03 
GeneralRe: Converting Rows in columns Pin
byka28-Oct-15 10:12
byka28-Oct-15 10:12 
GeneralRe: Converting Rows in columns Pin
Richard Deeming28-Oct-15 10:13
mveRichard Deeming28-Oct-15 10:13 
GeneralRe: Converting Rows in columns Pin
byka20-Nov-15 3:22
byka20-Nov-15 3:22 
GeneralRe: Converting Rows in columns Pin
Richard Deeming23-Nov-15 1:40
mveRichard Deeming23-Nov-15 1:40 
GeneralRe: Converting Rows in columns Pin
byka24-Nov-15 4:13
byka24-Nov-15 4:13 
GeneralRe: Converting Rows in columns Pin
Richard Deeming24-Nov-15 8:48
mveRichard Deeming24-Nov-15 8:48 
GeneralRe: Converting Rows in columns Pin
byka30-Nov-15 1:57
byka30-Nov-15 1:57 
GeneralRe: Converting Rows in columns Pin
Richard Deeming30-Nov-15 2:03
mveRichard Deeming30-Nov-15 2:03 
GeneralRe: Converting Rows in columns Pin
byka30-Nov-15 3:29
byka30-Nov-15 3:29 
GeneralRe: Converting Rows in columns Pin
Richard Deeming30-Nov-15 4:03
mveRichard Deeming30-Nov-15 4:03 
GeneralRe: Converting Rows in columns Pin
byka30-Nov-15 8:54
byka30-Nov-15 8:54 
QuestionAbout ASP.Net Pin
Member 1209320927-Oct-15 20:28
Member 1209320927-Oct-15 20:28 
AnswerRe: About ASP.Net Pin
PANKAJMAURYA27-Oct-15 21:34
professionalPANKAJMAURYA27-Oct-15 21:34 
QuestionUnit testing tool for universal windows 10 app except Unit test app(universal windows) library Pin
Anjani Rajdev27-Oct-15 20:18
Anjani Rajdev27-Oct-15 20:18 
QuestionError: The parameter 'addresses' cannot be an empty string. Pin
Member 876166727-Oct-15 13:27
Member 876166727-Oct-15 13:27 
AnswerRe: Error: The parameter 'addresses' cannot be an empty string. Pin
Richard Deeming28-Oct-15 3:29
mveRichard Deeming28-Oct-15 3:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.