Click here to Skip to main content
15,916,835 members
Home / Discussions / C#
   

C#

 
GeneralRe: Need Help to link Nero Solution with C# Pin
Heath Stewart12-May-04 12:56
protectorHeath Stewart12-May-04 12:56 
GeneralCustomizing Windows Form - IE capabilities. Pin
stan2811-May-04 10:17
stan2811-May-04 10:17 
GeneralRe: Customizing Windows Form - IE capabilities. Pin
Heath Stewart11-May-04 11:01
protectorHeath Stewart11-May-04 11:01 
Generalserialization Pin
cristina_tudor11-May-04 10:15
cristina_tudor11-May-04 10:15 
GeneralRe: serialization Pin
Heath Stewart11-May-04 11:04
protectorHeath Stewart11-May-04 11:04 
GeneralQuery, DateTime Pin
DougW4811-May-04 10:15
DougW4811-May-04 10:15 
GeneralRe: Query, DateTime Pin
Michael P Butler11-May-04 10:25
Michael P Butler11-May-04 10:25 
GeneralRe: Query, DateTime Pin
DougW4811-May-04 13:16
DougW4811-May-04 13:16 
Putting pound signs around the Date like Heath suggested made my query a little better...I no longer have to subtract a day from Time1 to get the correct results. But here is the strange result I'm getting:

A row with a date column of 5/4/2004 is being selected when the date value of Time2 is 5/11/2004 and Time1 is anything from 5/4/2004 to 5/10/2004, but it's not selecting my row when Time1 is before 5/4/2004, and it should. Here is the statement I'm using to select my rows. I hope you can find something, because I sure can't:


string MySQLText = "SELECT * FROM Invoices";<br />
<br />
DateTime Time1 = new DateTime(dateTimePicker1.Value.Year, dateTimePicker1.Value.Month, dateTimePicker1.Value.Day, 0, 0, 0);<br />
<br />
DateTime Time2 = new DateTime(dateTimePicker2.Value.Year, dateTimePicker2.Value.Month, dateTimePicker2.Value.Day, 23, 59, 59);<br />
<br />
MySQLText += " WHERE (OrderDate BETWEEN #" + Time1.ToString() + "# AND #" + Time2.ToString() + "#)";<br />
<br />
oleDbSelectCommand1.CommandText = MySQLText;<br />
oleDbDataAdapter11.Fill( MyDataset );

GeneralRe: Query, DateTime Pin
Heath Stewart11-May-04 11:07
protectorHeath Stewart11-May-04 11:07 
GeneralRe: Query, DateTime Pin
DougW4811-May-04 15:02
DougW4811-May-04 15:02 
GeneralRe: Query, DateTime Pin
Heath Stewart11-May-04 16:21
protectorHeath Stewart11-May-04 16:21 
GeneralRe: Query, DateTime Pin
DougW4811-May-04 16:47
DougW4811-May-04 16:47 
GeneralRe: Query, DateTime Pin
DougW4811-May-04 18:07
DougW4811-May-04 18:07 
Generalsetting time on Zip Entry Pin
elena1234511-May-04 8:09
elena1234511-May-04 8:09 
GeneralRe: setting time on Zip Entry Pin
Jeff Varszegi11-May-04 9:00
professionalJeff Varszegi11-May-04 9:00 
GeneralRe: setting time on Zip Entry Pin
Heath Stewart11-May-04 9:20
protectorHeath Stewart11-May-04 9:20 
GeneralRe: setting time on Zip Entry Pin
Jeff Varszegi12-May-04 6:58
professionalJeff Varszegi12-May-04 6:58 
GeneralRe: setting time on Zip Entry Pin
Heath Stewart12-May-04 7:38
protectorHeath Stewart12-May-04 7:38 
GeneralRe: setting time on Zip Entry Pin
Heath Stewart11-May-04 9:10
protectorHeath Stewart11-May-04 9:10 
GeneralRe: setting time on Zip Entry Pin
elena1234511-May-04 11:10
elena1234511-May-04 11:10 
GeneralRe: setting time on Zip Entry Pin
Heath Stewart11-May-04 11:13
protectorHeath Stewart11-May-04 11:13 
Generalpopup tip on form Pin
cchere11-May-04 8:02
cchere11-May-04 8:02 
GeneralRe: popup tip on form Pin
Heath Stewart11-May-04 8:54
protectorHeath Stewart11-May-04 8:54 
GeneralRe: popup tip on form Pin
cchere13-May-04 12:32
cchere13-May-04 12:32 
GeneralRounded numbers in C# Pin
spyforcer11-May-04 5:51
spyforcer11-May-04 5:51 

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.