ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ADO.Net Execute Store Procedure

ADO.Net Execute Store Procedure

原创 Linux操作系统 作者:ljm0211 时间:2012-07-02 17:17:29 0 删除 编辑
public void sendTakeBackMail(string InstrumentNo, string InstrumentStatus)
   {
    try
    {
     string strProcedureName;
     strProcedureName = "BirdMail_TakeBack";
     System.Data.IDbDataParameter[] bjParameters = new System.Data.SqlClient.SqlParameter[]
            {new System.Data.SqlClient.SqlParameter("@InstrumentNo", InstrumentNo)
             , new System.Data.SqlClient.SqlParameter("@Status", InstrumentStatus)};
    
     this.DataBaseManager.ExecuteStoredProcedureNoneQuery(strProcedureName,objParameters);
    }
    catch
    {
     throw;
    }
   }
#region public void/DataSet ExecuteStoredProcedure
                   ///
                   /// Execute Store Procedure & None Reture
                   ///

                   /// Store Procedure Name
                   /// Parameters
                   public void ExecuteStoredProcedureNoneQuery(string p_strProcedureName,IDataParameter[] p_objParameters)
                   {
                            this.CreateCommand();
                            m_Command.CommandType = CommandType.StoredProcedure;
                            m_Command.CommandText = p_strProcedureName.Trim();
                            for(int intI=0;intI                                   m_Command.Parameters.Add(p_objParameters[intI]);
                            m_Command.ExecuteNonQuery();
            this.CloseCommand();
                            if(this.IsInTransaction==false)
                                     this.CloseDataBase();
                   }
                   ///
                   /// Execute Store Procedure & return DataSet
                   ///

                   /// Store Procedure Name
                   /// Parameters
                   /// DataSet
                   public DataSet ExecuteStoredProcedure(string p_strProcedureName,IDataParameter[] p_objParameters)
                   {
                            DataSet myDataSet;
                            myDataSet = new DataSet();
                            this.CreateDataAdapter();
          m_DataAdapter.SelectCommand.CommandText = p_strProcedureName.Trim();
                            m_DataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
                            for(int intI=0;intIm_DataAdapter.SelectCommand.Parameters.Add(p_objParameters[intI]);
                            m_DataAdapter.Fill(myDataSet);
                          if(this.IsInTransaction==false)
                                     this.CloseDataBase();
                           return myDataSet;
                  }

                   #endregion

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11411056/viewspace-734394/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-05-14

  • 博文量
    272
  • 访问量
    436881