.NET & fields of type text
Posted by: Simone Lippolis
Date: February 02, 2005 08:56AM

I'm workin' with c# on .net with a mySql database. I use mySqlCs drivers to connect to the db server.
I have a problem reading fields of type "text", my application always returns me a System.Byte string, it seems that my application is not able to correctly read data from database.
Here is a code snippet:

MySQLConnection mysqlconn = new MySQLConnection(ConfigurationSettings.AppSettings["Conn"]);
mysqlconn.Open();
string sql = "SELECT XmlTemplate FROM " + ConfigurationSettings.AppSettings["DbPrefix"] + "xmlTemplate WHERE Id = 1 LIMIT 0,1";
MySQLCommand cmd = new MySQLCommand(sql,mysqlconn);
MySQLDataReader dr = cmd.ExecuteReaderEx();
while (dr.Read())
{
Response.Write(dr["XmlTemplate"].ToString());
}
mysqlconn.Close();

Does anyone know how to solve this problem? Any known issues? I was not able to find anything about this.
Thank you in advance,
Simone

Options: ReplyQuote


Subject
Written By
Posted
.NET & fields of type text
February 02, 2005 08:56AM
February 02, 2005 10:10AM
March 26, 2005 06:28PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.