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

#endregion

namespace SQLStoredProcedure
{
	class Program
	{
		static void Main(string[] args)
		{
			// Specify SQL Server-specific connection string
			SqlConnection thisConnection = new SqlConnection(
				@"Server=(local)\sqlexpress;Integrated Security=True;" +
				"Database=northwind");


			// Open connection
			thisConnection.Open();

			// Create command for this connection
			SqlCommand thisCommand = thisConnection.CreateCommand();

			// Set command to Stored Procedure type.
			thisCommand.CommandType = CommandType.StoredProcedure;
			thisCommand.CommandText =
				 "Ten Most Expensive Products";

			// Execute DataReader for specified command
			SqlDataReader thisReader = thisCommand.ExecuteReader();

			// While there are rows to read
			while (thisReader.Read())
			{
				// Output product name and price columns
				Console.WriteLine("\t{0}\t{1}",
				thisReader["TenMostExpensiveProducts"], thisReader["UnitPrice"]);
			}

			// Close reader
			thisReader.Close();

			// Close connection
			thisConnection.Close();

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

		}
	}
}