Click here to Skip to main content
   

LINQ

 
AnswerI am stuck wit Linq to Sql "NOT IN" - (Solved) PinmemberAndy_L_J19-Jun-13 4:00 
QuestionEF- LINQ to Entities - How to implement LIKE extension Pinmembergresspav12-Jun-13 0:03 
QuestionLINQ: Order by specific values (ID) first and Rest will follow Pinmembern_satisha28-May-13 3:06 
AnswerRe: LINQ: Order by specific values (ID) first and Rest will follow [modified] PinmemberJacek Gajek4-Jun-13 23:59 
Questioninclude nested object's property? Pinmembermp4mcd1-May-13 18:51 
AnswerRe: include nested object's property? PinmemberMidwestLimey2-May-13 10:43 
GeneralRe: include nested object's property? Pinmemberjohnnys appleseed3-May-13 4:22 
AnswerRe: include nested object's property? Pinmemberewohlman4-Sep-13 5:39 
GeneralRe: include nested object's property? [modified] PinmemberGabriel Szabo29-Nov-13 1:58 
QuestionLinQ: sub items and root in DataTable Pinmembernmc_aptech25-Apr-13 0:23 
AnswerRe: LinQ: sub items and root in DataTable PinprofessionalSimon_Whale25-Apr-13 0:36 
GeneralRe: LinQ: sub items and root in DataTable Pinmembernmc_aptech25-Apr-13 18:04 
AnswerRe: LinQ: sub items and root in DataTable PinmemberMember 1153153721-Mar-15 22:47 
QuestionLINQ Query / "between" dates Pinmembermebjen18-Nov-12 8: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 13:52 
QuestionComma separeted text file Pinmembermarca29212-Nov-12 20:59 
AnswerRe: Comma separeted text file Pinmembersavbace10-Jan-13 23: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 15: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 3:19 
QuestionLINQ PinmemberJabbarJahambana3-Oct-12 23:04 
AnswerRe: LINQ PinprotectorPete O'Hanlon3-Oct-12 23:22 
AnswerRe: LINQ PinmemberProgramFOX5-Oct-12 6:33 
AnswerRe: LINQ Pinmemberemma926-Dec-12 7:23 
AnswerRe: LINQ Pinmembertunheo24-Dec-12 23:17 
GeneralMessage Automatically Removed PinmemberMahesh Sellamuthu12-Feb-13 21:09 
Suggestionlinq to sql obtain foreign key value Pinmembersc steinhayse24-Aug-12 20:40 
GeneralRe: linq to sql obtain foreign key value Pinmemberrs_engg5-Sep-12 4:43 
Questionminus returned value during executing a insert stored procedure PinmemberMember 870070423-Aug-12 6:37 
AnswerRe: minus returned value during executing a insert stored procedure PinmemberWes Aday23-Aug-12 7:00 
AnswerRe: minus returned value during executing a insert stored procedure PinmemberBobJanova23-Aug-12 7:14 
QuestionLINQ or ADO.NET ? Pinmemberpashmakjoon19-Aug-12 11:11 
AnswerRe: LINQ or ADO.NET ? PinmvpRichard MacCutchan20-Aug-12 0:03 
AnswerRe: LINQ or ADO.NET ? Pinmvpthatraja20-Aug-12 1:39 
GeneralRe: LINQ or ADO.NET ? Pinmembermanijasmine20-Aug-12 9:07 
AnswerRe: LINQ or ADO.NET ? PinmemberKolkata .NET8-Mar-13 6:45 
Questionhow to load and save an xml document using linq Pinmemberowobs15-Aug-12 2:57 
AnswerRe: how to load and save an xml document using linq PinmentorWayne Gaylard15-Aug-12 3:16 
QuestionCreating a dynamic where clause PinmemberSimon_Whale9-Aug-12 1:06 
AnswerRe: Creating a dynamic where clause PinprotectorPete O'Hanlon9-Aug-12 1:22 
GeneralRe: Creating a dynamic where clause PinmemberSimon_Whale9-Aug-12 1:26 
GeneralRe: Creating a dynamic where clause PinmemberBobJanova9-Aug-12 3:11 
GeneralRe: Creating a dynamic where clause PinmemberSimon_Whale9-Aug-12 4:10 
GeneralRe: Creating a dynamic where clause PinprotectorPete O'Hanlon9-Aug-12 4:40 
GeneralRe: Creating a dynamic where clause PinmemberSimon_Whale9-Aug-12 4:44 
QuestionLinq where dates question PinmemberMember 78188928-Jul-12 14:23 
AnswerRe: Linq where dates question PinprotectorPete O'Hanlon8-Jul-12 20:51 
AnswerRe: Linq where dates question PinmemberBobJanova9-Jul-12 2:41 
AnswerRe: Linq where dates question PinmemberMatt T Heffron11-Jul-12 9:41 
AnswerRe: Linq where dates question PinmemberMatt T Heffron27-Jul-12 15:35 
Questionlinq to sql connection string name Pinmemberrachel_m6-Jul-12 7:31 

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.150327.1 | Last Updated 22 Mar 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid