venky n

venky n

  • NA
  • 110
  • 36.5k

How to retrieve image without using generic handler.

Mar 31 2015 9:21 AM
How to retrieve image without using generic handler.
imagestore method successfully store all image for binary format.But not retrieve
one image store at a time retrieve the single image for particular location.How its help me.

protected void imagestore()
        {
            try
            {
                using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["IHPDB"].ConnectionString))
                {
                    string empId = Session["LoggedInEmployeeId"].ToString();
                    SqlCommand cmd = new SqlCommand("Asp_TBLLandImage", con);
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.Add("@TRNID", SqlDbType.Int).Value = ImageTrnid.Value != "" ? Convert.ToInt32(ImageTrnid.Value) : 0;
                    cmd.Parameters.Add(new SqlParameter("@PropertyTRNID", String.IsNullOrEmpty(PropTrnid.Value) ? DBNull.Value : (object)PropTrnid.Value));

                    Byte[] imgByte1 = null;
                    Byte[] imgByte2 = null;
                    Byte[] imgByte3 = null;
                    Byte[] imgByte4 = null;

                    if (FileUpload9.HasFile && FileUpload9.PostedFile != null)
                    {
                        HttpPostedFile File = FileUpload9.PostedFile;
                        imgByte1 = new Byte[File.ContentLength];
                        File.InputStream.Read(imgByte1, 0, File.ContentLength);
                        cmd.Parameters.Add("Land", SqlDbType.VarBinary).Value = imgByte1;
                        // con.open();
                        //int id = Convert.ToInt32(cd.ExecuteScalar());
                        //lblStatus.Text = String.Format("ID is {0}", id);
                        //Image1.ImageUrl = "~/DisplayImg.ashx?id=" + id;
                          //con.close();

                    }
                    else
                    {
                        cmd.Parameters.Add("@Land", System.Data.SqlDbType.VarBinary).Value = DBNull.Value;
                    }

                    if (FileUpload10.HasFile && FileUpload10.PostedFile != null)
                    {

                        HttpPostedFile File = FileUpload10.PostedFile;
                        imgByte2 = new Byte[File.ContentLength];
                        File.InputStream.Read(imgByte2, 0, File.ContentLength);
                        cmd.Parameters.Add("@MasterPlan", SqlDbType.VarBinary).Value = imgByte2;
                        // con.open();
                        //int id = Convert.ToInt32(cd.ExecuteScalar());
                        //lblStatus.Text = String.Format("ID is {0}", id);
                        //Image2.ImageUrl = "~/DisplayImg.ashx?id=" + id;
                          //con.close();

                    }
                    else
                    {
                        cmd.Parameters.Add("@MasterPlan", System.Data.SqlDbType.VarBinary).Value = DBNull.Value;
                    }
                    if (FileUpload11.HasFile && FileUpload11.PostedFile != null)
                    {
                        HttpPostedFile File = FileUpload11.PostedFile;
                        imgByte3 = new Byte[File.ContentLength];
                        File.InputStream.Read(imgByte3, 0, File.ContentLength);
                        cmd.Parameters.Add("@LocationMap", SqlDbType.VarBinary).Value = imgByte3;

                    }
                    else
                    {
                        cmd.Parameters.Add("@LocationMap", System.Data.SqlDbType.VarBinary).Value = DBNull.Value;
                    }
                    if (FileUpload12.HasFile && FileUpload12.PostedFile != null)
                    {

                        HttpPostedFile File = FileUpload12.PostedFile;
                        imgByte4 = new Byte[File.ContentLength];
                        File.InputStream.Read(imgByte4, 0, File.ContentLength);
                        cmd.Parameters.Add("@Others", SqlDbType.VarBinary).Value = imgByte4;

                    }
                    else
                    {
                        cmd.Parameters.Add("@Others", System.Data.SqlDbType.VarBinary).Value = DBNull.Value;
                    }


                    cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = Convert.ToInt32(empId);
                    con.Open();
                    cmd.ExecuteNonQuery();
                    cmd.Parameters.Clear();
                    Page.ClientScript.RegisterStartupScript(this.GetType(), "test", "alert('Image successfully saved!');", true);
                    // cmd.Parameters.Add("@TRNID", SqlDbType.Int).Value = CStatusTrnid.Value != "" ? Convert.ToInt32(CStatusTrnid.Value) : 0;
                    if ((String.IsNullOrEmpty(ImageTrnid.Value) ? 0 : Convert.ToInt32(ImageTrnid.Value)) == 0)
                    {
                        SqlCommand CustId = new SqlCommand("Select IDENT_CURRENT('TBLLandImage') AS TRNID", con);
                        SqlDataReader reader = CustId.ExecuteReader();
                        if (reader.HasRows)
                        {
                            while (reader.Read())
                            {
                                PropTrnid.Value = reader["TRNID"].ToString();
                            }
                        }
                        reader.Close();
                    }

                    con.Close();

                }
            }


            catch (SqlException ex)
            {
                Console.WriteLine("SQL Error" + ex.Message.ToString());
            }
        }
    

Answers (2)