Click here to Skip to main content
       

LINQ

 
AnswerRe: include nested object's property? PinmemberMidwestLimey2-May-13 9:43 
GeneralRe: include nested object's property? Pinmemberjohnnys appleseed3-May-13 3:22 
AnswerRe: include nested object's property? Pinmemberewohlman4-Sep-13 4:39 
GeneralRe: include nested object's property? [modified] PinmemberGabriel Szabo29-Nov-13 0:58 
QuestionLinQ: sub items and root in DataTable Pinmembernmc_aptech24-Apr-13 23:23 
AnswerRe: LinQ: sub items and root in DataTable PinprofessionalSimon_Whale24-Apr-13 23:36 
GeneralRe: LinQ: sub items and root in DataTable Pinmembernmc_aptech25-Apr-13 17:04 
QuestionLINQ Query / "between" dates Pinmembermebjen18-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 PinmemberMatt T Heffron18-Nov-12 12:52 
QuestionComma separeted text file Pinmembermarca29212-Nov-12 19:59 
AnswerRe: Comma separeted text file Pinmembersavbace10-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 Pinmemberdotnet9516-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 PinmemberRichard Deeming22-Oct-12 2:19 
QuestionLINQ PinmemberJabbarJahambana3-Oct-12 22:04 
AnswerRe: LINQ PinprotectorPete O'Hanlon3-Oct-12 22:22 
AnswerRe: LINQ PinmemberProgramFOX5-Oct-12 5:33 
AnswerRe: LINQ Pinmemberemma926-Dec-12 6:23 
AnswerRe: LINQ Pinmembertunheo24-Dec-12 22:17 
GeneralMessage Automatically Removed PinmemberMahesh Sellamuthu12-Feb-13 20:09 
Suggestionlinq to sql obtain foreign key value Pinmembersc steinhayse24-Aug-12 19:40 
GeneralRe: linq to sql obtain foreign key value Pinmemberrs_engg5-Sep-12 3:43 
Questionminus returned value during executing a insert stored procedure PinmemberMember 870070423-Aug-12 5:37 
AnswerRe: minus returned value during executing a insert stored procedure PinmemberWes Aday23-Aug-12 6:00 
AnswerRe: minus returned value during executing a insert stored procedure PinmemberBobJanova23-Aug-12 6:14 
QuestionLINQ or ADO.NET ? Pinmemberpashmakjoon19-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
Web01 | 2.8.140718.1 | Last Updated 27 Jun 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid