how to retrieve image from data base ?

Faisal Ansari

hello guys how r u ?

i want to retrieve image in picture box from database on datagridview cell click event .
but exception raising like "parameter is not valid"
code below here

private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)

{

Image image;

int id = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells["ID"].Value);

SqlConnection con = new SqlConnection(@"Data Source=ITOFASL254\SQLEXPRESS; Initial Catalog=TestDB; Integrated Security=SSPI; user id=sa; password=passpass; Trusted_Connection=False; database=TestDB;");

con.Open();

SqlDataAdapter adapter = new SqlDataAdapter();

adapter.SelectCommand = new SqlCommand("select Image from ImageStore where ID=" + dataGridView1.Rows[e.RowIndex].Cells["ID"].Value, con);

DataSet ds = new DataSet();

adapter.Fill(ds);

if (ds.Tables[0].Rows.Count > 0)

{

byte[] imageData = (byte[])ds.Tables[0].Rows[0][0];

using (MemoryStream ms = new MemoryStream(imageData, 0, imageData.Length))

{

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

image = Image.FromStream(ms);

}

pictureBox1.Image = image;

}

con.Close();
}

Reply soon

5 Replies

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

Vulpes14y ago
The only other reason I can think of why you'd get an exception on that line is if the image is either not valid at all or is not one which .NET supports.

What type of image is it?
Faisal Ansari14y ago
hi guys sudhakar and vulpes, i tried of both of you codes but same exception still here "parameter is not valid" on this line " image = Image.FromStream(ms);" :(
fahad sheikhji14y ago
hi faisal i will help you..but you too help me even i stuck with sving image to database in winform..even i posted my code

datagrid cell click event

try this

private void dataGridView1_CellEnter(object sender, DataGridViewCellEventArgs e)
        {
            try
            {
                byte[] imageData = (byte[])dataGridView1.Rows[e.RowIndex].Cells["cdCustomerPhoto"].Value;
                Image newImage;
                using (MemoryStream ms = new MemoryStream(imageData, 0, imageData.Length))
                {
                    ms.Write(imageData, 0, imageData.Length);
                    newImage = Image.FromStream(ms, true);
                }

                pictureBox1.Image = newImage;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }

it will help you..
Sudhakar Chaudhary14y ago
adapter.SelectCommand = new SqlCommand("select Image from ImageStore
where ID=" + dataGridView1.Rows[e.RowIndex].Cells["ID"].Value, con); i think problem is in colored area.

solution:
ID='"+dataGridView1.Rows[e.RowIndex].Cells["ID"].Value.ToString() +"',con

my code....
try
{
SqlCommand command = new SqlCommand("select N_IMG from SCH2 where F_RECNO='" + FRECNO + "'", con);
SqlDataAdapter dp = new SqlDataAdapter(command);
DataSet ds = new DataSet();
byte[] MyData = new byte[0];
dp.Fill(ds, "s");
DataRow myRow;
myRow = ds.Tables["s"].Rows[0];
MyData = (byte[])myRow["N_IMG"];
MemoryStream stream = new MemoryStream(MyData);
pictureBox1.Image = Image.FromStream(stream);
}
catch (Exception ms)
{
MessageBox.Show("There Are No Image of This Person.", "Message Box");
}
Vulpes14y ago
I'd see if it makes any difference if you insert the highlighted line:

using (MemoryStream ms = new MemoryStream(imageData, 0, imageData.Length))
{
ms.Write(imageData, 0, imageData.Length);
ms.Seek(0, SeekOrigin.Begin);
image = Image.FromStream(ms);
}