{"id":25320,"date":"2022-12-09T10:24:24","date_gmt":"2022-12-09T04:54:24","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed\/"},"modified":"2022-12-09T10:24:24","modified_gmt":"2022-12-09T04:54:24","slug":"solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed\/","title":{"rendered":"[Solved] Why it is a good practice to right try catch in foreach loop? [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-18060110\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"18060110\" data-parentid=\"18060052\" data-score=\"8\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>It is not working, it is running once, then it is failling but you are catching <code>Exception<\/code> but not doing anything with it. The problem with your code is that you are adding duplicate parameters. You should clear them after each loop:<\/p>\n<pre><code>foreach (KeyValuePair&lt;string, int&gt; pair in url)\n{\n    mySqlCommand.Parameters.Clear();\n\n    mySqlCommand.Parameters.Add(\n    new SqlParameter(\"@uniqueKeyWords\", pair.Key));\n\n    mySqlCommand.Parameters.Add(\n    new SqlParameter(\"@counts\", pair.Value));\n\n    mySqlCommand.CommandType = CommandType.StoredProcedure;\n    mySqlCommand.Connection.Open();\n    count = mySqlCommand.ExecuteNonQuery();\n    mySqlCommand.Connection.Close();          \n}\n<\/code><\/pre>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">1<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Why it is a good practice to right try catch in foreach loop? [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] It is not working, it is running once, then it is failling but you are catching Exception but not doing anything with it. The problem with your code is that you are adding duplicate parameters. You should clear them after each loop: foreach (KeyValuePair&lt;string, int&gt; pair in url) { mySqlCommand.Parameters.Clear(); mySqlCommand.Parameters.Add( new SqlParameter(&#8220;@uniqueKeyWords&#8221;, pair.Key)); &#8230; <a title=\"[Solved] Why it is a good practice to right try catch in foreach loop? [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed\/\" aria-label=\"More on [Solved] Why it is a good practice to right try catch in foreach loop? [closed]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[324],"class_list":["post-25320","post","type-post","status-publish","format-standard","hentry","category-solved","tag-c"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Why it is a good practice to right try catch in foreach loop? [closed] - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Why it is a good practice to right try catch in foreach loop? [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] It is not working, it is running once, then it is failling but you are catching Exception but not doing anything with it. The problem with your code is that you are adding duplicate parameters. You should clear them after each loop: foreach (KeyValuePair&lt;string, int&gt; pair in url) { mySqlCommand.Parameters.Clear(); mySqlCommand.Parameters.Add( new SqlParameter(&quot;@uniqueKeyWords&quot;, pair.Key)); ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-09T04:54:24+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Why it is a good practice to right try catch in foreach loop? [closed]\",\"datePublished\":\"2022-12-09T04:54:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed\/\"},\"wordCount\":73,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"c++\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed\/\",\"name\":\"[Solved] Why it is a good practice to right try catch in foreach loop? [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-12-09T04:54:24+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Why it is a good practice to right try catch in foreach loop? [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Why it is a good practice to right try catch in foreach loop? [closed] - JassWeb","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:\/\/jassweb.com\/solved\/solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Why it is a good practice to right try catch in foreach loop? [closed] - JassWeb","og_description":"[ad_1] It is not working, it is running once, then it is failling but you are catching Exception but not doing anything with it. The problem with your code is that you are adding duplicate parameters. You should clear them after each loop: foreach (KeyValuePair&lt;string, int&gt; pair in url) { mySqlCommand.Parameters.Clear(); mySqlCommand.Parameters.Add( new SqlParameter(\"@uniqueKeyWords\", pair.Key)); ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed\/","og_site_name":"JassWeb","article_published_time":"2022-12-09T04:54:24+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Why it is a good practice to right try catch in foreach loop? [closed]","datePublished":"2022-12-09T04:54:24+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed\/"},"wordCount":73,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["c++"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed\/","name":"[Solved] Why it is a good practice to right try catch in foreach loop? [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-12-09T04:54:24+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-why-it-is-a-good-practice-to-right-try-catch-in-foreach-loop-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Why it is a good practice to right try catch in foreach loop? [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/25320","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=25320"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/25320\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=25320"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=25320"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=25320"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}