|
I am going to use a return. But this exits the whole program. So, within this condition, I am going to close the connection and have a return.
|
|
|
|
|
what makes the program to exit? is that how it has to work?
Quote: So, within this condition, I am going to close the connection and have a return
since you want to close the connection before the application exists thats the best place to do this reset.
Jibesh V P
|
|
|
|
|
If the database returns 0 rows, exit else continue.
|
|
|
|
|
Ok. did I answer your question? if not can you please share the code for the better understanding of your problem.
Jibesh V P
|
|
|
|
|
Yes, I think the general concensus is that, put try-catch-finally in all thread functions as coding practice.
dev
|
|
|
|
|
vanikanc wrote: If I use Environment.Exit(); then it will end the program, and I would not have closed the connection to database that is open.
It will not end the program, but terminate it.
Use Application.Terminate for a WinApp, and simply return from the Main method (the entry-point) if you're writing a Console App.
|
|
|
|
|
vanikanc wrote: two try blocks, two catches and one finally block
You'd have to show the code for us to understand how you have them arranged.
vanikanc wrote: closed the connection to database
You should be using a using statement as well -- it's similar to a try/finally.
vanikanc wrote: Environment.Exit();
Don't do that; just return.
|
|
|
|
|
vanikanc wrote: then it will end the program, and I would not have closed the connection to
database that is open.
When the program terminates the connection will be terminated as well.
And the only way you can terminate a database connection in C# anyways is if all of the following are true.
1. You have configured the connection pool to keep no idle connections.
2. There are no connections in use
3. You reset the pool.
Other than that just "closing" the connection does nothing more than return it to the connection pool.
|
|
|
|
|
Just return from the method. The finally block will execute and then your method will return.
|
|
|
|
|
Some alternate ideas.
- Are the two try/catch absolutely necessary? Try/catch is an expensive operation and I see many people using it where a simple if statement could save the day.
- Perhaps you can remove the second try, but move the catch to the first try. you can "assign" multiple catch handlers to one try. Of course only valid if you specify the exceptions. eg.:
try{
}
catch(SqlExcpetion sqlex){
}
catch(IOException){
}
catch(Exception ex){
}
finally{
}
- the quick and dirty way is maybe a goto statement, but you don't want to go that way, they're evil
hope this helps.
|
|
|
|
|
Just write return and the function will end after executing finally block.
Twenty years from now you will be more disappointed by the things that you didn't do than by the ones you did do. So throw off the bowlines. Sail away from the safe harbor. Catch the trade winds in your sails. Explore, Dream. Discover.
|
|
|
|
|
One suggestion from my side. If you put you connection inside a using block, you will not have to rely on any specific piece of code to close the connection and you can simply return from anywhere. It is the recommended way of doing the connection business.
This article will tell you how to use the connections with a using
ASP.NET - How To Use(Open/Close) Connections Correctly[^]
Twenty years from now you will be more disappointed by the things that you didn't do than by the ones you did do. So throw off the bowlines. Sail away from the safe harbor. Catch the trade winds in your sails. Explore, Dream. Discover.
|
|
|
|
|
I know what happens to lock(x) in event of a Thread.Abort, what about "using"?
dev
|
|
|
|
|
UNIT CONVERSION APPLICATION:
Build a WCF web service (ConvertService) having following methods:
(a) GetUnits() method to retrive available units
(b) Convert() method to convert a measure from selected units handling errors (eg. attempt to convert inches to kilogram.. etc.)
(c) GetRatio() method returning a ratio used in conversion from/to selected unit
Should cover at least four units:
Mass and weight- Kilogram(kg) and pound (lb)
Distance and length - Kilometers(km), miles(mi), centimeters(cm) and inches(in)
Capacity and volume - litre(l) and gallon (gal)
Temperature - Celsius scale (C) and fahrenheit scale (F)
Create a WCF service client (ConvertClient) which windows form client having following interfaces which uses the WCF service
From(lbl): textbox (input) ----To(lbl): textbox (result)
UnitFrom(unit select + combobox) ------UnitTo(unit select + combobox)
<-->
(btn to switch)
Convert(btn) Ratio: textbox
Get Ratio(btn)
Thanks.
|
|
|
|
|
Temperature doesn't have a conversion ratio.
|
|
|
|
|
Thanks for the reply...
I would like to know What time would it take and what are your requirements (charge)?
|
|
|
|
|
You may be in the wrong forum. However, if you want me to do it for you it would cost $2,500 USD prepaid and it would be done in about an hour.
|
|
|
|
|
|
All Correct 
|
|
|
|
|
MacRuturaj wrote: Thanks.
For what? It cannot be for answering your question, as there isn't one. We can help you with specific questions, but we don't do complete projects. CodeProject is a community, not a software vendor.
FWIW; you might want to reconsider the design. You can cover almost any unit by multiplying by the correct factor. Doesn't work for temperature though; easiest way was to add the multiplication-factors (and unit-names) to a table, and add in a formula that gets Evaluated for the temperatures.
Bonus-points if you can keep all your stuff in their respective SI-base units (so no kilometers or centimeters, only meters)
|
|
|
|
|
@Eddy Vluggen- I can understand that....
I posted this question because I saw some complete projects available for download on this website, I was looking through some material I can get and I found 2 softwares... so I thought I might get some answers like a software or a complete explanation with the code to make this small program.
|
|
|
|
|
The people who post articles do not read the forums every day. The reason we write those articles is because it's too much to explain "completely" in a post.
Here's an example in WinForms[^]; the article needs to be approved by the community, so it might not be visible today.
|
|
|
|
|
@Eddy Vluggen - " Thanks " for your interest and reply to this question. Even though it is not an answer I got some information from you.
|
|
|
|
|
You're welcome.
My apologies for the tone, but we see quite some people dropping the specs for their project here, and it's usually urgent. You'll get better results here simply by including a question at the end; "Anyone here got some bright ideas, tips or hints?"
Most members like to share their experience, even if it's not a specific question 
|
|
|
|
|
Ya, you are right. I think codeproject website is different as this is my first question and the response I got was different too...
now the best way will be to learn it ... I was stuck at making the interface and logic for conversion with the error handling, so I posted the whole detail as a question to explain it clearly.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
