class1.cs

完成一个网上书店系统

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
/// <summary>
///Class1 的摘要说明
/// </summary>
public class Class1
{
    private SqlConnection con;

    #region 打开关闭数据库
    private void open()
    {
        con = new SqlConnection("server=.;database=BookShop;uid=sa;pwd=sa");

        if (con.State == System.Data.ConnectionState.Closed)
            con.Open();
    }
    private void close()
    {
        if (con != null)
            con.Close();
    }
    #endregion
    #region 执行sql语句返回SqlDataReader对象
    public SqlDataReader Reader(string sqlstr)
    {
        SqlDataReader dr = null;
        try
        {
            open();
            SqlCommand cmd = new SqlCommand(sqlstr, con);
            dr = cmd.ExecuteReader();
        }
        catch
        {
            dr.Close();
            close();
            throw;
        }
        return dr;
    }
    #endregion
    #region 执行sql语句返回真假

    public bool ExecSql(string sqlstr)
    {

        try
        {
            open();
            SqlCommand cmd = new SqlCommand(sqlstr, con);
            cmd.ExecuteNonQuery();
            return true;
        }
        catch
        {
            return false;
            close();
            throw;
        }

    }
    #endregion

    #region 执行sql语句返回DataSet

    public DataSet createdataset(string sqlstr)
    {
        DataSet ds = new DataSet();
        try
        {

            open();
            SqlDataAdapter ada = new SqlDataAdapter(sqlstr, con);
            ada.Fill(ds);

        }
        catch
        {

            close();
            throw;
        }
        return ds;
    }
    #endregion
	
}