dataupdate.cs

Csharp实例编程百例.rar

using System;
using System.Data;
using System.Data.OleDb;

namespace DataUpdateApp
{
	/// <summary>
	/// Class1 的摘要说明。
	/// </summary>
	class DataUpdate
	{
		/// <summary>
		/// 应用程序的主入口点。
		/// </summary>
		[STAThread]
		static void Main(string[] args)
		{
			OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\C#Program\C#100\Chapter3\NWIND.mdb");
			connection.Open();

			OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT * FROM Employees",connection);

			OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter);

			DataSet dataset = new DataSet();
			
			adapter.Fill(dataset,"Employees");

            Console.WriteLine("name before change:{0}",dataset.Tables["Employees"].Rows[5]["FirstName"]);
			dataset.Tables["Employees"].Rows[5]["FirstName"] = "Andrew";

			adapter.Update(dataset,"Employees");

			Console.WriteLine("name after change:{0}",dataset.Tables["Employees"].Rows[5]["FirstName"]);
			
			connection.Close();

		}
	}
}