Hi Vincent
Why are you using a string variable? I guess you should use a byte array
or something similar. Just check the manual and you'll find a nice example.
http://npgsql.projects.postgresql.org/docs/manual/UserManual.htm
It uses a file stream but changing that to a memory stream shouldn't be
a problem..
Kind regrads,
Remo
command = new NpgsqlCommand("select field_bytea from tableBytea where
field_serial = (select max(select field_serial) from tableBytea);", conn);
Byte[] result = (Byte[])command.ExecuteScalar();
fs = new FileStream(args[0] + "database", FileMode.Create,
FileAccess.Write);
BinaryWriter bw = new BinaryWriter(new BufferedStream(fs));
bw.Write(result);
bw.Flush();
fs.Close();
bw.Close();
>
> Hi all,
>
>
>
> I want to insert an image into a bytea field from my database. I work
> with C#.
>
>
>
> My code for transform my image to bytea is :
>
>
>
> MemoryStream ms = new MemoryStream();
>
> Image img = pictureBox1.Image;
>
> img.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
>
> byte[] tab = ms.ToArray();
>
> string simg = System.Convert.ToBase64String(tab);
>
>
>
> And my requete is :
>
> Insert into image (mypicture) values (‘ ” + simg + “’) “
>
>
>
> But my problem is not here.
>
>
>
> When I want to recover my picture, I excute this code :
>
>
>
> cmd.CommandText = "select * from image";
>
> Npgsql.NpgsqlDataReader dr = cmd.ExecuteReader();
>
> dr.Read();
>
> string img = (string)dr["mypicture"];
>
> byte[] tab = System.Convert.FromBase64String(img);
>
> MemoryStream ms = new MemoryStream(tab);
>
> Image returnImage = Image.FromStream(ms);
>
>
>
>
>
> An error is generate when I execute the lign “MemoryStream ms = new
> MemoryStream(tab);”
>
>
>
> I don’t understand where is my error. Can you help me please.
>
>
>
> Thanks you at all.
>
>
>
> Vincent Lemaire
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Npgsql-general mailing list
> Npgsql-general@gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/npgsql-general
>
_______________________________________________
Npgsql-general mailing list
Npgsql-general@gborg.postgresql.org
http://gborg.postgresql.org/mailman/listinfo/npgsql-general
