SagaDB.MSSQLOperator.ExeProcedure C# (CSharp) Method

ExeProcedure() public method

ִ�д洢����
public ExeProcedure ( string p_ProcedureName, SqlParameter p_SqlParameterArray ) : void
p_ProcedureName string �洢������
p_SqlParameterArray System.Data.SqlClient.SqlParameter �洢���̲���
return void
        public void ExeProcedure(string p_ProcedureName, SqlParameter[] p_SqlParameterArray)
        {
            // ��
            this.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = p_ProcedureName;
            cmd.Connection = this._conn;
            cmd.CommandType = CommandType.StoredProcedure;
            foreach (SqlParameter Sq in p_SqlParameterArray)
            {
                cmd.Parameters.Add( Sq);
            }
            cmd.ExecuteNonQuery();
            // �ͷ�
            //this.Close();
        }

Same methods

MSSQLOperator::ExeProcedure ( string p_ProcedureName, SqlParameter p_SqlParameterArray, int p_TableIndex ) : DataSet