ADO.Net Execute Store Procedure

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11411056/viewspace-734394/