SqlCommand cmd = new SqlCommand("select * from persons ier join persons_description on persons.id=persons_description.pid ier join persons_image on persons.id=persons_image.pid", con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count>0)
{
Byte[] bt = (Byte[])dt.Rows[0][9];
string base64string = Convert.ToBase64String(bt, 0, bt.Length);
img.ImageUrl = base64string;
}
با سپاس
برچسب:
نویسنده: محمد رضا جوادیان