database.cs

可以实现用户的添加、修改及模糊搜索及登陆验证 将DB_51aspx文件里面的 数据库文件 附加就可以了 数据库为(Sqlserver 2005 ) 帐号/密码: 51aspx/51aspx We

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
//该源码下载自www.51aspx.com(５１aｓpｘ．ｃｏｍ)

/// <summary>
/// 数据库操作类
/// </summary>
public class DataBase
{
    private string _connstr=ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
    public SqlConnection objConn;
    private SqlCommand Cmd = null;
    private SqlDataAdapter Da = null;
    private DataSet Ds = null;
    private DataTable Dt = null;
	public DataBase()
	{
        //实例化objConn 连接
        objConn = new SqlConnection(_connstr);
	}
    /// <summary>
    /// Sql Server ---- 连接字符串
    /// </summary>
    public string ConnStr
    {
        get { return _connstr; }
        set { _connstr = value; }
    }
    /// <summary>
    ///传入参数  执行并返回 SqlCommand 命令 
    /// </summary>
    /// <param name="Sqlstr">Sql字符串</param>
    /// <param name="parms">参数</param>
    /// <returns></returns>
    protected SqlCommand ExecuteCmd(string Sqlstr,SqlParameter[] parms)
    {
        Cmd = new SqlCommand(Sqlstr,objConn);
        foreach(SqlParameter parm in parms)
        {
            Cmd.Parameters.Add(parm);
        }
        return Cmd;
    }
    protected SqlCommand ExecuteCmd(string Sqlstr)
    {
        Cmd = new SqlCommand(Sqlstr, objConn);
        return Cmd;
    }
    protected SqlDataAdapter ExecuteDataAdpter(string Sqlstr)
    {
        Da = new SqlDataAdapter(Sqlstr, objConn);
        return Da;
    }
    /// <summary>
    /// 返回 DataSet
    /// </summary>
    /// <param name="Cmd"></param>
    /// <returns></returns>
    protected DataSet ExecuteDataSet(SqlCommand Cmd)
    {
        Da = new SqlDataAdapter();
        Da.SelectCommand = Cmd;
        Ds = new DataSet();
        Da.Fill(Ds);
        return Ds;
    }
    /// <summary>
    /// 返回 DataTable
    /// </summary>
    /// <param name="Cmd"></param>
    /// <returns></returns>
    protected DataTable ExecuteDataTable(SqlCommand Cmd)
    {
        Da = new SqlDataAdapter();
        Da.SelectCommand = Cmd;
        Dt = new DataTable();
        Da.Fill(Dt);
        return Dt;
    }
}