asp.net数据库操作类

asp.net数据库操作类(存储过程处理)
时间:2010-02-04 16:20:16来源:网络 作者:未知 点击:0次 

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.ComponentModel;
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.ComponentModel;

namespace SQLHelper
{
 /// <summary>
 /// Class1 的摘要说明。
 /// </summary>
 public class SQLHelper
 {
  // 连接数据源
  private SqlConnection myConnection;
  private readonly string RETURNVALUE = "RETURNVALUE";

  /// <summary>
  /// 打开数据库连接.
  /// </summary>
  private void Open() 
  {

   // 打开数据库连接
   if (myConnection == null) 
   {
    myConnection = new SqlConnection(ConfigurationSettings.AppSettings["SQLCONNECTIONSTRING"].ToString());    
   }    
   if(myConnection.State == ConnectionState.Closed)
   {   
    try
    {
     ///打开数据库连接
     myConnection.Open();
    }
    catch(Exception ex)
    {
     SystemError.SystemLog(ex.Message);
    }
    finally
    {
     ///关闭已经打开的数据库连接    
    }
   }
  }

  /// <summary>
  /// 关闭数据库连接
  /// </summary>
  public void Close() 
  {
   ///判断连接是否已经创建
   if(myConnection != null)