{"id":19008,"date":"2024-03-15T18:01:10","date_gmt":"2024-03-15T18:01:10","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-executenonquery-method-in-c-database-access-technology\/"},"modified":"2024-03-21T14:40:23","modified_gmt":"2024-03-21T14:40:23","slug":"how-to-use-the-executenonquery-method-in-c-database-access-technology","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-executenonquery-method-in-c-database-access-technology\/","title":{"rendered":"How to use the ExecuteNonQuery method in C# database access technology?"},"content":{"rendered":"<p>The ExecuteNonQuery method is used to execute SQL statements that do not return any results, such as for inserting, updating, or deleting operations. The steps for using it are as follows:<\/p>\n<ol>\n<li>Create a SqlConnection object to connect to the database.<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">using<\/span> (SqlConnection connection = <span class=\"hljs-keyword\">new<\/span> SqlConnection(connectionString))\r\n{\r\n    <span class=\"hljs-comment\">\/\/ \u5176\u4e2dconnectionString\u662f\u8fde\u63a5\u5b57\u7b26\u4e32\uff0c\u7528\u4e8e\u6307\u5b9a\u8fde\u63a5\u7684\u6570\u636e\u5e93\u548c\u5176\u4ed6\u53c2\u6570<\/span>\r\n    <span class=\"hljs-comment\">\/\/ connectionString\u7684\u5177\u4f53\u5185\u5bb9\u6839\u636e\u6570\u636e\u5e93\u7c7b\u578b\u548c\u914d\u7f6e\u800c\u5b9a<\/span>\r\n    connection.Open();\r\n    \r\n    <span class=\"hljs-comment\">\/\/ \u6253\u5f00\u6570\u636e\u5e93\u8fde\u63a5<\/span>\r\n}\r\n<\/code><\/pre>\n<ol>\n<li>Create a SqlCommand object to execute the SQL statement.<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">using<\/span> (SqlCommand command = <span class=\"hljs-keyword\">new<\/span> SqlCommand(sql, connection))\r\n{\r\n    <span class=\"hljs-comment\">\/\/ \u5176\u4e2dsql\u662f\u8981\u6267\u884c\u7684SQL\u8bed\u53e5\uff0cconnection\u662f\u4e4b\u524d\u521b\u5efa\u7684SqlConnection\u5bf9\u8c61<\/span>\r\n    \r\n    <span class=\"hljs-comment\">\/\/ \u8bbe\u7f6e\u53c2\u6570\uff08\u5982\u679c\u6709\uff09<\/span>\r\n    command.Parameters.AddWithValue(<span class=\"hljs-string\">\"@param1\"<\/span>, value1);\r\n    command.Parameters.AddWithValue(<span class=\"hljs-string\">\"@param2\"<\/span>, value2);\r\n    \r\n    <span class=\"hljs-comment\">\/\/ \u6267\u884cSQL\u8bed\u53e5\u5e76\u8fd4\u56de\u53d7\u5f71\u54cd\u7684\u884c\u6570<\/span>\r\n    <span class=\"hljs-built_in\">int<\/span> rowsAffected = command.ExecuteNonQuery();\r\n    \r\n    <span class=\"hljs-comment\">\/\/ \u53ef\u4ee5\u6839\u636e\u8fd4\u56de\u503c\u8fdb\u884c\u76f8\u5e94\u7684\u5904\u7406<\/span>\r\n}\r\n<\/code><\/pre>\n<p>Note: Before executing the SQL statement, you can use the Parameters property to add parameters in order to prevent SQL injection attacks.<\/p>\n<ol>\n<li>Close the database connection.<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code>connection.Close();\r\n<\/code><\/pre>\n<p>The complete example code is as follows:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">using<\/span> (SqlConnection connection = <span class=\"hljs-keyword\">new<\/span> SqlConnection(connectionString))\r\n{\r\n    connection.Open();\r\n    \r\n    <span class=\"hljs-built_in\">string<\/span> sql = <span class=\"hljs-string\">\"INSERT INTO MyTable (Column1, Column2) VALUES (@param1, @param2)\"<\/span>;\r\n    \r\n    <span class=\"hljs-keyword\">using<\/span> (SqlCommand command = <span class=\"hljs-keyword\">new<\/span> SqlCommand(sql, connection))\r\n    {\r\n        command.Parameters.AddWithValue(<span class=\"hljs-string\">\"@param1\"<\/span>, value1);\r\n        command.Parameters.AddWithValue(<span class=\"hljs-string\">\"@param2\"<\/span>, value2);\r\n        \r\n        <span class=\"hljs-built_in\">int<\/span> rowsAffected = command.ExecuteNonQuery();\r\n        \r\n        <span class=\"hljs-comment\">\/\/ \u53ef\u4ee5\u6839\u636e\u8fd4\u56de\u503c\u8fdb\u884c\u76f8\u5e94\u7684\u5904\u7406<\/span>\r\n    }\r\n    \r\n    connection.Close();\r\n}\r\n<\/code><\/pre>\n<p>connectionString specifies the type, location, authentication method and other information of the database; sql is the SQL statement to be executed; @param1, @param2 are parameters in the SQL statement used to pass values to the SQL statement; value1, value2 are the specific parameter values.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The ExecuteNonQuery method is used to execute SQL statements that do not return any results, such as for inserting, updating, or deleting operations. The steps for using it are as follows: Create a SqlConnection object to connect to the database. using (SqlConnection connection = new SqlConnection(connectionString)) { \/\/ \u5176\u4e2dconnectionString\u662f\u8fde\u63a5\u5b57\u7b26\u4e32\uff0c\u7528\u4e8e\u6307\u5b9a\u8fde\u63a5\u7684\u6570\u636e\u5e93\u548c\u5176\u4ed6\u53c2\u6570 \/\/ connectionString\u7684\u5177\u4f53\u5185\u5bb9\u6839\u636e\u6570\u636e\u5e93\u7c7b\u578b\u548c\u914d\u7f6e\u800c\u5b9a connection.Open(); \/\/ \u6253\u5f00\u6570\u636e\u5e93\u8fde\u63a5 } [&hellip;]<\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-19008","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to use the ExecuteNonQuery method in C# database access technology? - Blog - Silicon Cloud<\/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:\/\/www.silicloud.com\/blog\/how-to-use-the-executenonquery-method-in-c-database-access-technology\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to use the ExecuteNonQuery method in C# database access technology?\" \/>\n<meta property=\"og:description\" content=\"The ExecuteNonQuery method is used to execute SQL statements that do not return any results, such as for inserting, updating, or deleting operations. The steps for using it are as follows: Create a SqlConnection object to connect to the database. using (SqlConnection connection = new SqlConnection(connectionString)) { \/\/ \u5176\u4e2dconnectionString\u662f\u8fde\u63a5\u5b57\u7b26\u4e32\uff0c\u7528\u4e8e\u6307\u5b9a\u8fde\u63a5\u7684\u6570\u636e\u5e93\u548c\u5176\u4ed6\u53c2\u6570 \/\/ connectionString\u7684\u5177\u4f53\u5185\u5bb9\u6839\u636e\u6570\u636e\u5e93\u7c7b\u578b\u548c\u914d\u7f6e\u800c\u5b9a connection.Open(); \/\/ \u6253\u5f00\u6570\u636e\u5e93\u8fde\u63a5 } [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-executenonquery-method-in-c-database-access-technology\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T18:01:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T14:40:23+00:00\" \/>\n<meta name=\"author\" content=\"Isabella Edwards\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Isabella Edwards\" \/>\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:\/\/www.silicloud.com\/blog\/how-to-use-the-executenonquery-method-in-c-database-access-technology\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-executenonquery-method-in-c-database-access-technology\/\"},\"author\":{\"name\":\"Isabella Edwards\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd\"},\"headline\":\"How to use the ExecuteNonQuery method in C# database access technology?\",\"datePublished\":\"2024-03-15T18:01:10+00:00\",\"dateModified\":\"2024-03-21T14:40:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-executenonquery-method-in-c-database-access-technology\/\"},\"wordCount\":137,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-executenonquery-method-in-c-database-access-technology\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-executenonquery-method-in-c-database-access-technology\/\",\"name\":\"How to use the ExecuteNonQuery method in C# database access technology? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T18:01:10+00:00\",\"dateModified\":\"2024-03-21T14:40:23+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-executenonquery-method-in-c-database-access-technology\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-executenonquery-method-in-c-database-access-technology\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-the-executenonquery-method-in-c-database-access-technology\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to use the ExecuteNonQuery method in C# database access technology?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd\",\"name\":\"Isabella Edwards\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g\",\"caption\":\"Isabella Edwards\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/isabellaedwards\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to use the ExecuteNonQuery method in C# database access technology? - Blog - Silicon Cloud","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:\/\/www.silicloud.com\/blog\/how-to-use-the-executenonquery-method-in-c-database-access-technology\/","og_locale":"en_US","og_type":"article","og_title":"How to use the ExecuteNonQuery method in C# database access technology?","og_description":"The ExecuteNonQuery method is used to execute SQL statements that do not return any results, such as for inserting, updating, or deleting operations. The steps for using it are as follows: Create a SqlConnection object to connect to the database. using (SqlConnection connection = new SqlConnection(connectionString)) { \/\/ \u5176\u4e2dconnectionString\u662f\u8fde\u63a5\u5b57\u7b26\u4e32\uff0c\u7528\u4e8e\u6307\u5b9a\u8fde\u63a5\u7684\u6570\u636e\u5e93\u548c\u5176\u4ed6\u53c2\u6570 \/\/ connectionString\u7684\u5177\u4f53\u5185\u5bb9\u6839\u636e\u6570\u636e\u5e93\u7c7b\u578b\u548c\u914d\u7f6e\u800c\u5b9a connection.Open(); \/\/ \u6253\u5f00\u6570\u636e\u5e93\u8fde\u63a5 } [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-executenonquery-method-in-c-database-access-technology\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T18:01:10+00:00","article_modified_time":"2024-03-21T14:40:23+00:00","author":"Isabella Edwards","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Isabella Edwards","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-executenonquery-method-in-c-database-access-technology\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-executenonquery-method-in-c-database-access-technology\/"},"author":{"name":"Isabella Edwards","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd"},"headline":"How to use the ExecuteNonQuery method in C# database access technology?","datePublished":"2024-03-15T18:01:10+00:00","dateModified":"2024-03-21T14:40:23+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-executenonquery-method-in-c-database-access-technology\/"},"wordCount":137,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-executenonquery-method-in-c-database-access-technology\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-executenonquery-method-in-c-database-access-technology\/","name":"How to use the ExecuteNonQuery method in C# database access technology? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T18:01:10+00:00","dateModified":"2024-03-21T14:40:23+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-executenonquery-method-in-c-database-access-technology\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-use-the-executenonquery-method-in-c-database-access-technology\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-the-executenonquery-method-in-c-database-access-technology\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to use the ExecuteNonQuery method in C# database access technology?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd","name":"Isabella Edwards","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g","caption":"Isabella Edwards"},"url":"https:\/\/www.silicloud.com\/blog\/author\/isabellaedwards\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/19008","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=19008"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/19008\/revisions"}],"predecessor-version":[{"id":52725,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/19008\/revisions\/52725"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=19008"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=19008"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=19008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}