Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Execute NonQuery Example

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