database.cs

资产数据库设计

using System;

namespace AdminGoods
{
	/// <summary>
	/// Database 的摘要说明。
	/// </summary>
	public class Database
	{
		//本地数据库
		public   string  ConnectionString="data source=localhost;initial catalog=xhl;user id=sa;password=sa";
		private System.Data.SqlClient.SqlConnection conn;


		public Database()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

		public System.Data.SqlClient.SqlConnection openConn()
		{
			try
			{
				conn = new System.Data.SqlClient.SqlConnection();
				conn.ConnectionString = this.ConnectionString;
				conn.Open();
			}
			catch(Exception ex)
			{
				string e = ex.Message;

				conn = null;
			}

			return conn;
		}


		public void closeConn()
		{
			conn.Close();
		}
	}
}