Re: Saving picture to SQL (PictureBox) GDI Error - C# Discussion Boards

try with png format

image.Save(ms, System.Drawing.Imaging.ImageFormat.Png);

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKQUFK[M`UKs*$GwU#QDXBER@CBN%
R0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>

-----------------------------------------------
128 bit encrypted signature, crack if you can

Nope.. didn't work... I dug deeper into the breakpoints and see this:

ReadTimeout '((System.IO.Stream)(ms)).ReadTimeout' threw an exception of type 'System.InvalidOperationException' int {System.InvalidOperationException}
base {"Timeouts are not supported on this stream."} System.SystemException {System.InvalidOperationException}

+ WriteTimeout '((System.IO.Stream)(ms)).WriteTimeout' threw an exception of type 'System.InvalidOperationException' int {System.InvalidOperationException}
+ base {"Timeouts are not supported on this stream."} System.SystemException {System.InvalidOperationException}

looks like a bug, link[^]
but I never have this problem

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKQUFK[M`UKs*$GwU#QDXBER@CBN%
R0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>

-----------------------------------------------
128 bit encrypted signature, crack if you can

Do you think there is another way of getting the image from the picture box and saving it to a sql database?

try this

new Bitmap(pictureBoxPicture.Image).Save(ms, ImageFormat.Png);

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKQUFK[M`UKs*$GwU#QDXBER@CBN%
R0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>

-----------------------------------------------
128 bit encrypted signature, crack if you can

Works the same but with less code and looks better.

You know if I am saving it as a png file do I have to export it from the database as a png?

Jacob Dixon wrote:
Works the same but with less code and looks better.

you mean no error now ?

Jacob Dixon wrote:
You know if I am saving it as a png file do I have to export it from the database as a png?

yes...png is best format.

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKQUFK[M`UKs*$GwU#QDXBER@CBN%
R0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>

-----------------------------------------------
128 bit encrypted signature, crack if you can

Hi,

GDI+ has the tendency to name every problem happening in Image.Save() a "generic problem occured in GDI+". It could be a full disk, a locked file, whatever. In your case the MemoryStream can hardly fail (unless you are near an out-of-memory situation), but your image itself could be invalid (not sure how you would get PictureBox accept an invalid image, unless you first assign it to PictureBox.Image, and then do something to it.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets

Well I use a OpenFileDialog to select a file and set the pictureBox.Image.

Then I use the above code when you click the Save button to get the bytes and insert it into a column in a database... but it never even gets to that. I tried this and it works (not very well for large images over VPN):

byte[] GetPicData()
{
    MemoryStream ms = new MemoryStream();
    Bitmap bmNew = new Bitmap(pictureBoxPicture.Width, pictureBoxPicture.Height, PixelFormat.Format24bppRgb);
    Graphics g = Graphics.FromImage(bmNew);
    g.DrawImage(pictureBoxPicture.Image, new Point(0, 0));
    g.Dispose();

    bmNew.Save(ms, ImageFormat.Png);

    byte[] invPic = ms.ToArray();
    ms.Close();
    return invPic;
}

Hi,

that code looks OK.
BTW: The PictureBox serves no purpose except it gives some size.

If your image happens to be zero*zero pixels, it could still work, whereas maybe PictureBox.Image (and hence the original code) would not work, I don't know. I avoid PictureBoxes, they tend to cause more trouble than what they are worth.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets

What do you do to display an image? Do you draw the image on the form?

I tend to paint it myself on a Panel.
Also see reply below.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets

Luc Pattyn wrote:
I avoid PictureBoxes, they tend to cause more trouble than what they are worth.

like ? I never got any problem with PB. I use BackgroundImage instead.

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKQUFK[M`UKs*$GwU#QDXBER@CBN%
R0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>

-----------------------------------------------
128 bit encrypted signature, crack if you can

Hi,

I paint my images myself, typically onto a Panel. That avoids problems such as:
- I want my pictures to preserve aspect ratio while being rescaled
- I want to select pixels with the mouse, even when the image has been rescaled
- I want to be able to draw a rubber band, even when the image has been rescaled
etc.

All of these are either impossible or much harder than they deserve to be when using a PB.
The one thing I would consider using it for is for displaying an animated image (multiTIFF and the like).

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets

well, If you're a pro programmer then you should use the appropriate control. PB is for pictures and panel for containing other controls. Am I wrong...? All the operations you're doing with Panel can be done with PB but since Panel is more powerful in itself, its not good to compare with PB. Its like byte(PB) and int(Panel).

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKQUFK[M`UKs*$GwU#QDXBER@CBN%
R0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>

-----------------------------------------------
128 bit encrypted signature, crack if you can

I agree with both of you. I am not a Pro Programmer (yet Smile | :)

lol), but I see the advantages of both. One, I know how to use a picturebox (well I thougth I did before this issue, but it seems to be a little bug), and I do not know how to paint pictures at ALL. I would like to learn it, and I think I might try the panel way to just test it out. Not really sure where to begin so I will google painting image on panel

Hi,

there are lots of articles that demonstrate how to paint things. My Sokoban article is a simple example, the playing board actually is a Panel.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets

Luc Pattyn wrote:
My Sokoban article is a simple example

nice work man, you got ma 5 Wink | ;)

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKQUFK[M`UKs*$GwU#QDXBER@CBN%
R0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>

-----------------------------------------------
128 bit encrypted signature, crack if you can

Now I take it you can not only write an image to a panel, but you can retrieve an image from it?

simple drawing method

Draw image and set it to global variable. Then in OnPaint() draw that image. In this way, you can have image anytime. But if you just want to set a single image from file or stream, I'll suggest you to use BackgoundImage property. No coding required. Plus you can use styles, Tiles, Center, Zoom...etc

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKQUFK[M`UKs*$GwU#QDXBER@CBN%
R0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>

-----------------------------------------------
128 bit encrypted signature, crack if you can

Hi Jacob,

first of all, if you have code to paint/draw something (that is a "Paint handler" which is called automatically with a "Graphics" parameter), you have all the information and the same code could be used to draw onto another Graphics object, e.g. one you obtain from Bitmap.CreateGraphics().

Furthermore there is a Control.DrawToBitmap() method available for all Controls, it creates a bitmap showing the Control the way it looks on screen. Since a Panel does not draw anything by itself, Panel.DrawToBitmap() paints your own content to the bitmap, which is quite handy.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets

ohh.. ok that sounds like something I might be able to use to show a picture of our floor plan. Thanks for all of your guys help

Xmen wrote:
you should use the appropriate control.

Yes, when available.

Xmen wrote:
PB is for pictures and panel for containing other controls.

A PB can hold other controls as well. So it is doing (or trying to do) more than what a Panel does.
When not containing other Controls, a Panel is just like a piece of canvas, ideal for painting and drawing whatever you want.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets

Luc Pattyn wrote:
A PB can hold other controls as well.

aye aye but not like panel...you have to add programmatically.

Luc Pattyn wrote:
When not containing other Controls, a Panel is just like a piece of canvas, ideal for painting and drawing whatever you want.

aha but no support for gif Wink | ;)

but no worries, this is end of discussion

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKQUFK[M`UKs*$GwU#QDXBER@CBN%
R0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>

-----------------------------------------------
128 bit encrypted signature, crack if you can

I have text file data and I upload that data to DataGridView. Then, i want to save that data to Table in MySQL. I have tried to make the code. But, when I execute there are some error. Please help me. This is my code :

MySqlConnection con = new MySqlConnection();
con.ConnectionString = "Persist Security Info=False;database=skripsiku;server=localhost;Connect Timeout=90;user id=root; pwd=";
MySqlCommand cmd = con.CreateCommand();

try
{
con.Open();
cmd.CommandText = "INSERT INTO output" +
"(id_output, path, global_effect, direct_effect, path_mult, total_effect , persen_global , cum_persen) " +
"VALUES " + "(@id_output, @path, @global_effect, @direct_effect, @path_mult, @total_effect , @persen_global , @cum_persen)";

cmd.Parameters.Add("@id_output", MySqlDbType.Int32, 5);
cmd.Parameters.Add("@path", MySqlDbType.VarChar, 7);
cmd.Parameters.Add("@global_effect", MySqlDbType.VarChar, 7);
cmd.Parameters.Add("@direct_effect", MySqlDbType.VarChar, 7);
cmd.Parameters.Add("@path_mult", MySqlDbType.VarChar, 7);
cmd.Parameters.Add("@total_effect", MySqlDbType.VarChar, 7);
cmd.Parameters.Add("@persen_global", MySqlDbType.VarChar, 7);
cmd.Parameters.Add("@cum_persen", MySqlDbType.VarChar, 7);

// Masukkan data ke masing-masing kolo

for (int i = 0; i <= this.dataGridView1.Rows.Count; i++)
{
cmd.Parameters["@id_output"].Value = i+1;
cmd.Parameters["@path"].Value = this.dataGridView1[0,i].Value;
cmd.Parameters["@global_effect"].Value = this.dataGridView1[1,i].Value;
cmd.Parameters["@direct_effect"].Value = this.dataGridView1[2,i].Value;
cmd.Parameters["@path_mult"].Value = this.dataGridView1[3,i].Value;
cmd.Parameters["@total_effect"].Value = this.dataGridView1[4,i].Value;
cmd.Parameters["@persen_global"].Value = this.dataGridView1[5,i].Value;
cmd.Parameters["@cum_persen"].Value = this.dataGridView1[6,i].Value;

cmd.ExecuteNonQuery();
}

}

finally
{
con.Close();
}

thanks for your help