21.2.9.1. MySql.Data.MySqlClient Namespace

Initializes a new instance of the MySqlConnection class.

Overload List

Initializes a new instance of the MySqlConnection class.

See Also

MySqlConnection Class, MySql.Data.MySqlClient Namespace

Overloads Public Sub New()

public MySqlConnection();

Overloads Public Sub New( _   ByVal connectionString As String _)

public MySqlConnection(stringconnectionString);

Syntax: Visual Basic

NotOverridable Public Property ConnectionString As String __  Implements IDbConnection.ConnectionString

Syntax: C#

public string ConnectionString {get; set;}

Implements

IDbConnection.ConnectionString

See Also

MySqlConnection Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

NotOverridable Public ReadOnly Property ConnectionTimeout As Integer __  Implements IDbConnection.ConnectionTimeout

Syntax: C#

public int ConnectionTimeout {get;}

Implements

IDbConnection.ConnectionTimeout

See Also

MySqlConnection Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

NotOverridable Public ReadOnly Property Database As String __  Implements IDbConnection.Database

Syntax: C#

public string Database {get;}

Implements

IDbConnection.Database

See Also

MySqlConnection Class, MySql.Data.MySqlClient Namespace

Gets the name of the MySQL server to which to connect.

Syntax: Visual Basic

Public ReadOnly Property DataSource As String

Syntax: C#

public string DataSource {get;}

See Also

MySqlConnection Class, MySql.Data.MySqlClient Namespace

Returns the ID of the server thread this connection is executing on

Syntax: Visual Basic

Public ReadOnly Property ServerThread As Integer

Syntax: C#

public int ServerThread {get;}

See Also

MySqlConnection Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

Public ReadOnly Property ServerVersion As String

Syntax: C#

public string ServerVersion {get;}

See Also

MySqlConnection Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

NotOverridable Public ReadOnly Property State As ConnectionState __  Implements IDbConnection.State

Syntax: C#

public System.Data.ConnectionState State {get;}

Implements

IDbConnection.State

See Also

MySqlConnection Class, MySql.Data.MySqlClient Namespace

Indicates if this connection should use compression when communicating with the server.

Syntax: Visual Basic

Public ReadOnly Property UseCompression As Boolean

Syntax: C#

public bool UseCompression {get;}

See Also

MySqlConnection Class, MySql.Data.MySqlClient Namespace

Overload List

See Also

MySqlConnection Class, MySql.Data.MySqlClient Namespace

Overloads Public Function BeginTransaction() As MySqlTransaction

public MySqlTransaction BeginTransaction();

NotInheritable Public Class MySqlTransaction_  Implements IDbTransaction, IDisposable

public sealed class MySqlTransaction : IDbTransaction, IDisposable

Public ReadOnly Property Connection As MySqlConnection

public MySqlConnection Connection {get;}

NotOverridable Public ReadOnly Property IsolationLevel As IsolationLevel __  Implements IDbTransaction.IsolationLevel

public System.Data.IsolationLevel IsolationLevel {get;}

NotOverridable Public Sub Commit() __  Implements IDbTransaction.Commit

public void Commit();

NotOverridable Public Sub Rollback() __  Implements IDbTransaction.Rollback

public void Rollback();

Overloads Public Function BeginTransaction( _   ByVal iso As IsolationLevel _) As MySqlTransaction

public MySqlTransaction BeginTransaction(IsolationLeveliso);

Syntax: Visual Basic

NotOverridable Public Sub ChangeDatabase( _   ByVal databaseName As String _) __  Implements IDbConnection.ChangeDatabase

Syntax: C#

public void ChangeDatabase(stringdatabaseName);

Implements

IDbConnection.ChangeDatabase

See Also

MySqlConnection Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

NotOverridable Public Sub Close() __  Implements IDbConnection.Close

Syntax: C#

public void Close();

Implements

IDbConnection.Close

See Also

MySqlConnection Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

Public Function CreateCommand() As MySqlCommand

Syntax: C#

public MySqlCommand CreateCommand();

