C# 클래스 MySql.Data.MySqlClient.MySqlCommand

상속: ICloneable, IDisposable

파일 보기 프로젝트 열기: elevate/mysqlconnector-.net 1 사용 예제들

Private Properties

프로퍼티	타입	설명
AddToBatch	void
AsyncExecuteWrapper	object
CheckState	void
ClearCommandTimer	void
Close	void
EstimatedSize	long
GetCommandTextForBatching	string
HandleCommandBehaviors	void
ICloneable	object
Prepare	void
ResetReader	void
ResetSqlSelectLimit	void
TrimSemicolons	string

공개 메소드들

메소드	설명
BeginExecuteNonQuery ( ) : IAsyncResult	Initiates the asynchronous execution of the SQL statement or stored procedure that is described by this MySqlCommand.
BeginExecuteNonQuery ( AsyncCallback callback, object stateObject ) : IAsyncResult	Initiates the asynchronous execution of the SQL statement or stored procedure that is described by this MySqlCommand.
BeginExecuteReader ( ) : IAsyncResult	Initiates the asynchronous execution of the SQL statement or stored procedure that is described by this MySqlCommand, and retrieves one or more result sets from the server.
BeginExecuteReader ( CommandBehavior behavior ) : IAsyncResult	Initiates the asynchronous execution of the SQL statement or stored procedure that is described by this MySqlCommand using one of the CommandBehavior values.
Cancel ( ) : void	Attempts to cancel the execution of a currently active command Cancelling a currently active query only works with MySQL versions 5.0.0 and higher.
Clone ( ) : MySqlCommand	Creates a clone of this MySqlCommand object. CommandText, Connection, and Transaction properties are included as well as the entire parameter list.
CreateParameter ( ) : MySqlParameter	Creates a new instance of a MySqlParameter object. This method is a strongly-typed version of IDbCommand.CreateParameter.
EndExecuteNonQuery ( IAsyncResult asyncResult ) : int	Finishes asynchronous execution of a SQL statement.
EndExecuteReader ( IAsyncResult result ) : MySqlDataReader	Finishes asynchronous execution of a SQL statement, returning the requested MySqlDataReader.
ExecuteNonQuery ( ) : int
ExecuteReader ( ) : MySqlDataReader
ExecuteReader ( CommandBehavior behavior ) : MySqlDataReader
ExecuteScalar ( ) : object
MySqlCommand ( ) : System
MySqlCommand ( string cmdText ) : System
MySqlCommand ( string cmdText, MySqlConnection connection ) : System
MySqlCommand ( string cmdText, MySqlConnection connection, MySqlTransaction transaction ) : System
Prepare ( ) : void

보호된 메소드들

메소드	설명
CreateDbParameter ( ) : DbParameter
Dispose ( bool disposing ) : void
ExecuteDbDataReader ( CommandBehavior behavior ) : DbDataReader

비공개 메소드들

메소드	설명
AddToBatch ( MySqlCommand command ) : void
AsyncExecuteWrapper ( int type, CommandBehavior behavior ) : object
CheckState ( ) : void	Check the connection to make sure - it is open - it is not currently being used by a reader - and we have the right version of MySQL for the requested command type
ClearCommandTimer ( ) : void
Close ( MySqlDataReader reader ) : void
EstimatedSize ( ) : long
GetCommandTextForBatching ( ) : string
HandleCommandBehaviors ( CommandBehavior behavior ) : void
ICloneable ( ) : object
Prepare ( int cursorPageSize ) : void
ResetReader ( ) : void	Reset reader to null, to avoid "There is already an open data reader" on the next ExecuteReader(). Used in error handling scenarios.
ResetSqlSelectLimit ( ) : void	Reset SQL_SELECT_LIMIT that could have been modified by CommandBehavior.
TrimSemicolons ( string sql ) : string

메소드 상세

BeginExecuteNonQuery() 공개 메소드

Initiates the asynchronous execution of the SQL statement or stored procedure that is described by this MySqlCommand.

public BeginExecuteNonQuery ( ) : IAsyncResult
리턴	IAsyncResult

