Click here to Skip to main content
15,900,973 members
Home / Discussions / C#
   

C#

 
GeneralRe: WeakEventHandler Sample Pin
Kevin Marois27-Mar-18 5:18
professionalKevin Marois27-Mar-18 5:18 
GeneralRe: WeakEventHandler Sample Pin
Dave Kreskowiak27-Mar-18 9:34
mveDave Kreskowiak27-Mar-18 9:34 
GeneralRe: WeakEventHandler Sample Pin
Kevin Marois27-Mar-18 9:37
professionalKevin Marois27-Mar-18 9:37 
GeneralRe: WeakEventHandler Sample Pin
Dave Kreskowiak27-Mar-18 10:16
mveDave Kreskowiak27-Mar-18 10:16 
GeneralRe: WeakEventHandler Sample Pin
Kevin Marois27-Mar-18 10:17
professionalKevin Marois27-Mar-18 10:17 
QuestionC#, SQL Time period between two columns Pin
Member 1374655226-Mar-18 6:47
Member 1374655226-Mar-18 6:47 
AnswerRe: C#, SQL Time period between two columns Pin
OriginalGriff26-Mar-18 8:20
mveOriginalGriff26-Mar-18 8:20 
AnswerRe: C#, SQL Time period between two columns Pin
MadMyche27-Mar-18 6:05
professionalMadMyche27-Mar-18 6:05 
Once you fix your concatenated SQL, you need to fix your reader loop; there is nothing to differentiate what the start and stop dates are
C#
while (rdr.Read()) {

    String sName = rdr["orderID"].ToString();
    listBox1Montag.Items.Add(sName);
    listBox2Dienstag.Items.Add(sName);
    listBox3Mittwoch.Items.Add(sName);
    listBox4Donnerstag.Items.Add(sName);
    listBox5Freitag.Items.Add(sName);

}

What you need to do is to enumerate through the rows and check to see if the start/finish dates align with a particular day
C#
while (rdr.Read()) {

    String sName = rdr["orderID"].ToString();
    DateTime StartDate = Convert.ToDateTime(rdr["DateField"]).ToString("dd/MM/yyyy");
    DateTime FinalDate = Convert.ToDateTime(rdr["FinalDate"]).ToString("dd/MM/yyyy");

    if ((StartDate <= MONDAY) && (FinalDate >= MONDAY)) { listBox1Montag.Items.Add(sName); }

    // You are going to need to figure this portion out
    // I would probably create a helper class for this

    if ((StartDate <= FRIDAY) && (FinalDate >= FRIDAY)) { listBox5Freitag.Items.Add(sName); }
}


Director of Transmogrification Services
Shinobi of Query Language
Master of Yoda Conditional

QuestionOrdering names into list box Pin
Member 1374647825-Mar-18 21:15
Member 1374647825-Mar-18 21:15 
AnswerRe: Ordering names into list box Pin
Richard MacCutchan25-Mar-18 21:42
mveRichard MacCutchan25-Mar-18 21:42 
AnswerRe: Ordering names into list box Pin
OriginalGriff25-Mar-18 21:44
mveOriginalGriff25-Mar-18 21:44 
GeneralRe: Ordering names into list box Pin
#realJSOP26-Mar-18 2:06
professional#realJSOP26-Mar-18 2:06 
GeneralRe: Ordering names into list box Pin
OriginalGriff26-Mar-18 2:13
mveOriginalGriff26-Mar-18 2:13 
GeneralRe: Ordering names into list box Pin
Member 1374647826-Mar-18 2:52
Member 1374647826-Mar-18 2:52 
GeneralRe: Ordering names into list box Pin
OriginalGriff26-Mar-18 3:57
mveOriginalGriff26-Mar-18 3:57 
GeneralRe: Ordering names into list box Pin
#realJSOP26-Mar-18 5:27
professional#realJSOP26-Mar-18 5:27 
QuestionMin and Max or Range Pin
sunsher21-Mar-18 22:52
sunsher21-Mar-18 22:52 
AnswerRe: Min and Max or Range Pin
OriginalGriff21-Mar-18 23:04
mveOriginalGriff21-Mar-18 23:04 
AnswerRe: Min and Max or Range Pin
Gerry Schmitz22-Mar-18 9:00
mveGerry Schmitz22-Mar-18 9:00 
AnswerRe: Min and Max or Range Pin
Eddy Vluggen22-Mar-18 10:24
professionalEddy Vluggen22-Mar-18 10:24 
AnswerRe: Min and Max or Range Pin
#realJSOP23-Mar-18 2:37
professional#realJSOP23-Mar-18 2:37 
SuggestionRe: Min and Max or Range Pin
Richard Deeming23-Mar-18 9:19
mveRichard Deeming23-Mar-18 9:19 
GeneralRe: Min and Max or Range Pin
sunsher24-Mar-18 0:38
sunsher24-Mar-18 0:38 
GeneralRe: Min and Max or Range Pin
#realJSOP24-Mar-18 1:00
professional#realJSOP24-Mar-18 1:00 
GeneralRe: Min and Max or Range Pin
Eddy Vluggen24-Mar-18 1:05
professionalEddy Vluggen24-Mar-18 1:05 

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.