dataoperate.cs

图书管理系统是典型的信息管理系统(MIS)

using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace BookShop.DataAccess
{
	/// <summary>
	/// DataOperate 的摘要说明。
	/// </summary>
	public class DataOperate
	{
		private SqlConnection objSqlConnection;
		private SqlDataAdapter sqlDataAdapter;
		private SqlCommand sqlCommand;
		private SqlDataReader reader;
		
		//private SqlTransaction sqlTransaction;

		public DataOperate()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
            objSqlConnection=new SqlConnection("server=(local);uid=sa;pwd=sa;database=bookshop");
			objSqlConnection.Open();
		}
		public SqlDataReader selectTable(string sql)
		{
			sqlCommand=new SqlCommand(sql,objSqlConnection);
			try
			{
				reader=sqlCommand.ExecuteReader();
			}
			catch(Exception ex)
			{
				MessageBox.Show(ex.ToString());
			}
			
			return reader;

		}
		/*public void dataGridP(DataGrid d,string sql,string name)
		{
		  objDataSet=GetDataSetBySql(sql,name);
		  d.SetDataBinding(objDataSet,name);
		}*/
		public DataSet GetDataSetBySql(string sqlQuery)
		{
			
		    DataSet objDataSet=new DataSet();
			sqlDataAdapter=new SqlDataAdapter(sqlQuery,objSqlConnection);
			sqlCommand=objSqlConnection.CreateCommand();
			sqlCommand.CommandText=sqlQuery;
			sqlDataAdapter.SelectCommand=sqlCommand;
			try
			{
			sqlDataAdapter.Fill(objDataSet,"bookInfo");
				
			}
			catch(Exception ex)
			{
			MessageBox.Show(ex.Message);

			}
			return objDataSet;
		}
		public bool UpdateDataTable(string sqlQuery)
		{
			sqlCommand=objSqlConnection.CreateCommand();
			sqlCommand.CommandText=sqlQuery;
			try
			{
				sqlCommand.ExecuteNonQuery();
			}
			catch(Exception ex)
			{
			MessageBox.Show(ex.ToString());
				throw ex;
			}
			return true;
		}

	}
}