/// <summary> /// Executes the stored procedure and returns a <see cref="System.Data.DataSet"/>. /// </summary> /// <param name="parameters">A <see cref="System.Object"/> array containing zero of more parameters values</param> /// <returns><see cref="System.Data.DataSet"/></returns> public DataSet ExecuteDataSet(params object[] parameters) { FillParameters(parameters); Connection.ExecutionType executionType = mFillSchema ? Connection.ExecutionType.ExecuteDataSetWithSchema : Connection.ExecutionType.ExecuteDataSet; return((DataSet)mConnection.ExecuteCommand(executionType, mSqlCommand)); }
/// <summary> /// Executes the stored procedure and returns a <see cref="System.Data.DataTable"/>. /// </summary> /// <example> /// The following example shows how to execute a stored procedure and populate a <see cref="System.Data.DataTable"/>. /// <code> /// <![CDATA[ /// Connection connection = new Connection(); /// DataTable customerDataTable = connection.StoredProcedures["GetCustomerList"].ExecuteDataTable(); /// ]]> /// </code> /// </example> /// <param name="parameters">A <see cref="System.Object"/> array containing zero of more parameters values</param> /// <returns><see cref="System.Data.DataTable"/></returns> public DataTable ExecuteDataTable(params object[] parameters) { FillParameters(parameters); Connection.ExecutionType executionType = mFillSchema == true ? Connection.ExecutionType.ExecuteDataTableWithSchema : Connection.ExecutionType.ExecuteDataTable; return((DataTable)mConnection.ExecuteCommand(executionType, mSqlCommand)); }
/// <summary> /// Executes the stored procedure and returns a <see cref="System.Data.DataSet"/>. /// </summary> /// <returns><see cref="System.Data.DataSet"/></returns> public DataSet ExecuteDataSet() { Connection.ExecutionType executionType = mFillSchema ? Connection.ExecutionType.ExecuteDataSetWithSchema : Connection.ExecutionType.ExecuteDataSet; return((DataSet)mConnection.ExecuteCommand(executionType, mSqlCommand)); }
/// <summary> /// Executes the stored procedure and returns a <see cref="System.Data.DataTable"/>. /// </summary> /// <returns><see cref="System.Data.DataTable"/></returns> public DataTable ExecuteDataTable() { Connection.ExecutionType executionType = mFillSchema == true ? Connection.ExecutionType.ExecuteDataTableWithSchema : Connection.ExecutionType.ExecuteDataTable; return((DataTable)mConnection.ExecuteCommand(executionType, mSqlCommand)); }