See Also

MySqlConnection Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

NotOverridable Public Sub Open() __  Implements IDbConnection.Open

Syntax: C#

public void Open();

Implements

IDbConnection.Open

See Also

MySqlConnection Class, MySql.Data.MySqlClient Namespace

Ping

Syntax: Visual Basic

Public Function Ping() As Boolean

Syntax: C#

public bool Ping();

Return Value

See Also

MySqlConnection Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

Public Event InfoMessage As MySqlInfoMessageEventHandler

Syntax: C#

public event MySqlInfoMessageEventHandler InfoMessage;

See Also

MySqlConnection Class, MySql.Data.MySqlClient Namespace

Public Delegate Sub MySqlInfoMessageEventHandler( _   ByVal sender As Object, _   ByVal args As MySqlInfoMessageEventArgs _)

public delegate void MySqlInfoMessageEventHandler(objectsender,MySqlInfoMessageEventArgsargs);

Public Class MySqlInfoMessageEventArgs_  Inherits EventArgs

public class MySqlInfoMessageEventArgs : EventArgs

Public Sub New()

public MySqlInfoMessageEventArgs();

Public errors As MySqlError()

public MySqlError[] errors;

Public Class MySqlError

public class MySqlError

Public Sub New( _   ByVal level As String, _   ByVal code As Integer, _   ByVal message As String _)

public MySqlError(stringlevel,intcode,stringmessage);

Public ReadOnly Property Code As Integer

public int Code {get;}

Public ReadOnly Property Level As String

public string Level {get;}

Public ReadOnly Property Message As String

public string Message {get;}

Syntax: Visual Basic

Public Event StateChange As StateChangeEventHandler

Syntax: C#

public event StateChangeEventHandler StateChange;

See Also

MySqlConnection Class, MySql.Data.MySqlClient Namespace

Represents a parameter to a MySqlCommand, and optionally, its mapping to DataSetcolumns. This class cannot be inherited.

For a list of all members of this type, see MySqlParameter Members .

Syntax: Visual Basic

NotInheritable Public Class MySqlParameter_  Inherits MarshalByRefObject_  Implements IDataParameter, IDbDataParameter, ICloneable

Syntax: C#

public sealed class MySqlParameter : MarshalByRefObject, IDataParameter, IDbDataParameter, ICloneable

Thread Safety

Public static (Shared in Visual Basic) members of this type are safe for multithreaded operations. Instance members are not guaranteed to be thread-safe.

Requirements

Namespace: MySql.Data.MySqlClient

Assembly: MySql.Data (in MySql.Data.dll)

See Also

MySqlParameter Members, MySql.Data.MySqlClient Namespace

Overloads Public Sub New()

public MySqlParameter();

Overloads Public Sub New( _   ByVal parameterName As String, _   ByVal dbType As MySqlDbType _)

public MySqlParameter(stringparameterName,MySqlDbTypedbType);

Public Enum MySqlDbType

public enum MySqlDbType

Overloads Public Sub New( _   ByVal parameterName As String, _   ByVal dbType As MySqlDbType, _   ByVal size As Integer _)

public MySqlParameter(stringparameterName,MySqlDbTypedbType,intsize);

Overloads Public Sub New( _   ByVal parameterName As String, _   ByVal dbType As MySqlDbType, _   ByVal size As Integer, _   ByVal direction As ParameterDirection, _   ByVal isNullable As Boolean, _   ByVal precision As Byte, _   ByVal scale As Byte, _   ByVal sourceColumn As String, _   ByVal sourceVersion As DataRowVersion, _   ByVal value As Object _)

public MySqlParameter(stringparameterName,MySqlDbTypedbType,intsize,ParameterDirectiondirection,boolisNullable,byteprecision,bytescale,stringsourceColumn,DataRowVersionsourceVersion,objectvalue);

NotOverridable Public Property Value As Object __  Implements IDataParameter.Value

public object Value {get; set;}

