المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : image from access database in c#



C# Programming
12-11-2012, 06:57 AM
pls help wiht this code


int intOrder = int.Parse(frmInput.InvoiceOrder);
byte[] photo_aray;
OleDbDataAdapter adapter = new OleDbDataAdapter("select photo from cards where id= " + intOrder, strCon);
DataSet ds = new DataSet();
adapter.Fill(ds, "cards");
// ds.Tables[0].Constraints.Add("pk_sno", ds.Tables[0].Columns[0], true);

picBox1.Image = null;
if (ds.Tables[0].Rows[rno][6] != System.DBNull.Value)
{
photo_aray = (byte[])ds.Tables[0].Rows[rno][6];
MemoryStream ms = new MemoryStream(photo_aray);
picBox1.Image = Image.FromStream(ms);
}

}

image not showing in picbox