database.cs

一个简单的个人课程管理系统 主要功能有登陆 个人课程查看 添加 删除等

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Configuration;

/// <summary>
/// DataBase 的摘要说明
/// </summary>
public class DataBase
{
    protected SqlConnection Connection;
    protected string ConnectionString;
	public DataBase()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
        ConnectionString = ConfigurationSettings.AppSettings["DB"];
	}
    ~DataBase()
    {
        try
        {
            if(Connection!=null)
                Connection.Close();
        }                                //关闭数据库
        catch{}
        try
        {
            Dispose();
        }
        catch { };
    }

    public  void Dispose()
    {
        //确保连接被关闭
        if(Connection!=null)
        {
           Connection.Dispose();
            Connection=null;
        }
    }
    protected void Open()
    {
        if(Connection==null)
        {
            Connection=new SqlConnection(ConnectionString);
        }
        if(Connection.State.Equals(ConnectionState.Closed))
        {
            Connection.Open();
        }                              //保护方法，打开数据库
    }
    public void Close()
    {
        if(Connection!=null)
            Connection.Close();        //关闭数据库连接
    }
    public int ExecuteSQL(String SqlString)
    {
        int count=-1;
        Open();
        try
        {
            SqlCommand cmd=new SqlCommand(SqlString,Connection);
            count=cmd.ExecuteNonQuery();
        }                                      //执行语句
        catch
        {
          count=-1;
        }
        finally
        {
            Close();
        }
        return count;
    }
    public DataSet GetDataSet(String SqlString)
    {
        Open();
        SqlDataAdapter adapter=new  SqlDataAdapter(SqlString,Connection);
        DataSet dataset=new DataSet();
        adapter.Fill(dataset);
        Close();
        return dataset;                  //获取数据，返回dataset
    }
    public DataRow GetDataRow(String SqlString)
    {
        DataSet dataset=GetDataSet(SqlString);
      
        dataset.CaseSensitive=false;
        if(dataset.Tables[0].Rows.Count>0)
        {
            return dataset.Tables[0].Rows[0];                //获取数据，返回datarow
        }
        else
        {
            return null;
        }
    }
}