{"id":5588,"date":"2022-08-29T15:42:41","date_gmt":"2022-08-29T10:12:41","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-error-converting-varchar-value-to-int-datatype\/"},"modified":"2022-08-29T15:42:41","modified_gmt":"2022-08-29T10:12:41","slug":"solved-error-converting-varchar-value-to-int-datatype","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-error-converting-varchar-value-to-int-datatype\/","title":{"rendered":"[Solved] Error converting varchar-Value &#8216;..&#8217; to int-Datatype"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-53171784\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"53171784\" data-parentid=\"53171347\" data-score=\"4\" 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>Maybe change the data type on the db to an integer of some sort? Why does this differ from your input? Anyway the below should work. You should always make sure you utilize the <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/docs.microsoft.com\/en-us\/dotnet\/api\/system.data.sqlclient.sqlcommand.parameters?view=netframework-4.7.2\">parameters property<\/a> within a SqlCommand to avoid <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/en.wikipedia.org\/wiki\/SQL_injection\">SQL injection<\/a>.<\/p>\n<pre><code>void countVR(int kk)\n{\n    string selectString = \"SELECT COUNT(*) FROM cllohn\" + (Jahr % 100).ToString(\"00\") + \" WHERE lzVSTR=@KK\";\n    if (filtsel == selstr)\n    {\n        using (IDbConnection con = DatabaseFactory.Connect(\"CL\" + (Jahr % 100).ToString(\"00\"), true))\n        {\n            \/\/con.Open();\n            using (IDbCommand cmd = con.CreateCommand())\n            {\n                cmd.CommandText = selectString;\n                SqlParameter sqlParameter = new SqlParameter()\n                {\n                    Value = kk,\n                    ParameterName = \"@KK\"\n                };\n                cmd.Parameters.Add(sqlParameter);\n                using (IDataReader reader = cmd.ExecuteReader())\n                {\n                    while (reader.Read())\n                    {\n                        zeilenCount = reader.GetInt32(0);\n                        \/\/System.Diagnostics.Debug.WriteLine(\"Zeilen in \" + kk + \": \" +zeilenCount);\n                    }\n                }\n            }\n        }\n    }\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 Error converting varchar-Value &#8216;..&#8217; to int-Datatype <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] Maybe change the data type on the db to an integer of some sort? Why does this differ from your input? Anyway the below should work. You should always make sure you utilize the parameters property within a SqlCommand to avoid SQL injection. void countVR(int kk) { string selectString = &#8220;SELECT COUNT(*) FROM cllohn&#8221; &#8230; <a title=\"[Solved] Error converting varchar-Value &#8216;..&#8217; to int-Datatype\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-error-converting-varchar-value-to-int-datatype\/\" aria-label=\"More on [Solved] Error converting varchar-Value &#8216;..&#8217; to int-Datatype\">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,341,500],"class_list":["post-5588","post","type-post","status-publish","format-standard","hentry","category-solved","tag-c","tag-sql","tag-sql-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Error converting varchar-Value &#039;..&#039; to int-Datatype - 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-error-converting-varchar-value-to-int-datatype\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Error converting varchar-Value &#039;..&#039; to int-Datatype - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] Maybe change the data type on the db to an integer of some sort? Why does this differ from your input? Anyway the below should work. You should always make sure you utilize the parameters property within a SqlCommand to avoid SQL injection. void countVR(int kk) { string selectString = &quot;SELECT COUNT(*) FROM cllohn&quot; ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-error-converting-varchar-value-to-int-datatype\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-29T10:12:41+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-error-converting-varchar-value-to-int-datatype\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-error-converting-varchar-value-to-int-datatype\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Error converting varchar-Value &#8216;..&#8217; to int-Datatype\",\"datePublished\":\"2022-08-29T10:12:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-error-converting-varchar-value-to-int-datatype\/\"},\"wordCount\":57,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"c++\",\"sql\",\"sql-server\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-error-converting-varchar-value-to-int-datatype\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-error-converting-varchar-value-to-int-datatype\/\",\"name\":\"[Solved] Error converting varchar-Value '..' to int-Datatype - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-08-29T10:12:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-error-converting-varchar-value-to-int-datatype\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-error-converting-varchar-value-to-int-datatype\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-error-converting-varchar-value-to-int-datatype\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Error converting varchar-Value &#8216;..&#8217; to int-Datatype\"}]},{\"@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] Error converting varchar-Value '..' to int-Datatype - 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-error-converting-varchar-value-to-int-datatype\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Error converting varchar-Value '..' to int-Datatype - JassWeb","og_description":"[ad_1] Maybe change the data type on the db to an integer of some sort? Why does this differ from your input? Anyway the below should work. You should always make sure you utilize the parameters property within a SqlCommand to avoid SQL injection. void countVR(int kk) { string selectString = \"SELECT COUNT(*) FROM cllohn\" ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-error-converting-varchar-value-to-int-datatype\/","og_site_name":"JassWeb","article_published_time":"2022-08-29T10:12:41+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-error-converting-varchar-value-to-int-datatype\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-error-converting-varchar-value-to-int-datatype\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Error converting varchar-Value &#8216;..&#8217; to int-Datatype","datePublished":"2022-08-29T10:12:41+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-error-converting-varchar-value-to-int-datatype\/"},"wordCount":57,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["c++","sql","sql-server"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-error-converting-varchar-value-to-int-datatype\/","url":"https:\/\/jassweb.com\/solved\/solved-error-converting-varchar-value-to-int-datatype\/","name":"[Solved] Error converting varchar-Value '..' to int-Datatype - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-08-29T10:12:41+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-error-converting-varchar-value-to-int-datatype\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-error-converting-varchar-value-to-int-datatype\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-error-converting-varchar-value-to-int-datatype\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Error converting varchar-Value &#8216;..&#8217; to int-Datatype"}]},{"@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\/5588","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=5588"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/5588\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=5588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=5588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=5588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}