{"id":34445,"date":"2023-03-06T21:37:22","date_gmt":"2023-03-06T16:07:22","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records\/"},"modified":"2023-03-06T21:37:22","modified_gmt":"2023-03-06T16:07:22","slug":"solved-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records\/","title":{"rendered":"[Solved] Is SqlCommand the only way of adding,deleting and updating records?"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-52122593\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"52122593\" data-parentid=\"52121692\" 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>Your code seems fine to me, and I am unsure as to what your exact issue is; however, to clear your <code>TextBox<\/code> control&#8217;s <code>.Text<\/code> property; assign it a value of <code>string.Empty<\/code>.<\/p>\n<pre><code>textBox1.Text = string.Empty;\n<\/code><\/pre>\n<p>As far as your insert command, that looks fine. A point has been made that your code is vulnerable to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/en.wikipedia.org\/wiki\/SQL_injection\">SQL Injection<\/a>, but unless you need to safeguard your information, then I wouldn&#8217;t worry too much. If you are worried about SQL Injection and how to protect against it, there are many posts here, and many articles online on how to protect your applications from this type of attack. Things to look into are:<\/p>\n<ul>\n<li>Parameterization of dynamic data and queries.<\/li>\n<li>Don&#8217;t overuse dynamically generated queries.<\/li>\n<li>Utilize <code>sp_executesql<\/code> when executing dynamic queries so that parameters can&#8217;t be manipulated.<\/li>\n<\/ul>\n<\/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 Is SqlCommand the only way of adding,deleting and updating records? <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] Your code seems fine to me, and I am unsure as to what your exact issue is; however, to clear your TextBox control&#8217;s .Text property; assign it a value of string.Empty. textBox1.Text = string.Empty; As far as your insert command, that looks fine. A point has been made that your code is vulnerable to &#8230; <a title=\"[Solved] Is SqlCommand the only way of adding,deleting and updating records?\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records\/\" aria-label=\"More on [Solved] Is SqlCommand the only way of adding,deleting and updating records?\">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,500],"class_list":["post-34445","post","type-post","status-publish","format-standard","hentry","category-solved","tag-c","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] Is SqlCommand the only way of adding,deleting and updating records? - 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-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Is SqlCommand the only way of adding,deleting and updating records? - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] Your code seems fine to me, and I am unsure as to what your exact issue is; however, to clear your TextBox control&#8217;s .Text property; assign it a value of string.Empty. textBox1.Text = string.Empty; As far as your insert command, that looks fine. A point has been made that your code is vulnerable to ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-06T16:07:22+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-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Is SqlCommand the only way of adding,deleting and updating records?\",\"datePublished\":\"2023-03-06T16:07:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records\/\"},\"wordCount\":154,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"c++\",\"sql-server\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records\/\",\"name\":\"[Solved] Is SqlCommand the only way of adding,deleting and updating records? - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2023-03-06T16:07:22+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Is SqlCommand the only way of adding,deleting and updating records?\"}]},{\"@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] Is SqlCommand the only way of adding,deleting and updating records? - 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-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Is SqlCommand the only way of adding,deleting and updating records? - JassWeb","og_description":"[ad_1] Your code seems fine to me, and I am unsure as to what your exact issue is; however, to clear your TextBox control&#8217;s .Text property; assign it a value of string.Empty. textBox1.Text = string.Empty; As far as your insert command, that looks fine. A point has been made that your code is vulnerable to ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records\/","og_site_name":"JassWeb","article_published_time":"2023-03-06T16:07:22+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-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Is SqlCommand the only way of adding,deleting and updating records?","datePublished":"2023-03-06T16:07:22+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records\/"},"wordCount":154,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["c++","sql-server"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records\/","url":"https:\/\/jassweb.com\/solved\/solved-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records\/","name":"[Solved] Is SqlCommand the only way of adding,deleting and updating records? - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2023-03-06T16:07:22+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-is-sqlcommand-the-only-way-of-addingdeleting-and-updating-records\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Is SqlCommand the only way of adding,deleting and updating records?"}]},{"@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\/34445","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=34445"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/34445\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=34445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=34445"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=34445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}