“无法将类型为'System.String'的对象强制转换为'System.Byte []'。”

问题描述

  try
  {
    string query = "select F_Name,L_Name, Image from Employee where EID='" + txtid.Text + "'";
    if (con.State != ConnectionState.Open)
        con.Open();
    SqlCommand cmd = new SqlCommand(query, con);
    SqlDataReader sdr = cmd.ExecuteReader();
    sdr.Read();
    if(sdr.HasRows)
    {

        Ftxt.Text = sdr[0].ToString();
        Ltxt.Text = sdr[1].ToString();
     //   byte[] aa = (byte[])sdr[2];
        byte[] img = (byte[])(sdr[2]);
        if (img == null)
            pictureBox.Image = null;
        else
        {
            MemoryStream ms = new MemoryStream(img);
            pictureBox.Image = Image.FromStream(ms);

        }
        con.Close();
    }
    else
    {
        MessageBox.Show("ID Not Exist");
    }


}
catch (Exception )
{
    con.Close();
    throw;
}

推荐答案

这篇关于“无法将类型为'System.String'的对象强制转换为'System.Byte []'。”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！