Use Value property to get string that is stored in a MySqlText instance. This is a read-only property, thus you can not use it to assign strings to the object. To obtain a MySqlText with another string you have to either create a new instance (recommended) or use stream methods (i.e. Read, MySqlBlob.Write).
If you wish to treat MySqlText as a stream, you have to perform all encoding/decoding operations yourself. Read more about how to set up encoding in topic MySqlText.
while (myReader.Read()) { MySqlText myTextSql = myReader.GetMySqlText(myReader.GetOrdinal("BlockContent")); if(!myTextSql.IsNull) { Console.WriteLine(myTextSql.Value); } }
While myReader.Read() Dim myTextSql As MySqlText = myReader.GetMySqlText(myReader.GetOrdinal("BlockContent")) If Not myTextSql.IsNull Then Console.WriteLine(myTextSql.Value) End If End While
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2