Utils/DataManager.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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

namespace IndiaStudyChannel.Utils
{
	/// <summary>
	/// Summary description for DataManager.
	/// </summary>
    /// 由 liudao 翻译整理
    /// 该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)
	public class DataManager
	{
		public DataManager()
		{
		}

		public static DataTable ExecuteQuery(string query)
		{
			string connectionString = System.Configuration.ConfigurationSettings.AppSettings["connectionString"];
			SqlConnection connection = new SqlConnection(connectionString);
			connection.Open();
			
			try
			{
				SqlDataAdapter adapter = new SqlDataAdapter(query, connection);
				DataSet ds = new DataSet();
				adapter.Fill(ds);

				return ds.Tables[0];
			}
			finally
			{
				if ( connection.State == ConnectionState.Open )
					connection.Close();
			}
		}


		public static void ExecuteNonQuery(string query)
		{
			string connectionString = System.Configuration.ConfigurationSettings.AppSettings["connectionString"];
			SqlConnection connection = new SqlConnection(connectionString);
			connection.Open();
			
			try
			{
				SqlCommand cmd = new SqlCommand();
				cmd = connection.CreateCommand();
				cmd.CommandType = CommandType.Text;
				cmd.CommandText = query;

				cmd.ExecuteNonQuery();
			}
			finally
			{
				if ( connection.State == ConnectionState.Open )
					connection.Close();
			}
		}