database.cs

开发工具：Visual Studio 2005 开发平台：Windows XP sp2 数据库：Sql server 2000 从学校走入社会

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(５１ａsｐｘ．ｃｏｍ)

/// <summary>
/// DataBase 的摘要说明
/// </summary>
public class DataBase
{
   
   
	public DataBase()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}

    public DataTable DataSelect(string Sqltext)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        con.Open();
       
        SqlDataAdapter datap = new SqlDataAdapter(Sqltext, con);
        DataTable dt = new DataTable();
        datap.Fill(dt);
       
        return dt;
    
    
    
    }
    public DataSet DataAll(string sqltxt)
    {

        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        con.Open();
        SqlDataAdapter datap = new SqlDataAdapter(sqltxt, con);
        DataSet ds = new DataSet();
        datap.Fill(ds);
        return ds;
    
    
    }
    private SqlConnection CreateConnection()
    {
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = "server=(Local);database=Address;uid=sa;pwd=sa;";
        return conn;


    }
    private SqlParameter CreateReturnValuePar()
    { 
    SqlParameter par=CreateParameter("RetrunValue",SqlDbType.Int,4,null);
        par.Direction=ParameterDirection.ReturnValue;
        return par;
    
    }
    private SqlCommand CreateCommand(string procName, params SqlParameter[] pars)
    {
        SqlCommand cmd = new SqlCommand(procName, CreateConnection());
        cmd.CommandType = CommandType.StoredProcedure;
        if (pars != null)
        {
            foreach (SqlParameter par in pars)
            {
                cmd.Parameters.Add(par);
            
            }
        
        
        
        }
        cmd.Parameters.Add(CreateReturnValuePar());
        return cmd;
    
    }
    public int ExecuteNonQuery(string ProcName, params SqlParameter[] Pars)
    {
        SqlCommand cmd = CreateCommand(ProcName, Pars);
        cmd.Connection.Open();
       
        cmd.ExecuteNonQuery();
        cmd.Connection.Close();
        
        return int.Parse(cmd.Parameters["RetrunValue"].Value.ToString());
    
    
    
    }
    public SqlDataReader ExecuteDataReader(string ProcName, params SqlParameter[] Pars)
    {
        SqlCommand cmd = CreateCommand(ProcName, Pars);
        cmd.Connection.Open();
        return cmd.ExecuteReader(CommandBehavior.CloseConnection);
    
    
    
    }

    public SqlParameter CreateParameter(string ParName, SqlDbType DbType, int Size, object ParValue)
    {
        SqlParameter par = new SqlParameter();
        par.Value = ParValue;
        par.ParameterName = ParName;
        par.SqlDbType = DbType;
        par.Size = Size;
        return par;
    
    }
  




}