Overloads Public Sub New( _   ByVal parameterName As String, _   ByVal dbType As MySqlDbType, _   ByVal size As Integer, _   ByVal sourceColumn As String _)

public MySqlParameter(stringparameterName,MySqlDbTypedbType,intsize,stringsourceColumn);

Overloads Public Sub New( _   ByVal parameterName As String, _   ByVal value As Object _)

public MySqlParameter(stringparameterName,objectvalue);

NotOverridable Public Property DbType As DbType __  Implements IDataParameter.DbType

public System.Data.DbType DbType {get; set;}

NotOverridable Public Property Direction As ParameterDirection __  Implements IDataParameter.Direction

public System.Data.ParameterDirection Direction {get; set;}

NotOverridable Public Property IsNullable As Boolean __  Implements IDataParameter.IsNullable

public bool IsNullable {get; set;}

Public Property IsUnsigned As Boolean

public bool IsUnsigned {get; set;}

Public Property MySqlDbType As MySqlDbType

public MySqlDbType MySqlDbType {get; set;}

NotOverridable Public Property ParameterName As String __  Implements IDataParameter.ParameterName

public string ParameterName {get; set;}

NotOverridable Public Property Precision As Byte __  Implements IDbDataParameter.Precision

public byte Precision {get; set;}

NotOverridable Public Property Scale As Byte __  Implements IDbDataParameter.Scale

public byte Scale {get; set;}

NotOverridable Public Property Size As Integer __  Implements IDbDataParameter.Size

public int Size {get; set;}

NotOverridable Public Property SourceColumn As String __  Implements IDataParameter.SourceColumn

public string SourceColumn {get; set;}

NotOverridable Public Property SourceVersion As DataRowVersion __  Implements IDataParameter.SourceVersion

public System.Data.DataRowVersion SourceVersion {get; set;}

Overrides Public Function ToString() As String

public override string ToString();

Gets the MySqlParameter at the specified index.

Syntax: Visual Basic

Overloads Public Default Property Item( _   ByVal index As Integer _) As MySqlParameter

Syntax: C#

public MySqlParameter this[intindex] {get; set;}

See Also

MySqlParameterCollection Class, MySql.Data.MySqlClient Namespace, MySqlParameterCollection.Item Overload List

Gets the MySqlParameter with the specified name.

Syntax: Visual Basic

Overloads Public Default Property Item( _   ByVal name As String _) As MySqlParameter

Syntax: C#

public MySqlParameter this[stringname] {get; set;}

See Also

MySqlParameterCollection Class, MySql.Data.MySqlClient Namespace, MySqlParameterCollection.Item Overload List

Adds the specified MySqlParameter object to the MySqlParameterCollection.

Syntax: Visual Basic

Overloads Public Function Add( _   ByVal value As MySqlParameter _) As MySqlParameter

Syntax: C#

public MySqlParameter Add(MySqlParametervalue);

Parameters

Return Value

The newly added MySqlParameter object.

See Also

MySqlParameterCollection Class, MySql.Data.MySqlClient Namespace, MySqlParameterCollection.Add Overload List

Adds the specified MySqlParameter object to the MySqlParameterCollection.

Syntax: Visual Basic

NotOverridable Overloads Public Function Add( _   ByVal value As Object _) As Integer __  Implements IList.Add

Syntax: C#

public int Add(objectvalue);

Parameters

Return Value

The index of the new MySqlParameter object.

Implements

IList.Add

See Also

MySqlParameterCollection Class, MySql.Data.MySqlClient Namespace, MySqlParameterCollection.Add Overload List

Adds a MySqlParameter to the MySqlParameterCollection given the parameter name and the data type.

Syntax: Visual Basic

Overloads Public Function Add( _   ByVal parameterName As String, _   ByVal dbType As MySqlDbType _) As MySqlParameter

Syntax: C#

public MySqlParameter Add(stringparameterName,MySqlDbTypedbType);

Parameters

Return Value

The newly added MySqlParameter object.

See Also

MySqlParameterCollection Class, MySql.Data.MySqlClient Namespace, MySqlParameterCollection.Add Overload List

