dataconn.cs

来自「库存管理系统,对企业仓库的产品进行管理,使用C#语句 .net 平台开发」· CS 代码 · 共 30 行

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace FORU_SMS_.BaseClass
{
    public class DataConn
    {
        protected SqlConnection Conn;

        public SqlConnection OpenConn()
        {
            Conn = new SqlConnection(@"Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDirectory|\FORUSMS.MDF;Integrated Security=True; User Instance = True");
            Conn.Open();
            return Conn;
        }
        //关闭数据库
        public void CloseConn()
        {
            if (Conn.State == ConnectionState.Open)
            {
                Conn.Close();
                Conn.Dispose();
            }
        }
    }
}