{"id":128755,"date":"2023-05-08T13:41:26","date_gmt":"2023-05-08T08:11:26","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?page_id=128755"},"modified":"2024-04-12T14:16:00","modified_gmt":"2024-04-12T08:46:00","slug":"executing-a-statement-finally","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/executing-a-statement-finally\/","title":{"rendered":"Executing a Statement Finally"},"content":{"rendered":"\n

Executing a Statement Finally<\/strong><\/h4>\n\n\n\n

In addition to the try and catch blocks, finally blocks can be used to ensure that certain code is executed, regardless of whether an exception was thrown or not.<\/p>\n\n\n\n

Here’s an example of how to use a try-catch-finally block in ASP.NET:<\/p>\n\n\n\n

SqlConnection connection = null;<\/p>\n\n\n\n

try<\/p>\n\n\n\n

{<\/p>\n\n\n\n

    \/\/ Open database connection<\/p>\n\n\n\n

    connection = new SqlConnection(connectionString);<\/p>\n\n\n\n

    connection.Open();<\/p>\n\n\n\n

    \/\/ Execute database query<\/p>\n\n\n\n

    SqlCommand command = new SqlCommand(query, connection);<\/p>\n\n\n\n

    SqlDataReader reader = command.ExecuteReader();<\/p>\n\n\n\n

    \/\/ Process query results<\/p>\n\n\n\n

    while (reader.Read())<\/p>\n\n\n\n

    {<\/p>\n\n\n\n

        \/\/ …<\/p>\n\n\n\n

    }<\/p>\n\n\n\n

    \/\/ Close reader<\/p>\n\n\n\n

    reader.Close();<\/p>\n\n\n\n

}<\/p>\n\n\n\n

catch (Exception ex)<\/p>\n\n\n\n

{<\/p>\n\n\n\n

    \/\/ Handle the exception<\/p>\n\n\n\n

    \/\/ Log the exception<\/p>\n\n\n\n

    \/\/ Display a user-friendly error message<\/p>\n\n\n\n

}<\/p>\n\n\n\n

finally<\/p>\n\n\n\n

{<\/p>\n\n\n\n

    \/\/ Close database connection<\/p>\n\n\n\n

    if (connection != null)<\/p>\n\n\n\n

    {<\/p>\n\n\n\n

        connection.Close();<\/p>\n\n\n\n

    }<\/p>\n\n\n\n

}<\/p>\n\n\n\n

In this example, the finally block is used to close the database connection, regardless of whether an exception was thrown or not. This is important because leaving database connections open can cause performance problems and resource leaks.<\/p>\n\n\n\n

The finally block will always be executed, regardless of whether an exception was thrown or not. This ensures that any cleanup code that needs to be executed, such as closing files or releasing resources, is always executed.<\/p>\n\n\n\n

Note that the finally block should only contain code that needs to be executed regardless of whether an exception was thrown or not. It should not contain code that can throw exceptions itself, as this can cause unexpected behavior.<\/p>\n\n\n\n

Apply for ASP.NET Certification Now!!<\/h3>\n\n\n\n

https:\/\/www.vskills.in\/certification\/certified-aspnet-programmer<\/a><\/p>\n\n\n\n

Back to Tutorial<\/a><\/strong><\/h4>\n","protected":false},"excerpt":{"rendered":"

Executing a Statement Finally In addition to the try and catch blocks, finally blocks can be used to ensure that certain code is executed, regardless of whether an exception was thrown or not. Here’s an example of how to use a try-catch-finally block in ASP.NET: SqlConnection connection = null; try {     \/\/ Open database…<\/p>\n","protected":false},"author":22,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[3339],"tags":[],"class_list":["post-128755","page","type-page","status-publish","hentry","category-asp-net-2"],"acf":[],"yoast_head":"\nExecuting a Statement Finally - Tutorial<\/title>\n<meta name=\"description\" content=\"Executing a Statement Finally\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/executing-a-statement-finally\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Executing a Statement Finally - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Executing a Statement Finally\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/executing-a-statement-finally\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-12T08:46:00+00:00\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/executing-a-statement-finally\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/executing-a-statement-finally\/\",\"name\":\"Executing a Statement Finally - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"datePublished\":\"2023-05-08T08:11:26+00:00\",\"dateModified\":\"2024-04-12T08:46:00+00:00\",\"description\":\"Executing a Statement Finally\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/executing-a-statement-finally\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/executing-a-statement-finally\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/executing-a-statement-finally\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Executing a Statement Finally\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Executing a Statement Finally - Tutorial","description":"Executing a Statement Finally","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vskills.in\/certification\/tutorial\/executing-a-statement-finally\/","og_locale":"en_US","og_type":"article","og_title":"Executing a Statement Finally - Tutorial","og_description":"Executing a Statement Finally","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/executing-a-statement-finally\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T08:46:00+00:00","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/executing-a-statement-finally\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/executing-a-statement-finally\/","name":"Executing a Statement Finally - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"datePublished":"2023-05-08T08:11:26+00:00","dateModified":"2024-04-12T08:46:00+00:00","description":"Executing a Statement Finally","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/executing-a-statement-finally\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/executing-a-statement-finally\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/executing-a-statement-finally\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Executing a Statement Finally"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/128755","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=128755"}],"version-history":[{"count":2,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/128755\/revisions"}],"predecessor-version":[{"id":128759,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/128755\/revisions\/128759"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=128755"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=128755"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=128755"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}