Adds a MySqlParameter to the MySqlParameterCollection with the parameter name, the data type, and the column length.

Syntax: Visual Basic

Overloads Public Function Add( _   ByVal parameterName As String, _   ByVal dbType As MySqlDbType, _   ByVal size As Integer _) As MySqlParameter

Syntax: C#

public MySqlParameter Add(stringparameterName,MySqlDbTypedbType,intsize);

Parameters

Return Value

The newly added MySqlParameter object.

See Also

MySqlParameterCollection Class, MySql.Data.MySqlClient Namespace, MySqlParameterCollection.Add Overload List

Adds a MySqlParameter to the MySqlParameterCollection with the parameter name, the data type, the column length, and the source column name.

Syntax: Visual Basic

Overloads Public Function Add( _   ByVal parameterName As String, _   ByVal dbType As MySqlDbType, _   ByVal size As Integer, _   ByVal sourceColumn As String _) As MySqlParameter

Syntax: C#

public MySqlParameter Add(stringparameterName,MySqlDbTypedbType,intsize,stringsourceColumn);

Parameters

Return Value

The newly added MySqlParameter object.

See Also

MySqlParameterCollection Class, MySql.Data.MySqlClient Namespace, MySqlParameterCollection.Add Overload List

Adds a MySqlParameter to the MySqlParameterCollection given the specified parameter name and value.

Syntax: Visual Basic

Overloads Public Function Add( _   ByVal parameterName As String, _   ByVal value As Object _) As MySqlParameter

Syntax: C#

public MySqlParameter Add(stringparameterName,objectvalue);

Parameters

Return Value

The newly added MySqlParameter object.

See Also

MySqlParameterCollection Class, MySql.Data.MySqlClient Namespace, MySqlParameterCollection.Add Overload List

Gets a value indicating whether a MySqlParameter exists in the collection.

Syntax: Visual Basic

NotOverridable Overloads Public Function Contains( _   ByVal value As Object _) As Boolean __  Implements IList.Contains

Syntax: C#

public bool Contains(objectvalue);

Parameters

Return Value

true if the collection contains the MySqlParameter object; otherwise, false.

Implements

IList.Contains

See Also

MySqlParameterCollection Class, MySql.Data.MySqlClient Namespace, MySqlParameterCollection.Contains Overload List

Gets a value indicating whether a MySqlParameter with the specified parameter name exists in the collection.

Syntax: Visual Basic

NotOverridable Overloads Public Function Contains( _   ByVal name As String _) As Boolean __  Implements IDataParameterCollection.Contains

Syntax: C#

public bool Contains(stringname);

Parameters

Return Value

true if the collection contains the parameter; otherwise, false.

Implements

IDataParameterCollection.Contains

See Also

MySqlParameterCollection Class, MySql.Data.MySqlClient Namespace, MySqlParameterCollection.Contains Overload List

Gets the location of a MySqlParameter in the collection.

Syntax: Visual Basic

NotOverridable Overloads Public Function IndexOf( _   ByVal value As Object _) As Integer __  Implements IList.IndexOf

Syntax: C#

public int IndexOf(objectvalue);

Parameters

Return Value

The zero-based location of the MySqlParameter in the collection.

Implements

IList.IndexOf

See Also

MySqlParameterCollection Class, MySql.Data.MySqlClient Namespace, MySqlParameterCollection.IndexOf Overload List

Gets the location of the MySqlParameter in the collection with a specific parameter name.

Syntax: Visual Basic

NotOverridable Overloads Public Function IndexOf( _   ByVal parameterName As String _) As Integer __  Implements IDataParameterCollection.IndexOf

Syntax: C#

public int IndexOf(stringparameterName);

Parameters

Return Value

The zero-based location of the MySqlParameter in the collection.

Implements

IDataParameterCollection.IndexOf

See Also

MySqlParameterCollection Class, MySql.Data.MySqlClient Namespace, MySqlParameterCollection.IndexOf Overload List

