database.cs

简单的学生成绩管理系统。实现学生成绩学号管理

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

namespace 教务管理系统
{
	/// <summary>
	/// DataBase 的摘要说明。
	/// </summary>
	public class DataBase : IDisposable
	{
		private SqlConnection SqlConn ;
		public static string sConn = "Persist Security Info=False;Integrated Security=SSPI;database=eisbook;server=localhost;Connect Timeout=30";

		public void Dispose()
		{
			Dispose( true );
			GC.SuppressFinalize( true );
		}

		protected void Dispose( bool disposing )
		{
			if ( disposing )
				return;
			if ( SqlConn != null )
			{
				SqlConn.Dispose();
				SqlConn = null;
			}
		}

		public void Open()
		{
			if ( SqlConn == null )
			{
				SqlConn = new SqlConnection( sConn );
				SqlConn.Open();
			}
		}

		public void Close()
		{
			if ( SqlConn != null )
				SqlConn.Close();
		}

		public DataView RunSelectSQL( string sSQLString )
		{
			this.Open();
			DataSet SqlDS = new DataSet();
			SqlDataAdapter SqlDA = new SqlDataAdapter( sSQLString, this.SqlConn );
			SqlDA.Fill( SqlDS );
			return SqlDS.Tables[ 0 ].DefaultView;
		}

		public void RunDelOrInsSQL( string sSQLString )
		{
			this.Open();
			SqlCommand SqlComm = new SqlCommand( sSQLString, this.SqlConn );
			SqlComm.ExecuteNonQuery();
		}
		public DataBase()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
	}
}