cdatamanage.h

来自「MFC程序开发参考大全 【明日科技】宋坤 刘锐宁 李伟明 【丛 书 名】」· C头文件 代码 · 共 104 行

#pragma once
#using "mscorlib.dll"

using namespace System;
using namespace System::ComponentModel;
using namespace System::Collections;
using namespace System::Diagnostics;
using namespace System::Data::SqlClient;
using namespace System::Data;
using namespace System::Drawing;
using namespace System::Windows::Forms;


namespace BOOKMANAGE {

	/// <summary>
	/// CDataManage 摘要
	/// </summary>
	public ref class CDataManage :  public System::Object
	{
	protected:
		SqlConnection^ FConnection;  //数据库连接对象
		String^        FConStr;      //数据库连接字符串
		SqlCommand^    FCommand;     //命令对象
		SqlDataReader^  FDataReader;  //数据阅读器

	public:
		//定义属性
		property String^ ConStr
		{
			String^  get(){return FConStr;}
			void     set(String ^ constr)
			{
				if (FConStr != constr)
					FConStr = constr;
			}
		}

		property SqlCommand^ Command
		{
			SqlCommand^ get(){return FCommand;}
		}

		property SqlDataReader^ DataReader
		{
			SqlDataReader^ get(){return FDataReader;}
			void set(SqlDataReader^ data ){FDataReader = data;}
		}

		property SqlConnection^ Connection
		{
			SqlConnection^ get(){return FConnection;}
		
		}

	bool ConnectDataBase()
	{
		
		FConnection->ConnectionString = ConStr;
		try
		{
			FConnection->Open();
		}
		catch(...)
		{
			MessageBox::Show("数据库连接失败");
			return false;
		
		}
		return true;
	}

	public:

		//构造函数
		CDataManage(void)
		{
			FConnection = gcnew SqlConnection();
			FCommand = gcnew SqlCommand();
			FCommand->Connection = FConnection;
		}

		CDataManage(String ^ constr)
		{
			FConStr = constr;
			FConnection = gcnew SqlConnection();
			FCommand = gcnew SqlCommand();
			FCommand->Connection = FConnection;
		}

	protected:
		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		~CDataManage()
		{

		}
	};
	

	
}