RE: Do you have to worry about database connection sta...
Well .NET 2.0 will provide different way to use to connect to database server. Definately the server side will be heavy in terms of processing if we use database connection state. Perosnally I prefered to go for connection mode status.If this is not clear then you can contact me aloksaxena01@yahoo.com
RE: Do you have to worry about database connection sta...
yes we have to worry becaz there are lot of reasons i will explain with scenarios.
Let we have written the code in the try block where we have connected to the db and there is exception occured.Now the connection is opened and we should be very carefull that the connection is closed in the catch block else it will remain open.