fileupload in mysql mono

[sheela]

im trying to upload file in to mysql database using the following code.. but it shows jus the file name and not the entire file while i retrive. how to store the file and retrive it from mysql using mono c#. ?

cmd.CommandText="insert into fileup values('"+entry1.Text+"','"+filechooserbutton1.Filename+  "')";
 

[PsychoCoder]

It's really inefficient to store the actual file in your database, for something like this I would store just the file name and the path to the file.

[nabdelmegeed]

It is not advisable to load the whole image in the database. It's recommended to upload the file to the sever then save its path in the database. And in order to retrieve the image all you do is retrieve its path for the database.
Anyway, I know that mysql uses datatype BLOBs (Binary Large OBjects) to save large files. In C# we use an array of bytes. So, I guess you'll retrieve the image into an array of bytes then assign it to the image control.

There more explanation <Link Removed>. Good Luck