dbtools.cs

ASP.NET 2.0动态网站设计实例源代码,本书介绍了ASP.NET2.0的基础知识

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;

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);
  }
 }

}