Execute NonQuery Example : SqlCommand Update : ADO.Net C# Examples

    
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();

        }
}