|
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?
|
|
|
|
|
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
{
pictureBox1.Image = Image.FromStream(phtosssss);
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
}
Soyons toujours à la disposition des autres
|
|
|
|
|
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.
|
|
|
|
|
void prece_dent()
{
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)
{
Byte[] btpht = new Byte[0];
btpht = (Byte[])(ds.Tables["client"].Rows[c - 1]["photo"]);
MemoryStream phtosssss = new MemoryStream(btpht);
pictureBox1.Image = Image.FromStream(phtosssss);
}
|
|
|
|
|
And how many bytes are in your byte array?
|
|
|
|
|
my problem is to recover the recorded image and display it in the picturebox
|
|
|
|
|
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?
|
|
|
|
|
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.
|
|
|
|
|
what can i do?? by seeing my codes?
can't you help??
|
|
|
|
|
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.
|
|
|
|
|
i don't know what to say in my database, i have only one registration
|
|
|
|
|
WE ARE TRYING TO HELP!!!!!!!!!!!!!!!!!!!!!! 
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??
modified 31-Mar-14 10:55am.
|
|
|
|
|
i use Access data-base
and i have used OLE object in my image data
|
|
|
|
|
when I created my data base in access, is displaying binary data (my image data)
|
|
|
|
|
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.
|
|
|
|
|
i said that until now, just one picture in my database
|
|
|
|
|
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.
|
|
|
|
|
Nobody, and especially your application, cares what YOU think is in the database. What is at hand is what the CODE thinks! And you're not even attempting to answer that question.
|
|
|
|
|
Do you know what debugging is?
It means you run the program, but stop it at some point (it is called a breakpoint). Then you can execute the code line by line and check the values of the variables (right-click - quickwatch).
What Pete and Dave are trying to explain is that the bytes that are in the database need to be copied into your code (adpt.Fill(ds, "client");). If that didn't work than the conversion from Byte[] to Image won't work.
So their question is: What is the "Length" of the btpht object AFTER this line: btpht = (Byte[])(ds.Tables["client"].Rows[c - 1]["photo"]);
Hope this helps.
(PS: respond to them the answer, not to this message)
|
|
|
|
|
until now i don't have an idea because it's my first time to use it, can't you tell me how to do about "LENGTH"?????
|
|
|
|
|
yes, I can.
Read a book.
I'm serious. You're lacking some basic knowledge, hence you don't understand what people are telling you.
If you cannot grasp the notion of a Length property of an array, contacting databases is way over your head.
Read a book and start from scratch. Create a "hello world" program and work your way up.
|
|
|
|
|
Then you should have said that you had no idea what how to use the debugger LONG before this.
|
|
|
|
|
Open the code file and click on the line that assigns the bytea array. Press F9 and you should see a red circle appear to the left of the code line - this is a breakpoint (to remove it, press F9 on that line again). Press F5 to run your application in debug mode and trigger the bit of code that populates your image. Step over the line of code by pressing F10. Right click on the variable btpht and select QuickWatch from the popup menu. You should see btpht in the Expression. To see the value, either expand the variable in the listview below or type btpht.Length in the expression and click Reevaluate.
|
|
|
|
|
please, my english is not good,
look at here
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);
pictureBox1.Image = Image.FromStream(phtosssss);
try to bring correction please i have tried but, no error message with the following code , but no picture posted in my picture box
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.Length);
pictureBox1.Image = Image.FromStream(phtosssss);
|
|
|
|
|
MINDONGO wrote: MemoryStream phtosssss = new MemoryStream(btpht.Length);
No. You should have left this as
MemoryStream phtosssss = new MemoryStream(btpht); All we want is for you to tell us what the Length is. I told you exactly which buttons to press to debug your application. You should have followed those exactly.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
