Click here to Skip to main content
15,906,816 members
Home / Discussions / C#
   

C#

 
QuestionWeakEventHandler Sample Pin
Kevin Marois26-Mar-18 10:06
professionalKevin Marois26-Mar-18 10:06 
AnswerRe: WeakEventHandler Sample Pin
Dave Kreskowiak27-Mar-18 4:32
mveDave Kreskowiak27-Mar-18 4:32 
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 
C#
void FillCombo()
        {
            try 
            {
                DateTime MONDAY = DateTime.Now;
                DateTime FRIDAY = DateTime.Now.AddDays(5);

                string query = "SELECT orderID,FinalDate,StartDate FROM Tbl_Auftrag Where [StartDate] BETWEEN '" + MONDAY + "' AND '" + FRIDAY + "' AND [FinalDate] BETWEEN '" + MONDAY + "' AND '" + FRIDAY + "'";
                con.Open();
                SqlCommand cmdDataBase = new SqlCommand(query, con);
                SqlDataReader rdr = cmdDataBase.ExecuteReader();
                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);


                }
                con.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                con.Close();
            }
        }


Hello Smile | :) ,

I have a problem and I dont know how to solve it. With this code I can see all orderID's between today and in the next five days. But what if for example orderID: 234324 , StartDate = 26.03.2018, FinalDate = 27.03.2018 exists.... I should only see it in the listbox Monday and Tuesday. But its everywhere ... -.-

I know why... but not how to change that :/

maybe someone can help me? Smile | :)
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 
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 

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.