{"id":28277,"date":"2022-12-29T20:39:49","date_gmt":"2022-12-29T15:09:49","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed\/"},"modified":"2022-12-29T20:39:49","modified_gmt":"2022-12-29T15:09:49","slug":"solved-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed\/","title":{"rendered":"[Solved] IF A BLANK SPACE IS PRESENT IN THE COLUMN HEADING &#8230;..AND\/OR operator not working in sql statement in c# .net for modifying an excel sheet [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-27739733\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"27739733\" data-parentid=\"27739205\" data-score=\"1\" 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>I&#8217;m pretty sure that the problem is the space in the name of your <code>Faculty Name<\/code> column and that this has nothing to do with the use of <code>AND<\/code> or <code>OR<\/code>. Please try:<\/p>\n<pre><code>sql = \"Update [Sheet1$] set A1 = 'a' \" +\n      \"where Designation = 'Prof(senior)' and [Faculty Name] = 'bob'\";\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 IF A BLANK SPACE IS PRESENT IN THE COLUMN HEADING &#8230;..AND\/OR operator not working in sql statement in c# .net for modifying an excel sheet [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] I&#8217;m pretty sure that the problem is the space in the name of your Faculty Name column and that this has nothing to do with the use of AND or OR. Please try: sql = &#8220;Update [Sheet1$] set A1 = &#8216;a&#8217; &#8221; + &#8220;where Designation = &#8216;Prof(senior)&#8217; and [Faculty Name] = &#8216;bob'&#8221;; 1 [ad_2] &#8230; <a title=\"[Solved] IF A BLANK SPACE IS PRESENT IN THE COLUMN HEADING &#8230;..AND\/OR operator not working in sql statement in c# .net for modifying an excel sheet [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed\/\" aria-label=\"More on [Solved] IF A BLANK SPACE IS PRESENT IN THE COLUMN HEADING &#8230;..AND\/OR operator not working in sql statement in c# .net for modifying an excel sheet [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":[352,324,400,2065,341],"class_list":["post-28277","post","type-post","status-publish","format-standard","hentry","category-solved","tag-net","tag-c","tag-excel","tag-oledb","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] IF A BLANK SPACE IS PRESENT IN THE COLUMN HEADING .....AND\/OR operator not working in sql statement in c# .net for modifying an excel sheet [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-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] IF A BLANK SPACE IS PRESENT IN THE COLUMN HEADING .....AND\/OR operator not working in sql statement in c# .net for modifying an excel sheet [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] I&#8217;m pretty sure that the problem is the space in the name of your Faculty Name column and that this has nothing to do with the use of AND or OR. Please try: sql = &quot;Update [Sheet1$] set A1 = &#039;a&#039; &quot; + &quot;where Designation = &#039;Prof(senior)&#039; and [Faculty Name] = &#039;bob&#039;&quot;; 1 [ad_2] ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-29T15:09:49+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<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] IF A BLANK SPACE IS PRESENT IN THE COLUMN HEADING &#8230;..AND\/OR operator not working in sql statement in c# .net for modifying an excel sheet [closed]\",\"datePublished\":\"2022-12-29T15:09:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed\/\"},\"wordCount\":88,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\".net\",\"c++\",\"excel\",\"oledb\",\"sql\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed\/\",\"name\":\"[Solved] IF A BLANK SPACE IS PRESENT IN THE COLUMN HEADING .....AND\/OR operator not working in sql statement in c# .net for modifying an excel sheet [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-12-29T15:09:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] IF A BLANK SPACE IS PRESENT IN THE COLUMN HEADING &#8230;..AND\/OR operator not working in sql statement in c# .net for modifying an excel sheet [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] IF A BLANK SPACE IS PRESENT IN THE COLUMN HEADING .....AND\/OR operator not working in sql statement in c# .net for modifying an excel sheet [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-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] IF A BLANK SPACE IS PRESENT IN THE COLUMN HEADING .....AND\/OR operator not working in sql statement in c# .net for modifying an excel sheet [closed] - JassWeb","og_description":"[ad_1] I&#8217;m pretty sure that the problem is the space in the name of your Faculty Name column and that this has nothing to do with the use of AND or OR. Please try: sql = \"Update [Sheet1$] set A1 = 'a' \" + \"where Designation = 'Prof(senior)' and [Faculty Name] = 'bob'\"; 1 [ad_2] ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed\/","og_site_name":"JassWeb","article_published_time":"2022-12-29T15:09:49+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] IF A BLANK SPACE IS PRESENT IN THE COLUMN HEADING &#8230;..AND\/OR operator not working in sql statement in c# .net for modifying an excel sheet [closed]","datePublished":"2022-12-29T15:09:49+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed\/"},"wordCount":88,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":[".net","c++","excel","oledb","sql"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed\/","name":"[Solved] IF A BLANK SPACE IS PRESENT IN THE COLUMN HEADING .....AND\/OR operator not working in sql statement in c# .net for modifying an excel sheet [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-12-29T15:09:49+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-if-a-blank-space-is-present-in-the-column-heading-and-or-operator-not-working-in-sql-statement-in-c-net-for-modifying-an-excel-sheet-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] IF A BLANK SPACE IS PRESENT IN THE COLUMN HEADING &#8230;..AND\/OR operator not working in sql statement in c# .net for modifying an excel sheet [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\/28277","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=28277"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/28277\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=28277"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=28277"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=28277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}