|
How to convert System.Type.DateTime To SqlDbType.DateTime
Yogesh Pekhale
pekhaleyogesh@gmail.com
|
|
|
|
|
If you are using a stored procedure with a SqlDbType.DateTime parameter in it then you can directly assign your DateTime variable into the parameter. You are using parameters aren't you?
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Till now I was thinking that as System.Int32 is Valuetype, it will be stored in stack. But while profiling the application I have seen instances of System.Int32 in the heap.
Can anyone give a little clarification on this?
Thanks
*jaans
|
|
|
|
|
Here's the confusing thing - value types are always placed where they are declared. If they are declared within a method, they will always appear on the stack. If it's declared outside a method, but inside a reference type, it will be placed within the reference type (on the heap).
Confusing huh?
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
|
J@@NS wrote: BTW I have came across an interesting article
Excellent. Well found.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
i have code to save the data to new excel files i need to save and append tha data to already saved file using c# can any one help in this for me
Ramya
|
|
|
|
|
There isn't a whole lot different between opening an existing file and saving new data to it and opening a new file and saving new data to it. If you already have code to do one then the other is pretty much a cut and paste job . . .
is there something specific you're having a problem with?
|
|
|
|
|
Hi all,
I am trying to make the first letter to display as Capital,
i.e when user enters a text in the TextBox the first letter should be capital and the rest should be as they are.
e.g
this is a good example.
should be,
This is a good example.
Thanks,
Prashanth
|
|
|
|
|
The simplistic way:
Capture the keypress event, then read in the text that's already in the textbox. If this is the first alphabetic character, then convert it to uppercase using the string functions. Put the text into the textbox, then set the handled to true.
This is an extremely simplistic way that doesn't take into account things like the user entering text and then moving back to the start of the textbox and entering more text. A more comprehensive way requires you to change the contents of the textbox when it loses focus. That way, you can always find what the first character was - however, this is a single shot solution.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Thanks alot for ur suggestion..
but I want to make the very first letter that the user is going to enter should be Capital..
Not the one thatz already in textbox , I want to make the one which user is going to enter.
thanks
|
|
|
|
|
So you need a psychic handler?
The handler will instinctively know which letter you are ABOUT to press and set CAPS LOCK ON and then turn it off once the letter has been pressed.
Cool.
I still remember having to write your own code in FORTRAN rather than be a cut and paste merchant being pampered by colour coded Intellisense - ahh proper programming - those were the days 
|
|
|
|
|
Surely it can know which letter you just pressed, at what position, and change that letter to a capital?
|
|
|
|
|
Thanks, but
I don't know whatz psychic handler,
and How should I configure this handler to make the very first letter to make to CAPITAL.
as I am new here,please be clear.
thanks
|
|
|
|
|
Just like Microsoft Word Automatic Grammar/Spelling check?
|
|
|
|
|
psychic handler, not perfect. but it works
<br />
textbox1.KeyDown +=new KeyEventHandler(Psychic_Handler);<br />
<br />
private void Psychic_Handler(object sender, KeyEventArgs e)<br />
{<br />
if (((TextBox)sender).Text.Length == 0)<br />
{<br />
((TextBox)sender).Text = e.KeyCode.ToString().ToUpper();<br />
e.SuppressKeyPress = true;<br />
((TextBox)sender).SelectionStart = 1; <br />
}<br />
}<br />If it' stuck, DO NOT pull harder!
|
|
|
|
|
Hi. This would be easy way to do first char in CAPS....
char ci = Convert.ToChar(TextBox1.Text.Substring(0, 1));
TextBox1.Text = TextBox1.Text.Remove(0, 1);
TextBox1.Text = ci.ToString().ToUpper() + TextBox1.Text;
Thanks
|
|
|
|
|
|
hi
all i was asked in interview how often the garbage collector
i.e. gc.collect() will get invoked
i know why? what? about garbage collectore but
interviewer asked me will it be for every 5 minutes the method invokes
can anyone help me...
bye
|
|
|
|
|
When 1) a memory allocation request exceeds the current generation 0 segment capacity (or because of an exlicit call to GC.Collect) and 2) the object is no longer reachable.
If we exclude GC.Collect calls, this means that a GC will only occur on allocation. In other words, objects may well be ready to be released but no allocations are made, meaning no GCs will occur, so memory usage will stay flat.
*jaans
|
|
|
|
|
|
kalyan_2416 wrote: how often the garbage collector
i.e. gc.collect() will get invoked
Gc.Collect() will invoke garbage collector immediately. But AFAIK, we can't predict the timings when GC invoked when Collect() is not used. I guess it will be invoked when a cleanup is required.
|
|
|
|
|
nice quote
yup the other friend also says what u have guessed
thanx bye
|
|
|
|
|
IIRC explicitly calling GC.Collect() is generally a bad idea. The deal is that it will encourage the garbage collector to promote objects that survive collection to a higher generation. The higher generations are collected less aggressively - which has obvious performance implications.
|
|
|
|
|
You recall correctly. There aren't many occassions, (I can't think or any offhand), where you should call it - let the runtime determine this.
Deja View - the feeling that you've seen this post before.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