Removes the specified MySqlParameter from the collection using a specific index.

Syntax: Visual Basic

NotOverridable Overloads Public Sub RemoveAt( _   ByVal index As Integer _) __  Implements IList.RemoveAt

Syntax: C#

public void RemoveAt(intindex);

Parameters

Implements

IList.RemoveAt

See Also

MySqlParameterCollection Class, MySql.Data.MySqlClient Namespace, MySqlParameterCollection.RemoveAt Overload List

Removes the specified MySqlParameter from the collection using the parameter name.

Syntax: Visual Basic

NotOverridable Overloads Public Sub RemoveAt( _   ByVal name As String _) __  Implements IDataParameterCollection.RemoveAt

Syntax: C#

public void RemoveAt(stringname);

Parameters

Implements

IDataParameterCollection.RemoveAt

See Also

MySqlParameterCollection Class, MySql.Data.MySqlClient Namespace, MySqlParameterCollection.RemoveAt Overload List

Gets a value indicating the depth of nesting for the current row. This method is not supported currently and always returns 0.

Syntax: Visual Basic

NotOverridable Public ReadOnly Property Depth As Integer __  Implements IDataReader.Depth

Syntax: C#

public int Depth {get;}

Implements

IDataReader.Depth

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Gets the number of columns in the current row.

Syntax: Visual Basic

NotOverridable Public ReadOnly Property FieldCount As Integer __  Implements IDataRecord.FieldCount

Syntax: C#

public int FieldCount {get;}

Implements

IDataRecord.FieldCount

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Gets a value indicating whether the MySqlDataReader contains one or more rows.

Syntax: Visual Basic

Public ReadOnly Property HasRows As Boolean

Syntax: C#

public bool HasRows {get;}

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Gets a value indicating whether the data reader is closed.

Syntax: Visual Basic

NotOverridable Public ReadOnly Property IsClosed As Boolean __  Implements IDataReader.IsClosed

Syntax: C#

public bool IsClosed {get;}

Implements

IDataReader.IsClosed

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Overloaded. Gets the value of a column in its native format. In C#, this property is the indexer for the MySqlDataReader class.

Overload List

Overloaded. Gets the value of a column in its native format. In C#, this property is the indexer for the MySqlDataReader class.

Gets the value of a column in its native format. In C#, this property is the indexer for the MySqlDataReader class.

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

NotOverridable Overloads Public Default ReadOnly Property Item( _   ByVal i As Integer _) __  Implements IDataRecord.Item As Object __  Implements IDataRecord.Item

public object this[inti] {get;}

NotOverridable Overloads Public Default ReadOnly Property Item( _   ByVal name As String _) __  Implements IDataRecord.Item As Object __  Implements IDataRecord.Item

public object this[stringname] {get;}

Gets the number of rows changed, inserted, or deleted by execution of the SQL statement.

Syntax: Visual Basic

NotOverridable Public ReadOnly Property RecordsAffected As Integer __  Implements IDataReader.RecordsAffected

Syntax: C#

public int RecordsAffected {get;}

Implements

IDataReader.RecordsAffected

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Closes the MySqlDataReader object.

Syntax: Visual Basic

NotOverridable Public Sub Close() __  Implements IDataReader.Close

Syntax: C#

public void Close();

Implements

IDataReader.Close

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Gets the value of the specified column as a Boolean.

Syntax: Visual Basic

NotOverridable Public Function GetBoolean( _   ByVal i As Integer _) As Boolean __  Implements IDataRecord.GetBoolean

Syntax: C#

public bool GetBoolean(inti);

Parameters

Return Value

Implements

IDataRecord.GetBoolean

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Gets the value of the specified column as a byte.

Syntax: Visual Basic

NotOverridable Public Function GetByte( _   ByVal i As Integer _) As Byte __  Implements IDataRecord.GetByte

Syntax: C#

public byte GetByte(inti);

Parameters

Return Value

Implements

IDataRecord.GetByte

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Reads a stream of bytes from the specified column offset into the buffer an array starting at the given buffer offset.

