鍦–#涓紝ExecuteNonQuery()鏂规硶鏄敤浜庢墽琛屼笉杩斿洖缁撴灉鐨凷QL璇彞锛堝INSERT銆乁PDATE銆丏ELETE绛夛級鐨勬柟娉曘€傚畠杩斿洖涓€涓暣鏁帮紝琛ㄧず琚奖鍝嶇殑琛屾暟銆?/p>

鍙互鎸夌収浠ヤ笅姝ラ鏉ヤ娇鐢?code>ExecuteNonQuery()鏂规硶锛?/p>

1. 鍒涘缓涓€涓?code>SqlConnection瀵硅薄锛屽苟鎸囧畾鏁版嵁搴撹繛鎺ュ瓧绗︿覆銆?/li>

string connectionString = "Data Source=MyServer;Initial Catalog=MyDatabase;User ID=MyUsername;Password=MyPassword;";
SqlConnection connection = new SqlConnection(connectionString);

2. 鎵撳紑鏁版嵁搴撹繛鎺ャ€?/li>

connection.Open();

3. 鍒涘缓涓€涓?code>SqlCommand瀵硅薄锛屽苟鎸囧畾SQL璇彞鍜岃繛鎺ュ璞°€?/li>

string sql = "INSERT INTO MyTable (Column1, Column2) VALUES (@Value1, @Value2)";
SqlCommand command = new SqlCommand(sql, connection);

4. 璁剧疆SQL璇彞涓殑鍙傛暟锛堝彲閫夛級銆?/li>

command.Parameters.AddWithValue("@Value1", value1);
command.Parameters.AddWithValue("@Value2", value2);

5. 鎵цSQL璇彞锛屽苟鑾峰彇鍙楀奖鍝嶇殑琛屾暟銆?/li>

int rowsAffected = command.ExecuteNonQuery();

6. 鍏抽棴鏁版嵁搴撹繛鎺ャ€?/li>

connection.Close();

鍦ㄦ墽琛?code>ExecuteNonQuery()鏂规硶涔嬪悗锛屼綘鍙互浣跨敤rowsAffected鍙橀噺鏉ヨ幏鍙栧彈褰卞搷鐨勮鏁般€?/p>