Blob in MySql using c#

[blackevanuz]

Hi I want to storage a txt file into mysql using a blob and after that extract it, the code i use to save it is:

 
            fs = new FileStream("C:\\Documents and Settings\\Pru.txt", FileMode.Open, FileAccess.Read);
            FileSize = fs.Length;
            rawData = new byte[FileSize];
            fs.Read(rawData, 0, Convert.ToInt32(FileSize));
            fs.Close();
            SQL = "INSERT INTO EEG (eeg)values ('" + rawData + "' )";
            cmd.CommandText = SQL;
            cmd.ExecuteNonQuery();
 

and my code to extract it is:

    MySqlDataReader myData;
    string SQL ="SELECT EEG FROM EEG WHERE id_eeg = '" + id + "' ";
    cmd.CommandText = SQL;
    myData = cmd.ExecuteReader();
    myData.Read();
    rawData = new byte[1000];
    myData.GetBytes(0, 0, rawData, 0,1000);
    for (i = 0; i < rawData.Length;i++)
        final[i] = Convert.ToString((rawData[i] << 8) + rawData[i+1]);
 fs = new FileStream("C:\\Documents and Settings\\Pru2.out", FileMode.OpenOrCreate,
FileAccess.Write);
    fs.Write(rawData, 0,1000); 
    fs.Close();
    myData.Close();
    conn.Close();
 
 

but I get a file with a text like this:
System.Byte[]

And it is not the text of the original file
Help!!!!
Thx

[blackevanuz]

Help!!!!! please!!!!!!!!!!!

[Hawkmoth]

I think I can help you. I also had the same problem.

Instead of this:-

SQL = "INSERT INTO EEG (eeg)values ('" + rawData + "' )";
cmd.CommandText = SQL;
cmd.ExecuteNonQuery();

try:-

SQL = "INSERT INTO EEG VALUES(?File)";
cmd.CommandText = SQL ;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("?File", rawData);
cmd.ExecuteNonQuery();

It worked for me!

Here is a link to where I got this information
http://dev.mysql.com/doc/refman/5.0/...sing-blob.html

[Plater]

Your read method confuses me. What are you doing with the >>8 and stuff?
Are you familiar with System.Text.Encoding.ASCII ?

And somewhere you are calling (possibly implicitly) a .ToString() on your byte[] object.