how to display my image on my picturebox with "search"

Israel

Hi!

I do search on the net how to display on the picturebox. I do find solution but it's wrote with others codes. What I need I want to follow the way I wrote my codes.
Please have a look and help me to correct these codee to display my picture from database please. Thanx:

string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test1\test2\\app_data\office.mdb;Persist Security Info=False";

OleDbConnection sqlCon = new OleDbConnection(connectionString);

sqlCon.Open();

string commandString = "select * from full_personal where nome ='" + txtName.Text + "'";

OleDbCommand sqlCmd = new OleDbCommand(commandString, sqlCon);

OleDbDataReader read = sqlCmd.ExecuteReader();

if (read.HasRows)

{

while (read.Read())

{

txtCod.Text = read["code"].ToString();

cbxNumberType.Text = read["number"].ToString();

picBxCadastFunc.Image = read["foto"].ToString();

}

read.Close();

sqlCon.Close();

}

12 Replies

Know the answer? Post it — somebody with the same question will find it here.

nico cedrick adriano12y ago
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{

id = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value);
textBox2.Text = Convert.ToString(dataGridView1.CurrentRow.Cells[1].Value);
textBox3.Text = Convert.ToString(dataGridView1.CurrentRow.Cells[2].Value);
textBox4.Text = Convert.ToString(dataGridView1.CurrentRow.Cells[3].Value);
textBox5.Text = Convert.ToString(dataGridView1.CurrentRow.Cells[4].Value);
textBox6.Text = Convert.ToString(dataGridView1.CurrentRow.Cells[5].Value);
textBox7.Text = Convert.ToString(dataGridView1.CurrentRow.Cells[6].Value);
textBox8.Text = Convert.ToString(dataGridView1.CurrentRow.Cells[7].Value);
textBox9.Text = Convert.ToString(dataGridView1.CurrentRow.Cells[8].Value);

var temp = dataGridView1.CurrentRow.Cells[9].Value.ToString();

if (dataGridView1.CurrentRow.Cells[9].Value.ToString() != "")
{

MemoryStream ms = new MemoryStream((byte[])dataGridView1.CurrentRow.Cells[9].Value);
//pictureBox1.Image = new Bitmap(ms);
pictureBox1.Image = Image.FromStream(ms, true);

}
else
{
pictureBox1.Image = null;
}

//pictureBox1.Image = dataGridView1.CurrentRow.Cells[9].Value as Image;

textBox10.Text = Convert.ToString(dataGridView1.CurrentRow.Cells[10].Value);
textBox11.Text = Convert.ToString(dataGridView1.CurrentRow.Cells[11].Value);
}
0
Vulpes12y ago
Sorry but I haven't :(

If only two bytes are being read, then clearly it's not an image but if you're sure that the column called 'foto' does contain an image (OLE object) and it's displaying OK in Access, then it's difficult to see why it's not working.
0
Israel12y ago
@Vulpes I dont know how to do right now. All the columns work. Only the picture one (or foto). Doesnt! I do recreate another new database just to test it. Nothing happen. Please did you have other thing to suggest me please???
0
Israel12y ago
I am not sure what its happen. But let's me see very well my database. Later will let you know Vulpes...
0
Vulpes12y ago
Clearly, there's something wrong here as the number should be 'thousands' of bytes, not 2.

I take it that the image is displaying OK in Access itself?

Are you sure that this is the correct column you're reading. A byte value of 2 suggests it's an Integer column rather than an OLE object :-/
0
Israel12y ago
I do try it its gives the boxmessage with the number "2". After that the boxmessage desapear and its gives this message:
Non-negative number required.
Parameter name: count
0
Vulpes12y ago
Well, I expected that it would be an OLE Object and my previous answer anticipated that by removing the OLE header which is 78 bytes long.

So, if it's still not working, it's difficult to know what else to suggest :(

I guess we'd better check that the byte array isn't empty. Can you insert the highlighted line and tell me what you see:

while (read.Read())
{
txtCod.Text = read["code"].ToString();
cbxNumberType.Text = read["number"].ToString();
byte[] blob = (byte[])read["foto"];
MessageBox.Show(blob.Length.ToString());
var ms = new System.IO.MemoryStream();
ms.Write(blob, 78, blob.Length - 78);
Bitmap bmp = new Bitmap(ms);
picBxCadastFunc.Image = bmp;
}
0
Israel12y ago
still not works Vulpes. The type of my column is "Objeto OLE"
0
Vulpes12y ago
Does it make any difference if you change this line:

ms.Write(blob, 0, blob.Length);

to this:

ms.Write(blob, 78, blob.Length - 78);

If it's no better, what is the type of the 'foto' column in the Access database?

0
Israel12y ago
@Vulpes

Its runs but when I make my search. Its showing a bug message: parameter not valid
The entire codes:

string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test1\test2\\app_data\office.mdb;Persist Security Info=False";
OleDbConnection sqlCon = new OleDbConnection(connectionString);
sqlCon.Open();
string commandString = "select * from full_personal where nome ='" + txtName.Text + "'";
OleDbCommand sqlCmd = new OleDbCommand(commandString, sqlCon);
OleDbDataReader read = sqlCmd.ExecuteReader();

if (read.HasRows)
{
while (read.Read())
{
txtCod.Text = read["code"].ToString();
cbxNumberType.Text = read["number"].ToString();
byte[] blob = (byte[])read["foto"];
var ms = new System.IO.MemoryStream();
ms.Write(blob, 0, blob.Length);
Bitmap bmp = new Bitmap(ms);
picBxCadastFunc.Image = bmp; //the bug it's here: Its says "parameter not valid"
}
read.Close();
}

sqlCon.Close();
0
Vulpes12y ago
If the image itself is stored in the database rather than a file path, then you'll need to read it as binary data and then reconstitute it as a bitmap before you can assign it to the picturebox's Image property:

string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test1\test2\\app_data\office.mdb;Persist Security Info=False";
OleDbConnection sqlCon = new OleDbConnection(connectionString);
sqlCon.Open();
string commandString = "select * from full_personal where nome ='" + txtName.Text + "'";
OleDbCommand sqlCmd = new OleDbCommand(commandString, sqlCon);
OleDbDataReader read = sqlCmd.ExecuteReader();

if (read.HasRows)
{
while (read.Read())
{
txtCod.Text = read["code"].ToString();
cbxNumberType.Text = read["number"].ToString();
byte[] blob = (byte[])read["foto"];
var ms = new System.IO.MemoryStream();
ms.Write(blob, 0, blob.Length);
Bitmap bmp = new Bitmap(ms);
picBxCadastFunc.Image = bmp;
}
read.Close();
}

sqlCon.Close();
0
Israel12y ago
PLEASE I need the solution on my request. Thanx!
0