Syntax: Visual Basic

NotOverridable Public Function GetBytes( _   ByVal i As Integer, _   ByVal dataIndex As Long, _   ByVal buffer As Byte(), _   ByVal bufferIndex As Integer, _   ByVal length As Integer _) As Long __  Implements IDataRecord.GetBytes

Syntax: C#

public long GetBytes(inti,longdataIndex,byte[]buffer,intbufferIndex,intlength);

Parameters

Return Value

The actual number of bytes read.

Implements

IDataRecord.GetBytes

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Gets the value of the specified column as a single character.

Syntax: Visual Basic

NotOverridable Public Function GetChar( _   ByVal i As Integer _) As Char __  Implements IDataRecord.GetChar

Syntax: C#

public char GetChar(inti);

Parameters

Return Value

Implements

IDataRecord.GetChar

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Reads a stream of characters from the specified column offset into the buffer as an array starting at the given buffer offset.

Syntax: Visual Basic

NotOverridable Public Function GetChars( _   ByVal i As Integer, _   ByVal fieldOffset As Long, _   ByVal buffer As Char(), _   ByVal bufferoffset As Integer, _   ByVal length As Integer _) As Long __  Implements IDataRecord.GetChars

Syntax: C#

public long GetChars(inti,longfieldOffset,char[]buffer,intbufferoffset,intlength);

Parameters

Return Value

Implements

IDataRecord.GetChars

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Gets the name of the source data type.

Syntax: Visual Basic

NotOverridable Public Function GetDataTypeName( _   ByVal i As Integer _) As String __  Implements IDataRecord.GetDataTypeName

Syntax: C#

public string GetDataTypeName(inti);

Parameters

Return Value

Implements

IDataRecord.GetDataTypeName

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

NotOverridable Public Function GetDateTime( _   ByVal index As Integer _) As Date __  Implements IDataRecord.GetDateTime

Syntax: C#

public DateTime GetDateTime(intindex);

Implements

IDataRecord.GetDateTime

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

NotOverridable Public Function GetDecimal( _   ByVal index As Integer _) As Decimal __  Implements IDataRecord.GetDecimal

Syntax: C#

public decimal GetDecimal(intindex);

Implements

IDataRecord.GetDecimal

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

NotOverridable Public Function GetDouble( _   ByVal index As Integer _) As Double __  Implements IDataRecord.GetDouble

Syntax: C#

public double GetDouble(intindex);

Implements

IDataRecord.GetDouble

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Gets the Type that is the data type of the object.

Syntax: Visual Basic

NotOverridable Public Function GetFieldType( _   ByVal i As Integer _) As Type __  Implements IDataRecord.GetFieldType

Syntax: C#

public Type GetFieldType(inti);

Parameters

Return Value

Implements

IDataRecord.GetFieldType

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

NotOverridable Public Function GetFloat( _   ByVal index As Integer _) As Single __  Implements IDataRecord.GetFloat

Syntax: C#

public float GetFloat(intindex);

Implements

IDataRecord.GetFloat

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

NotOverridable Public Function GetGuid( _   ByVal index As Integer _) As Guid __  Implements IDataRecord.GetGuid

Syntax: C#

public Guid GetGuid(intindex);

Implements

IDataRecord.GetGuid

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

NotOverridable Public Function GetInt16( _   ByVal index As Integer _) As Short __  Implements IDataRecord.GetInt16

Syntax: C#

public short GetInt16(intindex);

Implements

IDataRecord.GetInt16

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

NotOverridable Public Function GetInt32( _   ByVal index As Integer _) As Integer __  Implements IDataRecord.GetInt32

Syntax: C#

public int GetInt32(intindex);

Implements

IDataRecord.GetInt32

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

NotOverridable Public Function GetInt64( _   ByVal index As Integer _) As Long __  Implements IDataRecord.GetInt64

Syntax: C#

public long GetInt64(intindex);

Implements

IDataRecord.GetInt64

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

