|
If you post your SELECT statement, it'll make it easier to help spot the problem.
Michael
CP Blog [^]
|
|
|
|
|
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 );
|
|
|
|
|
I won't badger you this time, but I still suggest you try it. Once you do, I suspect you'll never turn back. 
Dates in SQL Server are single-quoted like strings. When referring to Date fields, SQL Server knows what to do. For Access (and some other's I've seen, but don't remember) you encase them in pounds (or hashes - #). If you don't, they will be treated like strings (IIRC) so you won't get the result you'd expect.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Even with the pound signs, the adapter is treating the dates as strings. It is acting like 5/11/04 should go BEFORE 5/4/04. If using the parameters will fix this, I'll change to them as long as I can add them to the adapter programmatically, because in truth I would prefer to use the parameters...I just didn't know how in this situation. What would you suggest? Thank
|
|
|
|
|
Trust me - using parameters is so much better. You can add them programmatically, as there is no other way!
For example (and I'm assuming you're using an OleDbCommand since you're using # signs):
OleDbCommand cmd = oleDbConnection.CreateCommand();
cmd.CommandText = "SELECT * FROM MyTable WHERE DateCol BETWEEN ? AND ?";
cmd.Parameters.Add("StartDate", OleDbType.DBDate).Value = DateTime.Parse("5/4/04");
cmd.Parameters.Add("EndDate", OleDbType.DBDate).Value = DateTime.Parse("5/11/04");
OleDbDataReader reader = null;
try
{
oleDbConnection.Open();
reader = cmd.ExecuteReader();
}
catch (Exception e)
{
Console.Error.WriteLine(e.Message);
}
finally
{
if (reader != null) reader.Close();
oleDbConnection.Close();
}Of course, you could use this command with an OleDbDataAdapter as well - this is just an example.
Still, though it is unusual that it's treating it as a string. You're not using quotes and # signs, are you?
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
I'll give this a try and see if it makes a difference. And no, I just have the hash signs, not the single quotes. The message I replied after the other person's post is a direct copy and paste.
|
|
|
|
|
I'm pretty embarrassed to admit this, but I discovered that the date column in my database was set to text. At any rate, I did convert things to parameters, so your efforts weren't in vain. Thanks for the help!
|
|
|
|
|
I am zipping up a bunch of files and "Modified" date on the files always turns out to be 1/1/1980 12:00AM
The date I have is in DateTime format, and I tried
zipEntry.setDate(d.ToFileTimeUtc())
zipEntry.setDate(d.ToFileTimeUtc())
zipEntry.setDate(d.ToFileTime())
zipEntry.setDate(d.Ticks)
Nothing works!!! It keeps on getting 1/1/1980 12:00AM
Do you have any idea why this is not working?
Code:
<br />
<br />
ZipEntry currententry = new ZipEntry(localPath);<br />
currententry.setMethod(ZipEntry.DEFLATED); <br />
currententry.setTime(createDate.ToFileTimeUtc()); <br />
<br />
m_zipstream.putNextEntry(currententry); <br />
<br />
try<br />
{ <br />
java.io.FileInputStream current = new java.io.FileInputStream(fullPath); <br />
try<br />
{<br />
sbyte[] buffer = new sbyte[8192];<br />
int buffercount;<br />
<br />
while ((buffercount = current.read(buffer, 0, buffer.Length)) > 0)<br />
m_zipstream.write(buffer, 0, buffercount); <br />
}<br />
finally { current.close(); } <br />
}<br />
finally { m_zipstream.closeEntry(); }<br />
Thanks,
Elena
|
|
|
|
|
|
I've heard that too (and I see I'm mentioned  ). In this case, however, is sounds like an epoch problem since Java and .NET (not to mention the OLE DATE and who knows what else) all use different epochs. The DateTime struct in .NET also uses ticks (100 ns) instead of ms like most structs. And developers thought all the different text encodings were a problem! 
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
I never even used J#, but you could be right. I didn't know that they actually replicated the Java classes like DateTime that have equivalents in C#, but it does make sense. In any case, the poster'd probably be MUCH better off using SharpZipLib...
|
|
|
|
|
The didn't. The java.util.Date is nothing like the DateTime. The J# portability assemblies work just like the Java classes. Encapsulating a DateTime in a Date, for example, would screw-up any code that modifies the Date.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
DateTime in .NET and the date and time in Java use different epochs (start times). DateTime is the number of ticks from 00:00:00 Jan. 1, 0001 AD. Java's Date starts at 00:00:00 Jan. 1, 1970 AD and is the number of milliseconds from that date/time.
A tick is 100 nanoseconds. So, to convert a DateTime to the number of milliseconds to use, you'll need to take this information into account and convert the number.
The best way is to use the java.util.Date class. When working with the vjslib.dll assembly, keep in mind that this assembly exists only to make it easier for Java developers to make the move. It's intended to work just like it would if you were still developing with Java classes. Classes in the FCL and Java assemblies should not be inter-mixed without proper consideration.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Is java.util.Date a part of vjslib or is it from a different library?
Thanks for your help.
Elena
|
|
|
|
|
Yes it's in the vjslib.dll assembly, along with pretty much everything else you'd find in the JRE (besides the swing stuff). If you want to know for sure, run ildasm.exe (the IL Disassembler found in the .NET Framework SDK bin directory) and open the vjslib.dll assembly in the %WINDIR%\Microsoft.NET\Framework\v1.1.4322 directory. This will show you the assembly and Type metadata, as well as the IL for any module(s) in the assembly (if you know how to read IL).
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
How can I display a popup tip when the mouse moves over a certain area on a form?
Help class can show popup tips but I cannot hide the tip when I am done with it. Any suggestion?
Thanx
|
|
|
|
|
A simple hack would be to put a Panel in that region of the form and use the ToolTip component to set the tooltip for that region. The ToolTip is an IExtenderProvider that provides "properties" to other controls. Once you add it, click on that Panel and you'll see something like "ToolTip on panel1" (or whatever you call your panel variable).
The other way is to P/Invoke SendMessage and send the tooltip common control messages, which is really all the ToolTip component is doing. You can use the Form.MouseHover event to determine when to show the tooltip.
You can find out more about the tooltip common control and it's messages in the Platform SDK: http://msdn.microsoft.com/library/en-us/shellcc/platform/commctls/tooltip/reflist.asp[^].
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Great ideas. Thanks a lot.
|
|
|
|
|
I meet with one problem in C# : when double convert to int
If value is halfway between two whole numbers, the even number is returned; that is, 4.5 is converted to 4, and 5.5 is converted to 6.
In MSDN it is circumscribed as correct operation, well and when a classical understanding of math operation
round (5.5) == 6 and round (5.4) == 5. I think that the Microsoft imposes the understanding of roundoff of numbers.
Would like to hear your judgements concerning...
|
|
|
|
|
Well, I've always viewed a cast that discards specificity as a truncation of sorts. The semantics of casting from double to int are what I'd expect of a truncation routine, so I'm not unhappy with it. How about something like this for your needs?
<br />
public static int Round(double d) {<br />
if (d >= 0) {<br />
return ((int)(d + 0.5D));<br />
}<br />
else {<br />
return ((int)(d - 0.5D));<br />
}<br />
}<br />
-Jeff
here, bloggy bloggy
|
|
|
|
|
Thank Jeff for your answer, I yesterday have written approximately same function.
|
|
|
|
|
|
This is a known issue (it's been discussed a few other times here on CodeProject as well), but not necessarily a bug (though one could argue it is). There's a lot of information about this on the web. Take a look at this one I grabbed from google: http://weblogs.asp.net/sfurman/archive/2003/03/07/3537.aspx[^].
Basically, it all comes down to precision. The article above has a link to some of the documentation in the .NET Framework SDK that indicates as much. There's also a cludgy work-around if you want to use that instead (using SqlDecimal.Round).
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Thank, it's realy too an output from situations
|
|
|
|
|
Hey
We are doing a Client Server Program and have a problem.
We use:
TcpClient.GetStream
In the client we have a loop that checks the stream with formatter and if there is anything it is translated to a searten obj. When we are starting up an other window(the game) we pason the stream to another while loop in the game.
this works fine, but leter we get som problem, the stream is containing somtehing that we can not translate and that is cousing a error, somthing about instance not set to a object, but it is. The only thing the Server is sending is somthing cald commandobj. we have tryed to translate the stream content to a object and then se whats wrong, but it throws an error when we trying to dezerialize it.
If we look on the Stream during the run before the error we can see that there is a error on Position and lenght in the stream obj.
Now, how can vi flush the stream so its clean? the regular flush is doing nothing?
Best Regards
Jimmy
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
