{"id":34190,"date":"2023-03-02T17:59:00","date_gmt":"2023-03-02T12:29:00","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-getting-error-not-all-code-paths-a-value\/"},"modified":"2023-03-02T17:59:00","modified_gmt":"2023-03-02T12:29:00","slug":"solved-getting-error-not-all-code-paths-a-value","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-getting-error-not-all-code-paths-a-value\/","title":{"rendered":"[Solved] Getting Error: Not all code paths a value"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-37673749\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"37673749\" data-parentid=\"37673517\" data-score=\"0\" 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 are many problems in your code. Of course the compiler stops you at compile time, but then you will get other errors at runtime<\/p>\n<p>So fixing the compile time problem is easy. Just write a retrun value if you don&#8217;t have any rows returned by your query:<\/p>\n<pre><code>    \/\/ This returns true if you have rows, false if not\n    return (dt.Rows.Count &gt; 0);\n<\/code><\/pre>\n<p>Now the problems that you will face at runtime are the following<\/p>\n<ul>\n<li>The equal operator in SQL is = not ==<\/li>\n<li>The multiple WHERE conditions should be joined by a logical operator<br \/>\n(AND, OR)<\/li>\n<li>The sql text should be parameterized<\/li>\n<\/ul>\n<p>. <\/p>\n<pre><code>public bool loginpro(string loginas, string dept, string usnm, string pass)\n{\n    try\n    {\n        string qrstr;\n        qrstr = @\"select * from login where loginas=@login and dept = @dept\n                 and usnm = @user and pass= @pass\";\n        Gencon.Open();\n        SqlCommand cmd = new SqlCommand(qrstr, Gencon);\n        cmd.Parameters.Add(\"@login\", SqlDbType.NVarChar).Value = loginas;\n        cmd.Parameters.Add(\"@dept\", SqlDbType.NVarChar).Value = dept;\n        cmd.Parameters.Add(\"@user\", SqlDbType.NVarChar).Value = usnm;\n        cmd.Parameters.Add(\"@pass\", SqlDbType.NVarChar).Value = pass;\n        SqlDataAdapter da = new SqlDataAdapter(cmd);\n        DataTable dt = new DataTable();\n        da.Fill(dt);\n        Gencon.Close();\n        return (dt.Rows.Count &gt; 0);\n    }\n    catch (Exception e)\n    {\n        Gencon.Close();\n        return false;\n    }\n}\n<\/code><\/pre>\n<p>There are other problems like not using the using statement and trying to pass a clear text password to your database engine that could cause memory leaks and security problems.<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\"><\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Getting Error: Not all code paths a value <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] There are many problems in your code. Of course the compiler stops you at compile time, but then you will get other errors at runtime So fixing the compile time problem is easy. Just write a retrun value if you don&#8217;t have any rows returned by your query: \/\/ This returns true if you &#8230; <a title=\"[Solved] Getting Error: Not all code paths a value\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-getting-error-not-all-code-paths-a-value\/\" aria-label=\"More on [Solved] Getting Error: Not all code paths a value\">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,6051],"class_list":["post-34190","post","type-post","status-publish","format-standard","hentry","category-solved","tag-c","tag-sql","tag-sqlcommand"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Getting Error: Not all code paths a value - 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-getting-error-not-all-code-paths-a-value\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Getting Error: Not all code paths a value - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] There are many problems in your code. Of course the compiler stops you at compile time, but then you will get other errors at runtime So fixing the compile time problem is easy. Just write a retrun value if you don&#8217;t have any rows returned by your query: \/\/ This returns true if you ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-getting-error-not-all-code-paths-a-value\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-02T12:29:00+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-getting-error-not-all-code-paths-a-value\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-getting-error-not-all-code-paths-a-value\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Getting Error: Not all code paths a value\",\"datePublished\":\"2023-03-02T12:29:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-getting-error-not-all-code-paths-a-value\/\"},\"wordCount\":137,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"c++\",\"sql\",\"sqlcommand\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-getting-error-not-all-code-paths-a-value\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-getting-error-not-all-code-paths-a-value\/\",\"name\":\"[Solved] Getting Error: Not all code paths a value - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2023-03-02T12:29:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-getting-error-not-all-code-paths-a-value\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-getting-error-not-all-code-paths-a-value\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-getting-error-not-all-code-paths-a-value\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Getting Error: Not all code paths a value\"}]},{\"@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] Getting Error: Not all code paths a value - 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-getting-error-not-all-code-paths-a-value\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Getting Error: Not all code paths a value - JassWeb","og_description":"[ad_1] There are many problems in your code. Of course the compiler stops you at compile time, but then you will get other errors at runtime So fixing the compile time problem is easy. Just write a retrun value if you don&#8217;t have any rows returned by your query: \/\/ This returns true if you ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-getting-error-not-all-code-paths-a-value\/","og_site_name":"JassWeb","article_published_time":"2023-03-02T12:29:00+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-getting-error-not-all-code-paths-a-value\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-getting-error-not-all-code-paths-a-value\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Getting Error: Not all code paths a value","datePublished":"2023-03-02T12:29:00+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-getting-error-not-all-code-paths-a-value\/"},"wordCount":137,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["c++","sql","sqlcommand"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-getting-error-not-all-code-paths-a-value\/","url":"https:\/\/jassweb.com\/solved\/solved-getting-error-not-all-code-paths-a-value\/","name":"[Solved] Getting Error: Not all code paths a value - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2023-03-02T12:29:00+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-getting-error-not-all-code-paths-a-value\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-getting-error-not-all-code-paths-a-value\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-getting-error-not-all-code-paths-a-value\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Getting Error: Not all code paths a value"}]},{"@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\/34190","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=34190"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/34190\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=34190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=34190"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=34190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}