datasetdbconnect.cs

.NET编写的小型图书管理系统,里面有详细说明,源码,发布软件包和数据库文件,本人本科时设计编写

using System.Data;
using System.Data.SqlClient;

namespace bookShop.classLib.dbLib
{
	/// <summary>
	/// DataSetDBConnect 的摘要说明。
	/// </summary>
	public class DataSetDBConnect:DBConnect
	{
		private DataSet objDataSet=new DataSet();
		private string table;
		private SqlDataAdapter objAdapter;
		public DataSet ObjDataSet
		{
			get { return objDataSet;}
		}
		public DataSetDBConnect(string table)
		{
			this.table=table;
		}
		public override void Do()
		{
			objAdapter=new SqlDataAdapter(strSQL,objConnection);
			objAdapter.Fill(objDataSet,table);
		}
		public void WriteBack()
		{
			SqlCommandBuilder objBuilder=new SqlCommandBuilder(objAdapter);
			objAdapter.UpdateCommand=objBuilder.GetUpdateCommand();
            objAdapter.InsertCommand=objBuilder.GetInsertCommand();
			objAdapter.DeleteCommand=objBuilder.GetDeleteCommand();
			objAdapter.Update(objDataSet,table);
		}
	}
}