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 ExecuteScalarExample
{
	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 = "SELECT COUNT(*) FROM Customers";
			Object countResult = thisCommand.ExecuteScalar();
			Console.WriteLine("Count of Customers = {0}", countResult);

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