how retrieve longblob format

Asked Feb 23 '13 at 03:42

Active Feb 23 '13 at 03:42

Viewed 569 times

How i should display the longblob format?
I want to retreive "content" longblob format in MYSQL with c#.

    string MyConnectionString = "Server=localhost;Database=newsborad;Uid=root;Pwd=root;"; 

    //this is the connection with the MYSQL
    MySqlConnection conn = new MySqlConnection(MyConnectionString); //communicate MYSQL
    MySqlCommand cmd = conn.CreateCommand();
    conn.Open();
    //content is longblob format in MYSQL
    cmd.CommandText = "Select content from message where msg_id = @id";
    cmd.Parameters.AddWithValue("@id", "1");

    while (reader.Read())
    {
        //how i should code?
    }
    conn.Close();

asked Feb 23 '13 at 03:42

Ferrick Chan

Refer to this post http://stackoverflow.com/questions/11526209/reading-blob-image-from-mysql-database has a good example – Agustin Meriles Feb 23 '13 at 03:50
http://stackoverflow.com/questions/948174/how-do-i-convert-from-blob-to-text-in-mysql – शेखर Feb 23 '13 at 05:15
hope this is more helpful http://stackoverflow.com/questions/8257941/retrieve-longblob-from-mysql-in-c-sharp – शेखर Feb 23 '13 at 05:19

how retrieve longblob format

0 Answers0