{"id":29572,"date":"2023-01-08T19:06:08","date_gmt":"2023-01-08T13:36:08","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed\/"},"modified":"2023-01-08T19:06:08","modified_gmt":"2023-01-08T13:36:08","slug":"solved-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed\/","title":{"rendered":"[Solved] Exception is System.Data.SqlClient.SqlException: Incorrect syntax near &#8216;9988&#8217; [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-51019377\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"51019377\" data-parentid=\"51019301\" 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>There must be a problem in one of your input parameters those you are directly reading from controls.<\/p>\n<p>This is not recommended anyway due to SQL injection attack threat.<\/p>\n<p>If you change your queries to us parameters (parameter queries), I hope this issue will be resolved.<\/p>\n<p>Following is an example how to use parameters. Note that I am not using your code in example:<\/p>\n<pre><code>SqlCommand objSqlCommand = null;\nstrSQL = @\"INSERT INTO ... (Field1, ...)\n                    VALUES \n                    (@param1, ...)\";\nobjSqlCommand = new SqlCommand(strSQL);\nobjSqlCommand.Parameters.Clear();\nobjSqlCommand.Parameters.AddWithValue(\"@param1\", yourControl.Text);\n....\n....\nobjSqlCommand.ExecuteNonQuery();\nobjSqlCommand.Dispose();\n<\/code><\/pre>\n<p>You should further improve this code by including <code>using<\/code> block or proper <code>try\/catch<\/code> blocks.<\/p>\n<p>This way, if there is any SQL query sensitive character in your input, it will be handled correctly and issue will be resolved. This is also strongly recommended to save yourself from SQL Injection Attack.<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">0<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Exception is System.Data.SqlClient.SqlException: Incorrect syntax near &#8216;9988&#8217; [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] There must be a problem in one of your input parameters those you are directly reading from controls. This is not recommended anyway due to SQL injection attack threat. If you change your queries to us parameters (parameter queries), I hope this issue will be resolved. Following is an example how to use parameters. &#8230; <a title=\"[Solved] Exception is System.Data.SqlClient.SqlException: Incorrect syntax near &#8216;9988&#8217; [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed\/\" aria-label=\"More on [Solved] Exception is System.Data.SqlClient.SqlException: Incorrect syntax near &#8216;9988&#8217; [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":[751,324,456,2332],"class_list":["post-29572","post","type-post","status-publish","format-standard","hentry","category-solved","tag-asp-net","tag-c","tag-exception","tag-webforms"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Exception is System.Data.SqlClient.SqlException: Incorrect syntax near &#039;9988&#039; [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-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Exception is System.Data.SqlClient.SqlException: Incorrect syntax near &#039;9988&#039; [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] There must be a problem in one of your input parameters those you are directly reading from controls. This is not recommended anyway due to SQL injection attack threat. If you change your queries to us parameters (parameter queries), I hope this issue will be resolved. Following is an example how to use parameters. ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-08T13:36:08+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-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Exception is System.Data.SqlClient.SqlException: Incorrect syntax near &#8216;9988&#8217; [closed]\",\"datePublished\":\"2023-01-08T13:36:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed\/\"},\"wordCount\":135,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"asp.net\",\"c++\",\"exception\",\"webforms\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed\/\",\"name\":\"[Solved] Exception is System.Data.SqlClient.SqlException: Incorrect syntax near '9988' [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2023-01-08T13:36:08+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Exception is System.Data.SqlClient.SqlException: Incorrect syntax near &#8216;9988&#8217; [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] Exception is System.Data.SqlClient.SqlException: Incorrect syntax near '9988' [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-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Exception is System.Data.SqlClient.SqlException: Incorrect syntax near '9988' [closed] - JassWeb","og_description":"[ad_1] There must be a problem in one of your input parameters those you are directly reading from controls. This is not recommended anyway due to SQL injection attack threat. If you change your queries to us parameters (parameter queries), I hope this issue will be resolved. Following is an example how to use parameters. ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed\/","og_site_name":"JassWeb","article_published_time":"2023-01-08T13:36:08+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-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Exception is System.Data.SqlClient.SqlException: Incorrect syntax near &#8216;9988&#8217; [closed]","datePublished":"2023-01-08T13:36:08+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed\/"},"wordCount":135,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["asp.net","c++","exception","webforms"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed\/","name":"[Solved] Exception is System.Data.SqlClient.SqlException: Incorrect syntax near '9988' [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2023-01-08T13:36:08+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-exception-is-system-data-sqlclient-sqlexception-incorrect-syntax-near-9988-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Exception is System.Data.SqlClient.SqlException: Incorrect syntax near &#8216;9988&#8217; [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\/29572","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=29572"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/29572\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=29572"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=29572"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=29572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}