datasethelpersql.cs

用于c#.net数据库操作的类库。能把结婚集以数组的形成操作。

using System;

namespace EnterpriseObjects
{
	/// <summary>
	/// DataSetHelperSql 的摘要说明。
	/// </summary>
	public class DataSetHelperSql:IDataSetHelper,IDisposable
	{
		private System.Data.SqlClient.SqlConnection _con;
		private System.Data.SqlClient.SqlDataAdapter _adpt;
		private System.Data.DataSet _ds;

		public DataSetHelperSql(System.Data.SqlClient.SqlConnection con,System.Data.SqlClient.SqlDataAdapter adpt,System.Data.DataSet ds)
		{
			_con=con;
			_adpt=adpt;
			_ds=ds;
		}

		#region IDataSetHelper 成员

		public System.Data.DataSet DataSet
		{
			get
			{
				return _ds;
			}
		}

		public void Update()
		{
			try
			{
				_con.Open();
				System.Data.SqlClient.SqlCommandBuilder sqlbder=new System.Data.SqlClient.SqlCommandBuilder(_adpt);
				_adpt.UpdateCommand=sqlbder.GetUpdateCommand();
				_adpt.DeleteCommand=sqlbder.GetDeleteCommand();
				_adpt.InsertCommand=sqlbder.GetInsertCommand();
				_adpt.Update(_ds);
				_con.Close();
			}
			catch
			{
			}
		}

		#endregion

		#region IDisposable 成员

		public void Dispose()
		{
			if(null!=_con)
			{
				_con.Dispose();
			}
			if(null!=_adpt)
			{
				_adpt.Dispose();
			}
			if(null!=_ds)
			{
				_ds.Dispose();
			}
			_con=null;
			_adpt=null;
			_ds=null;
		}

		#endregion
	}
}