dbconn.cs

酒店管理系统

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Collections;

/// <summary>
/// DBConn 的摘要说明
/// </summary>
public class DBConn
{
    string str = "Data Source=ibm-c47157ea7c4;AttachDbFilename='C:\\Documents and Settings\\Angel Wu\\My Documents\\for study 2006(1)\\软件过程\\HotelManagementSystem\\App_Data\\Hotel1.mdf';Integrated Security=True";
    protected SqlConnection conn;
    
    //private string sql = null;
    //private SqlCommand comm = null;
    //private SqlDataReader reader = null;

    /// <summary>
    /// create a connection
    /// </summary>
    public DBConn()
    {
        conn = new SqlConnection(str);
    }

    /// <summary>
    /// Connect to database
    /// </summary>
    public void Open()
    {
        if (conn.State == ConnectionState.Closed)
            conn.Open();
    }

    /// <summary>
    /// Close the connection to database
    /// </summary>
    public void Close()
    {
        if (conn.State == ConnectionState.Open)
            conn.Close();
    }
}