Execute NonQuery Example: update : SqlCommand Update « ADO.Net « C# / CSharp Tutorial

1. C# / CSharp Tutorial
2. ADO.Net
3. SqlCommand Update

using System;
using System.Data;            // Use ADO.NET namespace
using System.Data.SqlClient;  // Use SQL Server data provider namespace
using System.Collections.Generic;
using System.Text;

class Program {
    static void Main(string[] args) {
        SqlConnection thisConnection = new SqlConnection(
             @"Server=(local)\sqlexpress;Integrated Security=True;" +
             "Database=northwind");
        thisConnection.Open();

        SqlCommand thisCommand = thisConnection.CreateCommand();
        thisCommand.CommandText = "UPDATE Products SET " +
             "UnitPrice=UnitPrice*1.05 WHERE SupplierId=12";
        int rowsAffected = thisCommand.ExecuteNonQuery();
        Console.WriteLine("Rows Updated = {0}", rowsAffected);
        thisConnection.Close();

    }
}