BeginExecuteNonQuery() 공개 메소드

Initiates the asynchronous execution of the SQL statement or stored procedure that is described by this MySqlCommand.

public BeginExecuteNonQuery ( AsyncCallback callback, object stateObject ) : IAsyncResult
callback	AsyncCallback	/// An delegate that is invoked when the command's /// execution has completed. Pass a null reference (Nothing in Visual Basic) /// to indicate that no callback is required.
stateObject	object	A user-defined state object that is passed to the /// callback procedure. Retrieve this object from within the callback procedure /// using the property.
리턴	IAsyncResult

BeginExecuteReader() 공개 메소드

Initiates the asynchronous execution of the SQL statement or stored procedure that is described by this MySqlCommand, and retrieves one or more result sets from the server.

public BeginExecuteReader ( ) : IAsyncResult
리턴	IAsyncResult

BeginExecuteReader() 공개 메소드

Initiates the asynchronous execution of the SQL statement or stored procedure that is described by this MySqlCommand using one of the CommandBehavior values.

public BeginExecuteReader ( CommandBehavior behavior ) : IAsyncResult
behavior	CommandBehavior	One of the values, indicating /// options for statement execution and data retrieval.
리턴	IAsyncResult

Cancel() 공개 메소드

Attempts to cancel the execution of a currently active command

Cancelling a currently active query only works with MySQL versions 5.0.0 and higher.

public Cancel ( ) : void
리턴	void

Clone() 공개 메소드

Creates a clone of this MySqlCommand object. CommandText, Connection, and Transaction properties are included as well as the entire parameter list.

public Clone ( ) : MySqlCommand
리턴	MySqlCommand

CreateDbParameter() 보호된 메소드

protected CreateDbParameter ( ) : DbParameter
리턴	DbParameter

CreateParameter() 공개 메소드

Creates a new instance of a MySqlParameter object.

This method is a strongly-typed version of IDbCommand.CreateParameter.

public CreateParameter ( ) : MySqlParameter
리턴	MySqlParameter

Dispose() 보호된 메소드

protected Dispose ( bool disposing ) : void
disposing	bool
리턴	void

EndExecuteNonQuery() 공개 메소드

Finishes asynchronous execution of a SQL statement.

public EndExecuteNonQuery ( IAsyncResult asyncResult ) : int
asyncResult	IAsyncResult	The returned by the call /// to .
리턴	int

EndExecuteReader() 공개 메소드

Finishes asynchronous execution of a SQL statement, returning the requested MySqlDataReader.

public EndExecuteReader ( IAsyncResult result ) : MySqlDataReader
result	IAsyncResult	The returned by the call to /// .
리턴	MySqlDataReader

ExecuteDbDataReader() 보호된 메소드

protected ExecuteDbDataReader ( CommandBehavior behavior ) : DbDataReader
behavior	CommandBehavior
리턴	DbDataReader

ExecuteNonQuery() 공개 메소드

public ExecuteNonQuery ( ) : int
리턴	int

ExecuteReader() 공개 메소드

public ExecuteReader ( ) : MySqlDataReader
리턴	MySqlDataReader

ExecuteReader() 공개 메소드

public ExecuteReader ( CommandBehavior behavior ) : MySqlDataReader
behavior	CommandBehavior
리턴	MySqlDataReader

ExecuteScalar() 공개 메소드

public ExecuteScalar ( ) : object
리턴	object

MySqlCommand() 공개 메소드

public MySqlCommand ( ) : System
리턴	System

MySqlCommand() 공개 메소드

public MySqlCommand ( string cmdText ) : System
cmdText	string
리턴	System

MySqlCommand() 공개 메소드

public MySqlCommand ( string cmdText, MySqlConnection connection ) : System
cmdText	string
connection	MySqlConnection
리턴	System

MySqlCommand() 공개 메소드

public MySqlCommand ( string cmdText, MySqlConnection connection, MySqlTransaction transaction ) : System
cmdText	string
connection	MySqlConnection
transaction	MySqlTransaction
리턴	System

Prepare() 공개 메소드

public Prepare ( ) : void
리턴	void