dbtools.cs

来自「ASP.NET 2.0动态网站设计实例源代码,本书介绍了ASP.NET2.0的基」· CS 代码 · 共 56 行

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.Sql;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;

namespace tsingjun.NewsSQL
{
    class DBTools
    {
        /// <summary>
        /// 创建存储过程
        /// </summary>
        /// <param name="pCommendText">创建存储过程的SQL语句</param>
        static public void CreateStoredProcedure(string pCommendText)
        {
            SqlPipe sp = SqlContext.Pipe;
            using (SqlConnection con = new SqlConnection("context connection=true"))
            {
                con.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.CommandType = CommandType.Text;
                cmd.Connection = con;
                cmd.CommandText =pCommendText;
                SqlDataReader rdr = cmd.ExecuteReader();
                sp.Send(rdr);
            }
        }
        /// <summary>
        /// 创建存储过程
        /// </summary>
        /// <param name="pCommendText">创建存储过程的SQL语句</param>
        /// <param name="pParms">存储过程中用的参数</param>
        static public void CreateStoredProcedure(string pCommendText, SqlParameter[] pParms)
        {
            using (SqlConnection conn = new SqlConnection("context connection=true"))
            {
                conn.Open();
                SqlPipe sp = SqlContext.Pipe;
                SqlCommand cmd = new SqlCommand();
                cmd.CommandType = CommandType.Text;
                cmd.Connection = conn;
                cmd.CommandText = pCommendText;
                for(int i=0;i<pParms.Length;i++)
                cmd.Parameters.Add(pParms[i]);
                SqlDataReader rdr = cmd.ExecuteReader();
                sp.Send(rdr);
            }
        }
        
    }
}