Public Function GetMySqlDateTime( _   ByVal index As Integer _) As MySqlDateTime

Syntax: C#

public MySqlDateTime GetMySqlDateTime(intindex);

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Gets the name of the specified column.

Syntax: Visual Basic

NotOverridable Public Function GetName( _   ByVal i As Integer _) As String __  Implements IDataRecord.GetName

Syntax: C#

public string GetName(inti);

Parameters

Return Value

Implements

IDataRecord.GetName

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Gets the column ordinal, given the name of the column.

Syntax: Visual Basic

NotOverridable Public Function GetOrdinal( _   ByVal name As String _) As Integer __  Implements IDataRecord.GetOrdinal

Syntax: C#

public int GetOrdinal(stringname);

Parameters

Return Value

Implements

IDataRecord.GetOrdinal

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Returns a DataTable that describes the column metadata of the MySqlDataReader.

Syntax: Visual Basic

NotOverridable Public Function GetSchemaTable() As DataTable __  Implements IDataReader.GetSchemaTable

Syntax: C#

public DataTable GetSchemaTable();

Return Value

Implements

IDataReader.GetSchemaTable

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

NotOverridable Public Function GetString( _   ByVal index As Integer _) As String __  Implements IDataRecord.GetString

Syntax: C#

public string GetString(intindex);

Implements

IDataRecord.GetString

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

Public Function GetTimeSpan( _   ByVal index As Integer _) As TimeSpan

Syntax: C#

public TimeSpan GetTimeSpan(intindex);

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

Public Function GetUInt16( _   ByVal index As Integer _) As UInt16

Syntax: C#

public ushort GetUInt16(intindex);

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

Public Function GetUInt32( _   ByVal index As Integer _) As UInt32

Syntax: C#

public uint GetUInt32(intindex);

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

Public Function GetUInt64( _   ByVal index As Integer _) As UInt64

Syntax: C#

public ulong GetUInt64(intindex);

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Gets the value of the specified column in its native format.

Syntax: Visual Basic

NotOverridable Public Function GetValue( _   ByVal i As Integer _) As Object __  Implements IDataRecord.GetValue

Syntax: C#

public object GetValue(inti);

Parameters

Return Value

Implements

IDataRecord.GetValue

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Gets all attribute columns in the collection for the current row.

Syntax: Visual Basic

NotOverridable Public Function GetValues( _   ByVal values As Object() _) As Integer __  Implements IDataRecord.GetValues

Syntax: C#

public int GetValues(object[]values);

Parameters

Return Value

Implements

IDataRecord.GetValues

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Gets a value indicating whether the column contains non-existent or missing values.

Syntax: Visual Basic

NotOverridable Public Function IsDBNull( _   ByVal i As Integer _) As Boolean __  Implements IDataRecord.IsDBNull

Syntax: C#

public bool IsDBNull(inti);

Parameters

Return Value

Implements

IDataRecord.IsDBNull

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Advances the data reader to the next result, when reading the results of batch SQL statements.

Syntax: Visual Basic

NotOverridable Public Function NextResult() As Boolean __  Implements IDataReader.NextResult

Syntax: C#

public bool NextResult();

Return Value

Implements

IDataReader.NextResult

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Advances the MySqlDataReader to the next record.

Syntax: Visual Basic

NotOverridable Public Function Read() As Boolean __  Implements IDataReader.Read

Syntax: C#

public bool Read();

Return Value

Implements

IDataReader.Read

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Initializes a new instance of the MySqlDataAdapter class.

Overload List

Initializes a new instance of the MySqlDataAdapter class.

See Also

MySqlDataAdapter Class, MySql.Data.MySqlClient Namespace

Overloads Public Sub New()

public MySqlDataAdapter();

Overloads Public Sub New( _   ByVal selectCommand As MySqlCommand _)

public MySqlDataAdapter(MySqlCommandselectCommand);

Overloads Public Sub New( _   ByVal selectCommandText As String, _   ByVal connection As MySqlConnection _)

