GetMySqlBinaryString(Int32) Method
In This Topic
Gets the value of the specified column as a
MySqlBinaryString object.
Syntax
Parameters
- i
- The zero-based column ordinal.
Return Value
The value of the specified column as a
MySqlBinaryString object.
Example
|
|---|
static void GetMyBinaryString(MySqlConnection connection) {
MySqlCommand insertCommand = new MySqlCommand("INSERT INTO autotest.simple_types (f_binary, f_varbinary) VALUES (:p1, :p2)", connection);
Encoding encoding = Encoding.Unicode;
byte[] buffer1 = encoding.GetBytes("test1");
byte[] buffer2 = encoding.GetBytes("test2");
insertCommand.Parameters.Add("p1", new MySqlBinaryString(buffer1, encoding));
insertCommand.Parameters.Add("p2", new MySqlBinaryString(buffer2, encoding));
insertCommand.ExecuteNonQuery();
MySqlCommand selectCommand = new MySqlCommand("SELECT f_binary, f_varbinary FROM autotest.simple_types", connection);
using (MySqlDataReader reader = selectCommand.ExecuteReader())
while (reader.Read())
for (int i = 0; i < reader.FieldCount; ++i) {
MySqlBinaryString value = reader.GetMySqlBinaryString(i);
value.Encoding = encoding;
Console.WriteLine(value);
}
} |
|
|---|
Sub GetMyBinaryString(ByVal connection As MySqlConnection)
Dim insertCommand As New MySqlCommand("INSERT INTO autotest.simple_types (f_binary, f_varbinary) VALUES (:p1, :p2)", connection)
Dim encod As Encoding = Encoding.Unicode
Dim buffer1 As Byte() = encod.GetBytes("test1")
Dim buffer2 As Byte() = encod.GetBytes("test2")
insertCommand.Parameters.Add("p1", New MySqlBinaryString(buffer1, encod))
insertCommand.Parameters.Add("p2", New MySqlBinaryString(buffer2, encod))
insertCommand.ExecuteNonQuery()
Dim selectCommand As New MySqlCommand("SELECT f_binary, f_varbinary FROM autotest.simple_types", connection)
Using reader As MySqlDataReader = selectCommand.ExecuteReader
Do While reader.Read
For i As Integer = 0 To reader.FieldCount - 1
Dim value As MySqlBinaryString = reader.GetMySqlBinaryString(i)
value.Encoding = encod
Console.WriteLine(value)
Next i
Loop
End Using
End Sub |
See Also
