|
That's painful. Reminds me of when I first learned exception handling... I programmed a message box for most, if not all, exceptions...
Don't worry. I've learned.
|
|
|
|
|
I guess there are many samples of connection strings here (with asterisks instead of password, etc.). Here is another one
string connectionString = String.Format("Sever={0};Dsn={1}", server, databaseName);
OdbcConnection connection = new OdbcConnection(connectionString);
try
{
connection.Open();
}
catch (Exception)
{
return false;
}
1. I think ODBC driver has absolutely no idea what is "Sever" (and if it does, perhaps it would like more to go to the "Yuh". A joke for those who speaks Russian).
2. If it's spelling mistake (author wants ODBC driver as his English teacher), DSN already contains information about server.
3. What about user name and password?
4. DSN is data source name actually.
|
|
|
|
|
I found this piece of PL/SQL code in application exporting data into financial system.
field_number is value of field type number (precision = 2)
trunc(field_number / 60, 0) || ',' || round(100 * (field_number / 60 - trunc(field_number / 60, 0)), 2)
ok, the code is pretty subtle but..
for example: what will be the result for field_number = 10 [min]. Let me guess, 0,16,67 ?
|
|
|
|
|
I would, sadly enough, not be surprised if the financial system wants the data in this format...
|
|
|
|
|
Ouch! Your application was not set to the correct locale. It must be 0,16.67
|
|
|
|
|
I've just found an "excellent" way to detect if boolean value is true or not in C#. Just great! Important, "value" variable is System.Boolean .
string valueStr = value.ToString();
if (valueStr.Equals("true", StringComparison.CurrentCultureIgnoreCase))
{
PDFIncludeWatermark_ = "true";
}
else
{
PDFIncludeWatermark_ = "false";
}
|
|
|
|
|
haha, what a joke!
You could make this so much simpler by just having...
PDFIncludeWatermark_ = value.ToString().ToLowerInvarient().Contains("true") ? "true" : "false";
I may or may not be responsible for my own actions
|
|
|
|
|
Contains!=Equals
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
Future proof... in case Microsoft want to emphasize the System.Boolean.ToString() value and return "true!";
always got to be on your toes
I may or may not be responsible for my own actions
|
|
|
|
|
Surely you mean:
!Equals.Contains(Contains)
|
|
|
|
|
PDFIncludeWatermark_ = value.ToString().ToLower();
or
PDFIncludeWatermark_ = value ? "true" : "false";
|
|
|
|
|
now your just being silly
I may or may not be responsible for my own actions
|
|
|
|
|
I like your way of thinking... Good optimization, you know.
|
|
|
|
|
depends what type of programming style you're into.
Some might find the mentioned method easier/simpler to read/understand.
"Program testing can be used to show the presence of bugs, but never to show their absence."
<< please vote!! >>
|
|
|
|
|
I'm not sure I trust computers that much. Can I suggest an improvement?
string valueStr = value.ToString();
if (valueStr.Equals("true", StringComparison.CurrentCultureIgnoreCase))
{
PDFIncludeWatermark_ = "true";
}
else if (valueStr.Equals("false", StringComparison.CurrentCultureIgnoreCase))
{
PDFIncludeWatermark_ = "false";
}
else
{
PDFIncludeWatermark_ = "maybe";
}
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Manfred R. Bihy: "Looks as if OP is learning resistant."
|
|
|
|
|
You're right, never, never rely on compiler. Damn machines If you need a job done, do it yourself.
|
|
|
|
|
Oh, I trust the compiler.
It's reality I don't trust.
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Manfred R. Bihy: "Looks as if OP is learning resistant."
|
|
|
|
|
The else section should return "filenotfound" I believe!
else
{
PDFIncludeWatermark_ = "filenotfound";
}
FTFY
|
|
|
|
|
I disagree: the concepts of truth and falsehood do not have anything to do with file systems!
However, in the real world I doubt the existence of "absolute truth" and "absolute falsehood" so a "maybe" response seems reasonable...
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Manfred R. Bihy: "Looks as if OP is learning resistant."
|
|
|
|
|
|
Not seen that before - thanks!
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Manfred R. Bihy: "Looks as if OP is learning resistant."
|
|
|
|
|
Dang! Beat me to it.
Marking it as "news" is pretty hilarious.
|
|
|
|
|
|
Dear VUnreal,
Please find below a simplified code segment that may help you in achieving your code in one line using a helper class.
please feel free to add additional checks and safeguards, and rewrite the helper as an extension to the string class.
string valueStr = value.ToString();
TruthChecker tc=new TruthChecker();
PDFIncludeWatermark_ = tc.CheckIfTrue();
class TruthChecker
{
private static List<string> _truths = null;
List<string> Truths { get { return _truths!=null ? _truths : (_truths = FindAllTruths() ); } }
TruthChecker() {
}
private static List<string> FindAllTruths() {
List<string> allTruths = new List<string>();
char[] t = {'t','r','u','e'};
for(int i=0;i<Math.Pow(2,t.Length); i++) {
StringBuilder sb = new StringBuilder();
for(int j=0; j<t.Length; j++) {
int k = (i>>j)&1;
sb.Append(t[j]+('A'-'a')*k);
}
allTruths.Add(sb.ToString());
}
return allTruths;
}
public string CheckIfTrue(string tru)
{
try {
var v =
from t in Truths
where t == tru
select t;
if (v.ElementAt(0).ToString().Length == "true".Length) {
return "true";
}
} catch (Exception ex) {
tru = ex.Message;
}
return "false";
}
}
Please visit IOCCC.org to learn more about useful coding techniques.
|
|
|
|
|
Why do so many think that try - catch blocks are just here to stop you from seeing runtime errors?
It is a plain nightmare to debug a project which has code like this sprinkled all over the place.
(Note: I removed some confidental information from the code)
try
{
if (SomeConstant != "")
{
this.comboBox.SelectedItem = this.comboBox.Items[this.comboBox.Items.IndexOf(SomeConstant)];
}
}
catch { }
Or one of my favourites:
protected override bool Exists()
{
bool returnValue = false;
try
{
product = GetProductOverWebservice()
if (product != null && product.product_id == m_RecordID.ToString())
{
_product = productinfo;
returnValue = true;
}
}
catch (Exception ex)
{
}
return returnValue;
}
|
|
|
|