program.cs

讲述如何使用c#访问关系数据库

#region Using directives

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;

#endregion

namespace ExecuteNonQueryExample
{
	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();

			Console.Write("Program finished, press Enter/Return to continue:");
			Console.ReadLine();
		}
	}
}