{"id":26811,"date":"2024-03-16T07:22:33","date_gmt":"2024-03-16T07:22:33","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-use-executenonquery-in-database-operations-with-c\/"},"modified":"2024-03-22T09:29:52","modified_gmt":"2024-03-22T09:29:52","slug":"how-to-use-executenonquery-in-database-operations-with-c","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-use-executenonquery-in-database-operations-with-c\/","title":{"rendered":"How to use ExecuteNonQuery in database operations with C#"},"content":{"rendered":"<p>In C#, the ExecuteNonQuery method is used to execute SQL statements and return the number of rows affected. It is usually used for executing INSERT, UPDATE, or DELETE statements as they do not return any result sets.<\/p>\n<p>Here is an example of how to use the ExecuteNonQuery method:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">using<\/span> System;\r\n<span class=\"hljs-keyword\">using<\/span> System.Data.SqlClient;\r\n\r\n<span class=\"hljs-keyword\">class<\/span> <span class=\"hljs-title\">Program<\/span>\r\n{\r\n    <span class=\"hljs-function\"><span class=\"hljs-keyword\">static<\/span> <span class=\"hljs-keyword\">void<\/span> <span class=\"hljs-title\">Main<\/span>()<\/span>\r\n    {\r\n        <span class=\"hljs-built_in\">string<\/span> connectionString = <span class=\"hljs-string\">\"your_connection_string\"<\/span>;\r\n        \r\n        <span class=\"hljs-comment\">\/\/ \u521b\u5efa\u8fde\u63a5\u5bf9\u8c61<\/span>\r\n        <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-comment\">\/\/ \u521b\u5efa\u547d\u4ee4\u5bf9\u8c61<\/span>\r\n            <span class=\"hljs-keyword\">using<\/span> (SqlCommand command = <span class=\"hljs-keyword\">new<\/span> SqlCommand(<span class=\"hljs-string\">\"INSERT INTO MyTable (Column1, Column2) VALUES (@Value1, @Value2)\"<\/span>, connection))\r\n            {\r\n                <span class=\"hljs-comment\">\/\/ \u6dfb\u52a0\u53c2\u6570<\/span>\r\n                command.Parameters.AddWithValue(<span class=\"hljs-string\">\"@Value1\"<\/span>, <span class=\"hljs-string\">\"Value 1\"<\/span>);\r\n                command.Parameters.AddWithValue(<span class=\"hljs-string\">\"@Value2\"<\/span>, <span class=\"hljs-string\">\"Value 2\"<\/span>);\r\n                \r\n                <span class=\"hljs-comment\">\/\/ \u6267\u884cSQL\u8bed\u53e5<\/span>\r\n                <span class=\"hljs-built_in\">int<\/span> rowsAffected = command.ExecuteNonQuery();\r\n                \r\n                Console.WriteLine(<span class=\"hljs-string\">\"\u53d7\u5f71\u54cd\u7684\u884c\u6570: \"<\/span> + rowsAffected);\r\n            }\r\n        }\r\n    }\r\n}\r\n<\/code><\/pre>\n<p>In the example above, we first create a SqlConnection object and initialize it with the correct connection string. Then, we open the connection using the Open method.<\/p>\n<p>Next, we created a SqlCommand object and passed in the SQL statement to be executed and the connection object. Additionally, we added two parameters, @Value1 and @Value2, which are used in the VALUES clause of the SQL statement.<\/p>\n<p>Finally, we use the ExecuteNonQuery method to execute the SQL statement and store the number of affected rows returned in a variable. We can use this value to determine if the SQL statement was successfully executed and output the results.<\/p>\n<p>Please note that after using the ExecuteNonQuery method, you should use a using statement block to close the database connection and command object in order to properly release resources.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In C#, the ExecuteNonQuery method is used to execute SQL statements and return the number of rows affected. It is usually used for executing INSERT, UPDATE, or DELETE statements as they do not return any result sets. Here is an example of how to use the ExecuteNonQuery method: using System; using System.Data.SqlClient; class Program { [&hellip;]<\/p>\n","protected":false},"author":7,"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-26811","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 ExecuteNonQuery in database operations with C# - 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-executenonquery-in-database-operations-with-c\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to use ExecuteNonQuery in database operations with C#\" \/>\n<meta property=\"og:description\" content=\"In C#, the ExecuteNonQuery method is used to execute SQL statements and return the number of rows affected. It is usually used for executing INSERT, UPDATE, or DELETE statements as they do not return any result sets. Here is an example of how to use the ExecuteNonQuery method: using System; using System.Data.SqlClient; class Program { [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-use-executenonquery-in-database-operations-with-c\/\" \/>\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-16T07:22:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T09:29:52+00:00\" \/>\n<meta name=\"author\" content=\"Sophia Anderson\" \/>\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=\"Sophia Anderson\" \/>\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-executenonquery-in-database-operations-with-c\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-executenonquery-in-database-operations-with-c\/\"},\"author\":{\"name\":\"Sophia Anderson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30\"},\"headline\":\"How to use ExecuteNonQuery in database operations with C#\",\"datePublished\":\"2024-03-16T07:22:33+00:00\",\"dateModified\":\"2024-03-22T09:29:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-executenonquery-in-database-operations-with-c\/\"},\"wordCount\":191,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-executenonquery-in-database-operations-with-c\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-executenonquery-in-database-operations-with-c\/\",\"name\":\"How to use ExecuteNonQuery in database operations with C# - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T07:22:33+00:00\",\"dateModified\":\"2024-03-22T09:29:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-executenonquery-in-database-operations-with-c\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-use-executenonquery-in-database-operations-with-c\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-executenonquery-in-database-operations-with-c\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to use ExecuteNonQuery in database operations with C#\"}]},{\"@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\/19a24313de9c988db3d69226b4a40a30\",\"name\":\"Sophia Anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"caption\":\"Sophia Anderson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to use ExecuteNonQuery in database operations with C# - 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-executenonquery-in-database-operations-with-c\/","og_locale":"en_US","og_type":"article","og_title":"How to use ExecuteNonQuery in database operations with C#","og_description":"In C#, the ExecuteNonQuery method is used to execute SQL statements and return the number of rows affected. It is usually used for executing INSERT, UPDATE, or DELETE statements as they do not return any result sets. Here is an example of how to use the ExecuteNonQuery method: using System; using System.Data.SqlClient; class Program { [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-use-executenonquery-in-database-operations-with-c\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T07:22:33+00:00","article_modified_time":"2024-03-22T09:29:52+00:00","author":"Sophia Anderson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Sophia Anderson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-executenonquery-in-database-operations-with-c\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-executenonquery-in-database-operations-with-c\/"},"author":{"name":"Sophia Anderson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30"},"headline":"How to use ExecuteNonQuery in database operations with C#","datePublished":"2024-03-16T07:22:33+00:00","dateModified":"2024-03-22T09:29:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-executenonquery-in-database-operations-with-c\/"},"wordCount":191,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-executenonquery-in-database-operations-with-c\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-use-executenonquery-in-database-operations-with-c\/","name":"How to use ExecuteNonQuery in database operations with C# - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T07:22:33+00:00","dateModified":"2024-03-22T09:29:52+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-executenonquery-in-database-operations-with-c\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-use-executenonquery-in-database-operations-with-c\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-executenonquery-in-database-operations-with-c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to use ExecuteNonQuery in database operations with C#"}]},{"@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\/19a24313de9c988db3d69226b4a40a30","name":"Sophia Anderson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","caption":"Sophia Anderson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/26811","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\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=26811"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/26811\/revisions"}],"predecessor-version":[{"id":60999,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/26811\/revisions\/60999"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=26811"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=26811"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=26811"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}