鍦–#涓紝ExecuteNonQuery鏂规硶鐢ㄤ簬鎵ц涓嶈繑鍥炵粨鏋滅殑SQL璇彞锛屼緥濡侷NSERT銆乁PDATE銆丏ELETE绛夈€?/p>

浠ヤ笅鏄娇鐢‥xecuteNonQuery鏂规硶鐨勭ず渚嬶細

using System;
using System.Data.SqlClient;
class Program
{
static void Main()
{
string connectionString = "Data Source=YourServer;Initial Catalog=YourDatabase;User ID=YourUsername;Password=YourPassword";
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
string sql = "INSERT INTO Customers (FirstName, LastName) VALUES ('John', 'Doe')";
using (SqlCommand command = new SqlCommand(sql, connection))
{
int rowsAffected = command.ExecuteNonQuery();
Console.WriteLine("Rows affected: " + rowsAffected);
}
}
}
}

鍦ㄤ笂闈㈢殑绀轰緥涓紝棣栧厛鍒涘缓浜嗕竴涓猄qlConnection瀵硅薄鏉ュ缓绔嬩笌鏁版嵁搴撶殑杩炴帴銆傜劧鍚庯紝浣跨敤Open鏂规硶鎵撳紑杩炴帴銆?/p>

鎺ヤ笅鏉ワ紝瀹氫箟浜嗕竴涓猄QL璇彞锛屽皢涓€鏉℃柊鐨勮褰曟彃鍏ュ埌鍚嶄负Customers鐨勮〃涓€?/p>

鐒跺悗锛屼娇鐢⊿qlCommand瀵硅薄鍜孲qlConnection瀵硅薄涓€璧蜂娇鐢‥xecuteNonQuery鏂规硶鏉ユ墽琛孲QL璇彞銆侲xecuteNonQuery鏂规硶杩斿洖涓€涓暣鏁帮紝琛ㄧず鍙楀奖鍝嶇殑琛屾暟銆?/p>

鏈€鍚庯紝鍏抽棴杩炴帴骞舵墦鍗板彈褰卞搷鐨勮鏁般€?/p>

璇锋敞鎰忥紝涓婅堪绀轰緥涓殑杩炴帴瀛楃涓查渶瑕佹牴鎹疄闄呮儏鍐佃繘琛屼慨鏀癸紝浠ヤ究杩炴帴鍒版纭殑鏁版嵁搴撴湇鍔″櫒鍜屾暟鎹簱銆?/p>