.NET & fields of type text
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
Subject
Written By
Posted
.NET & fields of type text
February 02, 2005 08:56AM
February 02, 2005 10:10AM
February 02, 2005 10:13AM
February 23, 2006 12:08AM
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.