|
Just use some common sense. SQL Stored Procedure Optimise Automatic Execution Plan Caching
George_George wrote: procesure
Start by spelling "procedure" correctly
how to google[^]
Simon
|
|
|
|
|
Hi Simon,
I did some search by the keywords you mentioned and find a lot of things. Various things, like batch execution as best practice, cache plan, store procedure optimization technologies.
I am willing to follow your suggest to find the right technology to my problem, but I have found so many. Could you just recommend me the technology name or some reference link I should use? Thanks.
regards and have a good weekend,
George
|
|
|
|
|
within or instead of the entire switch statement. i was advised that using tags are better than using the index in a switch statement. however switch only accepts integer types?
thank you in advance
----------------------------------------------------------
"unzip; strip; touch; finger; mount; fsck; more; yes; unmount; sleep" - my daily unix command list
|
|
|
|
|
The Tag property is of Type 'object'. If you put integers in them, cast the Tag.
Convert.ToInt32(mytextbox.Tag);
|
|
|
|
|
Hello everyone,
I have two ways to define the constructor of my exception class, which is derived from ApplicationException class.
I am not sure the pros and cons of the two constructor definitions? Any comments or advice?
class MyException : System.ApplicationException
{
private int _errorCode;
private string _errorDescription;
public MyException (int errorCode, string errorMessage)
: base (errorMessage)
{
_errorCode = errorCode;
_errorDescription = errorMessage;
}
public MyException (int errorCode, string errorMessage)
{
_errorCode = errorCode;
_errorDescription = errorMessage;
}
}
thanks in advance,
George
|
|
|
|
|
The former constructor is preferred as it allows the exception's message to be accessible when the exception is treated as ApplicationException .
/ravi
|
|
|
|
|
Thanks Ravi,
1.
What do you mean "treated as ApplicationException"? Convert MyException type to ApplicationException?
2.
And for the latter one when treated as ApplicationException, no error message information could be fonud?
regards,
George
|
|
|
|
|
Yessir. Right on both counts.
/ravi
|
|
|
|
|
Thanks ravi!
regards,
George
|
|
|
|
|
I agree with Ravi, the former is much better. But you don't need all the lines you've got in there.
class MyException : System.ApplicationException
{
private int _errorCode;
private string _errorDescription;
public MyException (int errorCode, string errorMessage)
: base (errorMessage)
{
_errorCode = errorCode;
_errorDescription = errorMessage;
Debug.WriteLine(base.Message);
}
}
Simon
|
|
|
|
|
Cool, Simon! If I do not call base (errorMessage) in constructor, will there be any issues?
regards,
George
|
|
|
|
|
George_George wrote: If I do not call base (errorMessage) in constructor, will there be any issues?
Yes. If you don't pass the errorMessage to the base it will never get stored in the base class.
Simon
|
|
|
|
|
Thanks Simon!
1.
I have another question about [Serializable] tag applied to exception class. Is it used for serialization process only or used for both serialization/de-serialization process?
2.
If [Serializable] could control both serialization and de-serialization process, why there is another constructor which accepts SerializationInfo and StreamingContext?
http://msdn.microsoft.com/en-us/library/tz6bzkbf.aspx[^]
regards,
George
|
|
|
|
|
1. I'm not sure I understand the question. What difference does it make? Perhaps you should ask this in a separate thread away from the context of this question on exceptions. Somebody else might understand better.
2. For more precise control over the serialisation, for custom serialisation formats and schemas. Which you might need if you are planning on serialising the object for interop with another system.
Simon
|
|
|
|
|
|
Hello George,
pertaining to your first question,
[Serializable] attribute is used for serialization as well as deserilization.
your second question leads to a microsoft answer of serializing only few public members of a class not all the public members . Just for an example if you are having a class Employee
Class Employee
{
public string name;
public int empid;
public int salary;
}
by making it [serializable] ,will serialize all public members of Employee class
Suppose you don't want to serialize salary .....then what you will do ?
The solution given by microsoft:-
Implement ISerializable interface and override two function and serialize what ever public member you want to serialize.
vijay
|
|
|
|
|
Adding to what others said, don't derive from ApplicationException . Derive from Exception instead.
|
|
|
|
|
I agree, thanks!
regards,
George
|
|
|
|
|
I have a textfile with values separated by tabs. It looks like below (only difference is that there can be many more columns and rows):
Voltage Temperature
6.41000 4.76610
3.41000 4.76366
6.41000 4.83936
6.41000 5.00298
6.41000 5.01763
6.41000 5.05670
Can anyone suggest a method to read from the text file and put the values in a matrix???
The problem is that nothing is known from the beginning. I was thinking of using ReadLine() and then break up the line in smaller pieces (one piece per value) but I find it hard to do because of all the unknown parameters (number of characters in each value, number of columns in the text file etc.)
Thanks!
|
|
|
|
|
If you know the character that will separate columns, you can use ReadLine() method and than use Split() method of string class. There are several libraries at codeproject that can help you in reading csv files.
|
|
|
|
|
Hello everyone,
How can I convert a byte array to string?
It works:
string text = Encoding.ASCII.GetString(byteArray);
But what should I do if I don't know the encoding of my byte array? Should I read bytes one by one and create string?
Thank you.
When you're alone in the Dark, Fear will protect you...
|
|
|
|
|
You have to know the encoding... what if it is unicode? (2 bytes for 1 char)...
|
|
|
|
|
V. wrote: You have to know the encoding
But... OK, is there any simple way to find the encoding of a text?
I found this article[^], it works fine but it's too complex.
When you're alone in the Dark, Fear will protect you...
|
|
|
|
|
There is no simple way that can handle any encoding.
Where do you get the byte array from in the first place? Why is it that you don't know how the text was encoded?
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Guffa wrote: Where do you get the byte array from in the first place?
void ReadFile(string filePath, long length)
{
string text;
using (FileStream fsReader = new FileStream(filePath, FileMode.Open, FileAccess.Read)
{
byte[] byteArray = new byte[length];
fsRead.Read(byteArray, 0, length);
}
RTB.Text = text;
}
Guffa wrote: Why is it that you don't know how the text was encoded?
User can open any files (*.*)
--A non-related question: Are non-text files (*.exe, *.mp3, *.avi, ...) have any encoding?--
Guffa wrote: There is no simple way that can handle any encoding.
Thanks a lot. It seems I should use that article[^] to get the file encoding, no problem
Thank you again.
When you're alone in the Dark, Fear will protect you...
|
|
|
|