connection.cs

来自「网络营销软件的源代码」· CS 代码 · 共 42 行

using System;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;


namespace WebApplication8.firstPage
{
	/// <summary>
	/// Connection 的摘要说明。
	/// </summary>
	public class Connection
	{
		SqlConnection connection;
		SqlCommand command;

		public Connection(string c)
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
			connection = new SqlConnection();
			command = new SqlCommand();

			connection.ConnectionString = c;
			command.Connection = connection;
			connection.Open();
		}

		public SqlDataReader execute(string sql)
		{
			command.CommandText = sql;
			return command.ExecuteReader();
		}

		public void close()
		{
			connection.Close();
		}
	}
}