sqlconn.cs

阿江酷站统计系统ASP.Net版,可以直接使用。和现有的网站合并就可以了。提供详细的IP分析。

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

namespace counter
{
	/// <summary>
	/// SQLConn 的摘要说明。
	/// </summary>
	public class SQLConn
	{
		private  static string GetSqlConnString()
			{
				string strSqlConnstring=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
				return strSqlConnstring;
			}

		public static int ExecuteSql(string strSQL)
		{
			SqlConnection MyConn = new SqlConnection(GetSqlConnString());
			SqlCommand MyComm = new SqlCommand(strSQL, MyConn);
			try
			{
				MyConn.Open();
				MyComm.ExecuteNonQuery();
				return 0;
			}
			catch(System.Data.SqlClient.SqlException e)
			{				
				throw new Exception(e.Message);
			}
			finally
			{
				MyComm.Dispose();
				MyConn.Close();
			}

		}

		public static DataSet ExecuteSqlForDataSet(string strSQL)
		{
			SqlConnection MyConn = new SqlConnection(GetSqlConnString());			
			try
			{
				MyConn.Open();
				
				SqlDataAdapter MyAdapter = new SqlDataAdapter(strSQL,MyConn);
				DataSet ds = new DataSet();
				MyAdapter.Fill(ds);
				return ds;
			}
			catch(System.Data.SqlClient.SqlException e)
			{				
				throw new Exception(e.Message);
			}
			finally
			{
				MyConn.Close();
			}
		}

		public static DataSet ExecuteSqlForDataSetPageing(string strSQL,int startindex,int pagesize,string tablename)
		{
			SqlConnection MyConn = new SqlConnection(GetSqlConnString());			
			try
			{
				MyConn.Open();
				
				SqlDataAdapter MyAdapter = new SqlDataAdapter(strSQL,MyConn);
				DataSet ds = new DataSet();
				MyAdapter.Fill(ds,startindex,pagesize,tablename);
				return ds;
			}
			catch(System.Data.SqlClient.SqlException e)
			{				
				throw new Exception(e.Message);
			}
			finally
			{
				MyConn.Close();
			}
		}


	}
}