Click here to Skip to main content
11,505,486 members (66,361 online)
   

LINQ

 
AnswerRe: include nested object's property? Pin
ewohlman4-Sep-13 4:39
memberewohlman4-Sep-13 4:39 
GeneralRe: include nested object's property? [modified] Pin
Gabriel Szabo29-Nov-13 0:58
memberGabriel Szabo29-Nov-13 0:58 
AnswerRe: include nested object's property? Pin
DavidSherwood21hrs 43mins ago
memberDavidSherwood21hrs 43mins ago 
QuestionLinQ: sub items and root in DataTable Pin
nmc_aptech24-Apr-13 23:23
membernmc_aptech24-Apr-13 23:23 
AnswerRe: LinQ: sub items and root in DataTable Pin
Simon_Whale24-Apr-13 23:36
professionalSimon_Whale24-Apr-13 23:36 
GeneralRe: LinQ: sub items and root in DataTable Pin
nmc_aptech25-Apr-13 17:04
membernmc_aptech25-Apr-13 17:04 
AnswerRe: LinQ: sub items and root in DataTable Pin
Member 1153153721-Mar-15 21:47
memberMember 1153153721-Mar-15 21:47 
QuestionLINQ Query / "between" dates Pin
mebjen18-Nov-12 7:17
membermebjen18-Nov-12 7:17 
Hi All,

I've spent way to long on this - I'm trying to get distinct values from a dataTable: begDate = 2007-11-18 / endDate = 2007-12-31

Why does this work: Returns 4 rows
Dim shipTo = From row In osDS.Tables(0).AsEnumerable _
                                 Order By row(7) _
                                 Where row(0).ToString = cust _
                                 And row(1).ToString > begDate _
                                 Select row(7) Distinct

This doesn't work: Results Empty / Enumeration yield no results....
Dim shipTo = From row In osDS.Tables(0).AsEnumerable _
                                 Order By row(7) _
                                 Where row(0).ToString = cust _
                                 And row(1).ToString < endDate _
                                 Select row(7) Distinct

But what I really want is: (but it doesn't work either)
Dim shipTo = From row In osDS.Tables(0).AsEnumerable _
                                 Order By row(7) _
                                 Where row(0).ToString = cust _
                                 And row(1).ToString > begDate _
                                 And row(1).ToString < endDate _
                                 Select row(7) Distinct

Thanks in advance . . . .

MB
AnswerRe: LINQ Query / "between" dates Pin
Matt T Heffron18-Nov-12 12:52
memberMatt T Heffron18-Nov-12 12:52 
QuestionComma separeted text file Pin
marca29212-Nov-12 19:59
membermarca29212-Nov-12 19:59 
AnswerRe: Comma separeted text file Pin
savbace10-Jan-13 22:44
membersavbace10-Jan-13 22:44 
QuestionThe type of one of the expressions in the join clause is incorrect. Type inference failed in the call to GroupJoin Pin
dotnet9516-Oct-12 14:28
memberdotnet9516-Oct-12 14:28 
AnswerRe: The type of one of the expressions in the join clause is incorrect. Type inference failed in the call to GroupJoin Pin
Richard Deeming22-Oct-12 2:19
memberRichard Deeming22-Oct-12 2:19 
QuestionLINQ Pin
JabbarJahambana3-Oct-12 22:04
memberJabbarJahambana3-Oct-12 22:04 
AnswerRe: LINQ Pin
Pete O'Hanlon3-Oct-12 22:22
protectorPete O'Hanlon3-Oct-12 22:22 
AnswerRe: LINQ Pin
ProgramFOX5-Oct-12 5:33
memberProgramFOX5-Oct-12 5:33 
AnswerRe: LINQ Pin
emma926-Dec-12 6:23
memberemma926-Dec-12 6:23 
AnswerRe: LINQ Pin
tunheo24-Dec-12 22:17
membertunheo24-Dec-12 22:17 
GeneralMessage Automatically Removed Pin
12-Feb-13 20:09
memberMahesh Sellamuthu12-Feb-13 20:09 
Suggestionlinq to sql obtain foreign key value Pin
sc steinhayse24-Aug-12 19:40
membersc steinhayse24-Aug-12 19:40 
GeneralRe: linq to sql obtain foreign key value Pin
rs_engg5-Sep-12 3:43
memberrs_engg5-Sep-12 3:43 
Questionminus returned value during executing a insert stored procedure Pin
Member 870070423-Aug-12 5:37
memberMember 870070423-Aug-12 5:37 
AnswerRe: minus returned value during executing a insert stored procedure Pin
Wes Aday23-Aug-12 6:00
memberWes Aday23-Aug-12 6:00 
AnswerRe: minus returned value during executing a insert stored procedure Pin
BobJanova23-Aug-12 6:14
memberBobJanova23-Aug-12 6:14 
QuestionLINQ or ADO.NET ? Pin
pashmakjoon19-Aug-12 10:11
memberpashmakjoon19-Aug-12 10:11 

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

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


Advertise | Privacy | Mobile
Web04 | 2.8.150520.1 | Last Updated 2 Jun 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid