|
That changes it per request though won't it.
I have a table of 80 000 rows. Is that not going to make my requests slower doing it at that level? Is there not a way to change it on how the calender format requests the date?
|
|
|
|
|
If the design of your table is correct, you should have stored this data in a DateTime type field.
span98 wrote: DD/MM/YYYY hh:mm:ss
This is only a display format - you can choose to display the date in any format that you want.
When you open an SQL table interactively though, from within Management Studio for instance, you will see the date being displayed according to the locale settings of your system.
HTH
Btw, cross-posting is generally considered rude
|
|
|
|
|
Ye I have stored it as DateTime.... My PC language is set to UK English and my SQL default is set to British english so that is why I see it as the format DD/MM/YYYY hh:mm:ss
So why does Microsoft Visual Studio not integrate with that? It is reading it as MM/DD/YYYY.
That is the problem I am stuck with
|
|
|
|
|
How are you displaying the date within VS?
|
|
|
|
|
I have two calender objects. I select a date from each...
The first to supply the date FROM and the second to supply the date TO
FROM = @start
TO = @end
|
|
|
|
|
span98 wrote: what should the standard date format be if there is one?
Fwiw, mm/dd/yy (or mm/dd/yyyy) is the "standard" (or at least common) American representation, based on how we read the dates, while dd-mm-yy or dd-mm-yyyy I believe is the common European representation. Mixing up slashes and dashes can be really confusing. dd/mm/yy should never be used anywhere, imo, for this very reason.
“Time and space can be a bitch.”
–Gushie, Quantum Leap
{o,o}.oO( Looking for a great RSS reader? Try FeedBeast! )
|)””’) Built with home-grown CodeProject components!
-”-”-
|
|
|
|
|
Hello,
I'm wondering how to capture a video stream from the web (such as youtube). I have been looking for some source code examples and where to start reading up on this but I cant find anything of use. I plan to write it in c# as it is the language i am most familiar with outside server side code.
Im not asking for the source code, just any pointers where to start, and what i need to use, would be very much appreciated
have a good day!
modano
na
|
|
|
|
|
|
yes, thats perfect for youtube!
but im more looking for a general way of capturing incoming streams.
will read up on this one though as well, thanks 
na
|
|
|
|
|
Hi friends
I am a beginer in C# programing . Below code snippet cause Invalid argument error while running, please help me to solve
public struct somestruct
{
public int n1;
public int n2;
}
public void findsomething( ref object obj )
{
....
}
public void form_load()
{
somestruct s1 = new somestruct();
findsomething( ref s1 )
}
error occurs in findsomething( ref s1) line
thanks in advance
-RisKhan-
|
|
|
|
|
Hello you have to change your method prototype :
to :public void findsomething( ref somestruct obj )
why are you using struct?
|
|
|
|
|
RisKhan wrote: ref object obj
RisKhan wrote: somestruct s1 = new somestruct(); findsomething( ref s1 )
You need to cast to object before supplying to method. Else replace the object type with somestruct.
|
|
|
|
|
RisKhan wrote: I am a beginer in C# programing .
Then my first advice is to not use structures, use classes. Structures are a lot more complidated to implement correctly, so you need a bit more experience before you should try that.
Also, don't use the ref keyword unless there really is a benefit. In your example you should return the result from the method instead.
RisKhan wrote: Below code snippet cause Invalid argument error while running
No, it doesn't. You can't run the code as it doesn't compile.
RisKhan wrote: error occurs in findsomething( ref s1) line
That's because the variable is not the same type as the parameter, and object does not inherit from somestruct.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Guffa wrote: and object does not inherit from somestruct.
I think you mean somestruct does not inherit from object.
“Time and space can be a bitch.”
–Gushie, Quantum Leap
{o,o}.oO( Looking for a great RSS reader? Try FeedBeast! )
|)””’) Built with home-grown CodeProject components!
-”-”-
|
|
|
|
|
logan1337 wrote: I think you mean somestruct does not inherit from object.
No I don't.
somestruct does inherit from object, but object does not inherit from somestruct.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Guffa wrote: but object does not inherit from somestruct
Well of course it doesn't. Object doesn't inherit from anything.
Besides, if somestruct does inherit from object (which it may well, I'm not sure on that point as I never use structs), then why is this a problem passing it into a parameter of a method that expects an object?
“Time and space can be a bitch.”
–Gushie, Quantum Leap
{o,o}.oO( Looking for a great RSS reader? Try FeedBeast! )
|)””’) Built with home-grown CodeProject components!
-”-”-
|
|
|
|
|
logan1337 wrote: if somestruct does inherit from object (which it may well, I'm not sure on that point as I never use structs), then why is this a problem passing it into a parameter of a method that expects an object?
It's not. The problem is that the type doesn't match.
I thought that perhaps the type could be cast one way, but that is not possible either. The type has to match exactly.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
I see. Nevermind my comment then. 
“Time and space can be a bitch.”
–Gushie, Quantum Leap
{o,o}.oO( Looking for a great RSS reader? Try FeedBeast! )
|)””’) Built with home-grown CodeProject components!
-”-”-
|
|
|
|
|
Hello everyone,
I read from some documents that string/array are immutable, means when we change the content of a string (e.g. append text) or change the content of an array (e.g. append new element), then a new instance be created and the old instance will be discarded?
thanks in advance,
George
|
|
|
|
|
Strings are immutable which means when you append a string, a new instance will be created. Note that literal strings are interned and will use same string reference.
George_George wrote: change the content of an array (e.g. append new element),
What do you meant by "append new element" ? Array is a block of data with a length. You can assign values to array locations.
|
|
|
|
|
Thanks N a v a n e e t h,
I am using both powershell and C#, in powershell we can append something to an array, and in C#, we can not correct?
regards,
George
|
|
|
|
|
Arrays are not resizable. So if you have space available in current array, you can assign data to that location. Else you need to copy the whole array contents to a new array with more storage location. Array class has methods to make this easier.
|
|
|
|
|
|
Precisely.
[edit]
I re-read your post. An Array is a fixed, contiguous series of identical data-types that have been reserved in memory and can be directly accessed through an address offset (eg. X[0] or X[6]). Arrays are static in size, you cannot append to them, you can most certainly change their contents.
A String is an array of characters, therefore, the same applies.
OTOH, dynamic data structures such as lists, queues and stacks can change in size and have items appended and removed.
|
|
|
|
|
Thanks Mustafa,
Mustafa Ismail Mustafa wrote: A String is an array of characters, therefore, the same applies.
Not quite agree with above statement. I think for array, we can not change its content (e.g. when change some specific char inside a string, a new instance will be created), correct?
regards,
George
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
