1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Web;
  5using System.Web.Security;
  6using System.Web.UI;
  7using System.Web.UI.WebControls;
  8using System.Web.UI.WebControls.WebParts;
  9using System.Web.UI.HtmlControls;
 10using System.Data.SqlClient;
 11//该源码下载自www.51aspx.com(５１aｓpｘ．ｃｏｍ)
 12
 13/**//// <summary>
 14/// SqlData 的摘要说明
 15/// </summary>
 16public class SqlData
 17...{
 18    类中的全局变量#region  类中的全局变量
 19
 20    private SqlConnection sqlcon;  //申明一个SqlConnection对象
 21    private SqlCommand sqlcom;   //申明一个SqlCommand对象
 22    private SqlDataAdapter sqldata;   //申明一个SqlDataAdapter对象
 23
 24    #endregion
 25
 26    构造函数#region  构造函数
 27
 28    /**//// <summary>
 29    /// 创建时间:2006-4-26
 30    /// 创建人:许文武
 31    /// 构造函数，初始化时连接数据库
 32    /// </summary>
 33    public SqlData()
 34    ...{
 35        sqlcon = new SqlConnection(ConfigurationManager.AppSettings["conStr"]);
 36        sqlcon.Open();   //打开链接
 37    }
 38
 39    #endregion
 40
 41    执行SQL语句#region  执行SQL语句
 42    /**//// <summary>
 43    /// 此方法用来执行SQL语句
 44    /// </summary>
 45    /// <param name="SqlCom">要执行的SQL语句</param>
 46    /// <returns></returns>
 47    public bool ExceSQL(string strSqlCom)
 48    ...{
 49        sqlcom = new SqlCommand(strSqlCom, sqlcon);
 50        try
 51        ...{
 52            sqlcom.ExecuteNonQuery();
 53            return true;
 54        }
 55        catch
 56        ...{
 57            return false;
 58        }
 59        finally
 60        ...{
 61            sqlcon.Close();
 62        }
 63        //return true;
 64    }
 65    #endregion
 66
 67    返回DataSet类型数据#region  返回DataSet类型数据
 68    /**//// <summary>
 69    /// 此方法返回一个DataSet类型
 70    /// </summary>
 71    /// <param name="SqlCom">要执行的SQL语句</param>
 72    /// <returns></returns>
 73    public DataSet ExceDS(string SqlCom)
 74    ...{
 75        try
 76        ...{
 77            sqlcom = new SqlCommand(SqlCom, sqlcon);
 78            sqldata = new SqlDataAdapter();
 79            sqldata.SelectCommand = sqlcom;
 80            DataSet ds = new DataSet();
 81            sqldata.Fill(ds);
 82            return ds;
 83        }
 84        finally
 85        ...{
 86            sqlcon.Close();
 87        }
 88    }
 89    #endregion
 90
 91    返回SqlDataReader类型的数据#region  返回SqlDataReader类型的数据
 92    /**//// <summary>
 93    /// 此方法返回一个SqlDataReader类型的参数
 94    /// </summary>
 95    /// <param name="SqlCom"></param>
 96    /// <returns></returns>
 97    public SqlDataReader ExceRead(string SqlCom)
 98    ...{
 99        sqlcom = new SqlCommand(SqlCom, sqlcon);
100        SqlDataReader read = sqlcom.ExecuteReader();
101        return read;
102    }
103    #endregion
104}
105