C#涓璭xecutenonquery鎬庝箞浣跨敤
鍦–#涓紝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>