public MySqlDataAdapter(stringselectCommandText,MySqlConnectionconnection);

Overloads Public Sub New( _   ByVal selectCommandText As String, _   ByVal selectConnString As String _)

public MySqlDataAdapter(stringselectCommandText,stringselectConnString);

Syntax: Visual Basic

Overloads Public Property DeleteCommand As MySqlCommand

Syntax: C#

new public MySqlCommand DeleteCommand {get; set;}

See Also

MySqlDataAdapter Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

Overloads Public Property InsertCommand As MySqlCommand

Syntax: C#

new public MySqlCommand InsertCommand {get; set;}

See Also

MySqlDataAdapter Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

Overloads Public Property SelectCommand As MySqlCommand

Syntax: C#

new public MySqlCommand SelectCommand {get; set;}

See Also

MySqlDataAdapter Class, MySql.Data.MySqlClient Namespace

Syntax: Visual Basic

Overloads Public Property UpdateCommand As MySqlCommand

Syntax: C#

new public MySqlCommand UpdateCommand {get; set;}

See Also

MySqlDataAdapter Class, MySql.Data.MySqlClient Namespace

Occurs during Update after a command is executed against the data source. The attempt to update is made, so the event fires.

Syntax: Visual Basic

Public Event RowUpdated As MySqlRowUpdatedEventHandler

Syntax: C#

public event MySqlRowUpdatedEventHandler RowUpdated;

Event Data

The event handler receives an argument of type MySqlRowUpdatedEventArgs containing data related to this event. The following MySqlRowUpdatedEventArgsproperties provide information specific to this event.

See Also

MySqlDataAdapter Class, MySql.Data.MySqlClient Namespace

Public Delegate Sub MySqlRowUpdatedEventHandler( _   ByVal sender As Object, _   ByVal e As MySqlRowUpdatedEventArgs _)

public delegate void MySqlRowUpdatedEventHandler(objectsender,MySqlRowUpdatedEventArgs);

NotInheritable Public Class MySqlRowUpdatedEventArgs_  Inherits RowUpdatedEventArgs

public sealed class MySqlRowUpdatedEventArgs : RowUpdatedEventArgs

Public Sub New( _   ByVal row As DataRow, _   ByVal command As IDbCommand, _   ByVal statementType As StatementType, _   ByVal tableMapping As DataTableMapping _)

public MySqlRowUpdatedEventArgs(DataRowrow,IDbCommandcommand,StatementTypestatementType,DataTableMappingtableMapping);

Overloads Public ReadOnly Property Command As MySqlCommand

new public MySqlCommand Command {get;}

Occurs during Update before a command is executed against the data source. The attempt to update is made, so the event fires.

Syntax: Visual Basic

Public Event RowUpdating As MySqlRowUpdatingEventHandler

Syntax: C#

public event MySqlRowUpdatingEventHandler RowUpdating;

Event Data

The event handler receives an argument of type MySqlRowUpdatingEventArgs containing data related to this event. The following MySqlRowUpdatingEventArgsproperties provide information specific to this event.

See Also

MySqlDataAdapter Class, MySql.Data.MySqlClient Namespace

Public Delegate Sub MySqlRowUpdatingEventHandler( _   ByVal sender As Object, _   ByVal e As MySqlRowUpdatingEventArgs _)

public delegate void MySqlRowUpdatingEventHandler(objectsender,MySqlRowUpdatingEventArgs);

NotInheritable Public Class MySqlRowUpdatingEventArgs_  Inherits RowUpdatingEventArgs

public sealed class MySqlRowUpdatingEventArgs : RowUpdatingEventArgs

Public Sub New( _   ByVal row As DataRow, _   ByVal command As IDbCommand, _   ByVal statementType As StatementType, _   ByVal tableMapping As DataTableMapping _)

public MySqlRowUpdatingEventArgs(DataRowrow,IDbCommandcommand,StatementTypestatementType,DataTableMappingtableMapping);

Overloads Public Property Command As MySqlCommand

new public MySqlCommand Command {get; set;}