Click here to Skip to main content
15,914,222 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionMVC, populating a dropdownlist, values persist on postback, and setting the value. Pin
jkirkerx2-Nov-15 12:16
professionaljkirkerx2-Nov-15 12:16 
AnswerRe: MVC, populating a dropdownlist, values persist on postback, and setting the value. [Sort of Solved] Pin
jkirkerx4-Nov-15 7:26
professionaljkirkerx4-Nov-15 7:26 
QuestionLosing the content of file upload control on postback Pin
Member 114228682-Nov-15 1:09
Member 114228682-Nov-15 1:09 
AnswerRe: Losing the content of file upload control on postback Pin
Richard Deeming2-Nov-15 2:19
mveRichard Deeming2-Nov-15 2:19 
AnswerRe: Losing the content of file upload control on postback Pin
F-ES Sitecore9-Nov-15 5:08
professionalF-ES Sitecore9-Nov-15 5:08 
QuestionFloor Plan in Web Application in ASP .NET Pin
Member 77075161-Nov-15 21:42
Member 77075161-Nov-15 21:42 
AnswerRe: Floor Plan in Web Application in ASP .NET Pin
F-ES Sitecore2-Nov-15 0:28
professionalF-ES Sitecore2-Nov-15 0:28 
QuestionCheckbox with enable and disable function. Pin
Praveen Kandari30-Oct-15 20:07
Praveen Kandari30-Oct-15 20:07 
QuestionGetting error when I try to load report in ASP.Net application Pin
Member 1209746129-Oct-15 2:15
Member 1209746129-Oct-15 2:15 
Questionsession related issues. Pin
Member 1191972228-Oct-15 19:16
Member 1191972228-Oct-15 19:16 
AnswerRe: session related issues. Pin
F-ES Sitecore28-Oct-15 23:18
professionalF-ES Sitecore28-Oct-15 23:18 
GeneralRe: session related issues. Pin
Member 1191972228-Oct-15 23:42
Member 1191972228-Oct-15 23:42 
GeneralRe: session related issues. Pin
F-ES Sitecore28-Oct-15 23:58
professionalF-ES Sitecore28-Oct-15 23:58 
GeneralRe: session related issues. Pin
Member 1191972229-Oct-15 0:04
Member 1191972229-Oct-15 0:04 
GeneralRe: session related issues. Pin
F-ES Sitecore29-Oct-15 0:13
professionalF-ES Sitecore29-Oct-15 0:13 
GeneralRe: session related issues. Pin
Member 1191972229-Oct-15 19:38
Member 1191972229-Oct-15 19:38 
GeneralRe: session related issues. Pin
F-ES Sitecore29-Oct-15 22:23
professionalF-ES Sitecore29-Oct-15 22:23 
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.

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.