{"id":10984,"date":"2022-09-25T17:02:52","date_gmt":"2022-09-25T11:32:52","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-how-to-pass-a-c-variable-with-apostrophe-through-mysql\/"},"modified":"2022-09-25T17:02:52","modified_gmt":"2022-09-25T11:32:52","slug":"solved-how-to-pass-a-c-variable-with-apostrophe-through-mysql","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-how-to-pass-a-c-variable-with-apostrophe-through-mysql\/","title":{"rendered":"[Solved] How to pass a C# variable with apostrophe through MySql"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-25541413\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"25541413\" data-parentid=\"25541370\" data-score=\"2\" 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>The quick and dirty fix is to use something like:<\/p>\n<pre><code>level = level.Replace(\"'\",\"whatever\");\n<\/code><\/pre>\n<p>but there are still problems with that. It won&#8217;t catch other bad characters and it probably won&#8217;t even work for edge cases on the apostrophe.<\/p>\n<p>The <em>best<\/em> solution is to not construct queries that way. Instead, learn how to use parameterised queries so that SQL injection attacks are impossible, and the parameters work no matter what you put in them (within reason, of course).<\/p>\n<p>For example (off the top of my head so may need some debugging):<\/p>\n<pre><code>MySqlCommand cmd = new MySqlCommand(\n    \"insert into data (level, name) values (?lvl, ?nm)\", con);\ncmd.Parameters.Add(new MySqlParameter(\"lvl\", level));\ncmd.Parameters.Add(new MySqlParameter(\"nm\", name)); \ncmd.ExecuteNonQuery();\n<\/code><\/pre>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">5<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved How to pass a C# variable with apostrophe through MySql <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] The quick and dirty fix is to use something like: level = level.Replace(&#8220;&#8216;&#8221;,&#8221;whatever&#8221;); but there are still problems with that. It won&#8217;t catch other bad characters and it probably won&#8217;t even work for edge cases on the apostrophe. The best solution is to not construct queries that way. Instead, learn how to use parameterised &#8230; <a title=\"[Solved] How to pass a C# variable with apostrophe through MySql\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-how-to-pass-a-c-variable-with-apostrophe-through-mysql\/\" aria-label=\"More on [Solved] How to pass a C# variable with apostrophe through MySql\">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":[3012,324,340,550],"class_list":["post-10984","post","type-post","status-publish","format-standard","hentry","category-solved","tag-apostrophe","tag-c","tag-mysql","tag-phpmyadmin"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] How to pass a C# variable with apostrophe through MySql - 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-how-to-pass-a-c-variable-with-apostrophe-through-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] How to pass a C# variable with apostrophe through MySql - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] The quick and dirty fix is to use something like: level = level.Replace(&quot;&#039;&quot;,&quot;whatever&quot;); but there are still problems with that. It won&#8217;t catch other bad characters and it probably won&#8217;t even work for edge cases on the apostrophe. The best solution is to not construct queries that way. Instead, learn how to use parameterised ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-how-to-pass-a-c-variable-with-apostrophe-through-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-25T11:32:52+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-how-to-pass-a-c-variable-with-apostrophe-through-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-pass-a-c-variable-with-apostrophe-through-mysql\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] How to pass a C# variable with apostrophe through MySql\",\"datePublished\":\"2022-09-25T11:32:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-pass-a-c-variable-with-apostrophe-through-mysql\/\"},\"wordCount\":113,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"apostrophe\",\"c++\",\"mysql\",\"phpmyadmin\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-pass-a-c-variable-with-apostrophe-through-mysql\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-how-to-pass-a-c-variable-with-apostrophe-through-mysql\/\",\"name\":\"[Solved] How to pass a C# variable with apostrophe through MySql - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-09-25T11:32:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-pass-a-c-variable-with-apostrophe-through-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-how-to-pass-a-c-variable-with-apostrophe-through-mysql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-pass-a-c-variable-with-apostrophe-through-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] How to pass a C# variable with apostrophe through MySql\"}]},{\"@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=1776403586\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] How to pass a C# variable with apostrophe through MySql - 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-how-to-pass-a-c-variable-with-apostrophe-through-mysql\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] How to pass a C# variable with apostrophe through MySql - JassWeb","og_description":"[ad_1] The quick and dirty fix is to use something like: level = level.Replace(\"'\",\"whatever\"); but there are still problems with that. It won&#8217;t catch other bad characters and it probably won&#8217;t even work for edge cases on the apostrophe. The best solution is to not construct queries that way. Instead, learn how to use parameterised ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-how-to-pass-a-c-variable-with-apostrophe-through-mysql\/","og_site_name":"JassWeb","article_published_time":"2022-09-25T11:32:52+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-how-to-pass-a-c-variable-with-apostrophe-through-mysql\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-pass-a-c-variable-with-apostrophe-through-mysql\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] How to pass a C# variable with apostrophe through MySql","datePublished":"2022-09-25T11:32:52+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-pass-a-c-variable-with-apostrophe-through-mysql\/"},"wordCount":113,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["apostrophe","c++","mysql","phpmyadmin"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-pass-a-c-variable-with-apostrophe-through-mysql\/","url":"https:\/\/jassweb.com\/solved\/solved-how-to-pass-a-c-variable-with-apostrophe-through-mysql\/","name":"[Solved] How to pass a C# variable with apostrophe through MySql - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-09-25T11:32:52+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-pass-a-c-variable-with-apostrophe-through-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-how-to-pass-a-c-variable-with-apostrophe-through-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-pass-a-c-variable-with-apostrophe-through-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] How to pass a C# variable with apostrophe through MySql"}]},{"@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=1776403586","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","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\/10984","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=10984"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/10984\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=10984"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=10984"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=10984"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}