How to retrive an image from folder nad show it in an image control.

See more:

C#

ASP.NET

C#4.0

Dear sir,
in my asp.net application, I stored all the employee information inside tbl_employee.But here I save the path of an image and his image in empimage folder.

How to retrieve this employee image and show it on an image control as per the employees, I have selected.

protected void btnReset0_Click(object sender, EventArgs e)
  {
      string path = "";
      try
      {
          cmd.CommandText = "select EmpName,Department,StaffType,SubjectPrefer,Experience,Qualification,EmpId,image from tblEmployeeInformation where EmpName='" + DropDownList1.SelectedValue + "'";
          cmd.Connection = con;
          if (con.State == ConnectionState.Closed)
              con.Open();
          dr = cmd.ExecuteReader();
          if (dr.Read())
          {
              txtEmpName.Text = dr["EmpName"].ToString();
              ddlDepaartment.SelectedValue = dr["Department"].ToString();
              ddlSubPreference.SelectedValue = dr["SubjectPrefer"].ToString();
              ddlExperience.SelectedValue = dr["Experience"].ToString();
              ddlQualification.SelectedValue = dr["Qualification"].ToString();
              txtEmpId.Text = dr["EmpId"].ToString();
              path = dr["image"].ToString();
              if (path != null)
              {
                  Image1.ImageUrl = path;
              }
          }
          else
              Response.Write("<script LANGUAGE='JavaScript' >alert('-"+DropDownList1.SelectedValue+"-')</script>");
      }
      catch (Exception ex)
      {
          Response.Write("<script LANGUAGE='JavaScript' >alert('" + ex.Message + "')</script>");
      }
  }

Here the path from database retrieve to the path variable, but does not show the image in image control.