Re: ASP .Net issue with Oracle client - C# Discussion Boards

L'Exception ArgumentException was not Operated

31-Mar-14 4:14

It's difficult to say with the scant information you've supplied. How are you connecting to Oracle? What drivers are you using? Are you getting any exceptions?

remiki31-Mar-14 2:35

31-Mar-14 2:35

Hello,
wanting to display a photo after it is recorded,
an error message is displayed me "L'Exception ArgumentException was not Operated"

DataSet ds = new DataSet();
                    adpt.Fill(ds, "client");
                    int c = ds.Tables["client"].Rows.Count;
                    if (c > 0)
                    {
                        Byte[] btpht = new Byte[0];
                        btpht = (Byte[])(ds.Tables["client"].Rows[c - 1]["photo"]);
                        MemoryStream phtosssss = new MemoryStream(btpht);

                        try
                        {
                        //Here is the Message
                            pictureBox1.Image = Image.FromStream(phtosssss);//the error is appear here
                            
                        }
                        catch (Exception ex)
                        { MessageBox.Show(ex.Message); }
                    }

Soyons toujours à la disposition des autres

Pete O'Hanlon31-Mar-14 3:12

31-Mar-14 3:12

Put a breakpoint on the line that creates your byte array and check that you have populated it after you step over the row. You're looking for a reasonably large value in there.

remiki31-Mar-14 3:22

31-Mar-14 3:22

look all that i Did

void prece_dent()
      {
          //try{
              if (INDEX != 1)
              {
                  INDEX--;
                  lblenre.Text = "" + INDEX + " / " + rowCount;
                  OdbcConnection cnx = new OdbcConnection("DSN=KINGMINDONGO");
                  cnx.Open();
                  OdbcDataReader dtr;
                  OdbcCommand comded = new OdbcCommand("select *from client where code_client=" + @Convert.ToDecimal(code_client.Text));
                  comded.Connection = cnx;
                  dtr = comded.ExecuteReader();
                  for (int i = 0; i < INDEX; i++) dtr.Read();
                  code_client.Text = dtr.GetInt32(0).ToString();
                  nom.Text = dtr.GetString(1);
                  prenom.Text = dtr.GetString(2);
                  societe.Text = dtr.GetString(3);
                  date_naissance.Text = dtr.GetDate(4).ToString();
                  lieu_naissance.Text = dtr.GetString(5);
                  adresse.Text = dtr.GetString(6);
                  tel.Text = dtr.GetInt32(7).ToString();
                  fax.Text = dtr.GetInt32(8).ToString();
                  e_mail.Text = dtr.GetString(9);
                  compte_bancaire.Text = dtr.GetInt32(10).ToString();
                  banque.Text = dtr.GetString(11);


                  OdbcDataAdapter adpt = new OdbcDataAdapter(comded);
                  dtr.Close();
                  DataSet ds = new DataSet("client");
                  adpt.Fill(ds, "client");
                  int c = ds.Tables["client"].Rows.Count;
                  if (c > 0)
                  {

                      //var data = (Byte[])(ds.Tables["client"].Rows[c - 1]["photo"]);
                      //var stream = new MemoryStream(data);

                      Byte[] btpht = new Byte[0];
                      btpht = (Byte[])(ds.Tables["client"].Rows[c - 1]["photo"]);
                      MemoryStream phtosssss = new MemoryStream(btpht);

                      //try
                      //{
                          pictureBox1.Image = Image.FromStream(phtosssss);

                     // }
                      //catch (Exception ex)
                      //{ MessageBox.Show(ex.Message); }
                  }

Pete O'Hanlon31-Mar-14 4:04

31-Mar-14 4:04

And how many bytes are in your byte array?

remiki31-Mar-14 4:13

31-Mar-14 4:13

my problem is to recover the recorded image and display it in the picturebox

Pete O'Hanlon31-Mar-14 4:15

31-Mar-14 4:15

Yes, I got that. What I'm trying to get to here is what data is in your memory stream after you have read it from the database? Do you have any bytes there to convert into an image?

Dave Kreskowiak31-Mar-14 4:19

Dave Kreskowiak

31-Mar-14 4:19

You're not listening. We'll try this again.

How many bytes are in the array before you send it to the MemoryStream?!

If it's zero, your query didn't return any image data, therefore you can't make a Bitmap from it.

A guide to posting questions on CodeProject

How to debug small programs

Dave Kreskowiak

remiki31-Mar-14 4:21

31-Mar-14 4:21

what can i do?? by seeing my codes?

can't you help??

Pete O'Hanlon31-Mar-14 4:38

31-Mar-14 4:38

No we can't help, not until you actually check that you have data in your byte array.

Byte[] btpht = new Byte[0];
btpht = (Byte[])(ds.Tables["client"].Rows[c - 1]["photo"]);

After you step over this line, how many bytes are in btpht? Oh, and you don't need to new up the byte beforehand.

remiki31-Mar-14 4:57

31-Mar-14 4:57

i don't know what to say in my database, i have only one registration

Dave Kreskowiak31-Mar-14 4:48

Dave Kreskowiak

31-Mar-14 4:48

WE ARE TRYING TO HELP!!!!!!!!!!!!!!!!!!!!!! Mad | :mad:

The problem is that you're not listening and you're not doing what we're telling you to do to help diagnose the problem! You're NOT helping us help you!

YOU have to do the work! We don't have access to your machine and we can't see your monitor, so how else is this going to get fixed??

A guide to posting questions on CodeProject

How to debug small programs

Dave Kreskowiak

modified 31-Mar-14 10:55am.

remiki31-Mar-14 5:11

31-Mar-14 5:11

i use Access data-base
and i have used OLE object in my image data

remiki31-Mar-14 5:15

31-Mar-14 5:15

when I created my data base in access, is displaying binary data (my image data)

Pete O'Hanlon31-Mar-14 5:25

31-Mar-14 5:25

You still haven't told us if you've stepped over that line of code and checked the size of it. We aren't trying to trick you here. You really do need to check that you've populated it first.

remiki31-Mar-14 5:42

31-Mar-14 5:42

i said that until now, just one picture in my database

Pete O'Hanlon31-Mar-14 5:48

31-Mar-14 5:48

But is that picture actually making it through to your code? That's what we have been trying to get you to check. Look, do what I asked and put a breakpoint on your code and step over that line - then check how big your byte array is. It's not difficult. I'm not asking you to rewire the space shuttle. I'm just asking you to check that you are getting, in this field, what you would be expecting. Then, if you are, we have ruled out one problem and we can move onto potential causes.