connectioncontrol.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;

/// <summary>
/// ConnectionControl 的摘要说明
/// </summary>
/// 
namespace DataControl
{
    public class ConnectionControl
    {
        private SqlConnection conn;
        
        public ConnectionControl()
        {

        }
        //用来连接数据库
        public void DataConnetion()
        {
            string connstr = ConfigurationSettings.AppSettings["dsn"];
            conn = new SqlConnection(connstr);
            conn.Open();
        }
        public SqlCommand  DataCmd(string comstr)
        {
            SqlCommand cmd = new SqlCommand(comstr, conn);
            return cmd;
        }
        public void Close()
       {
           conn.Close();
           
       }
    }
}