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 DataSetRead
{
	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");

			// Create DataAdapter object 
			SqlDataAdapter thisAdapter = new SqlDataAdapter(
				 "SELECT CustomerID, ContactName FROM Customers", thisConnection);

			// Create DataSet to contain related data tables, rows, and columns
			DataSet thisDataSet = new DataSet();

			// Fill DataSet using query defined previously for DataAdapter
			thisAdapter.Fill(thisDataSet, "Customers");
			foreach (DataRow theRow in thisDataSet.Tables["Customers"].Rows)
			{
				Console.WriteLine(theRow["CustomerID"] + "\t" +
													  theRow["ContactName"]);
			}

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

		}
	}
}