Select image from db ms sql c#

Question

Need to select image from db

On my code result is System.Byte[]

I need to display picture

Some help?

Thank you

string memorandum = "";
using (SqlConnection openCon = new SqlConnection(con))
{
SqlDataReader reader;
SqlCommand cmd = new SqlCommand("SELECT memorandum from dbo.podaci_o_korisniku");
cmd.Connection = openCon;
openCon.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
byte[] ap = (byte[])podaci_o_korisnikuDataGridView.SelectedRows[0].Cells["memorandum"].Value;
memorandum = reader[0].ToString();
}
openCon.Close();
}

Rajeesh Menoth · Answer

Hi,   Try the following logic ( Answer by tga) : connection.Open();           SqlCommand command1 =  new  SqlCommand( "select imgfile from myimages where imgname=@param" , connection);           SqlParameter myparam = command1.Parameters.Add( "@param" , SqlDbType.NVarChar, 30);           myparam.Value = txtimgname.Text;            byte [] img = ( byte [])command1.ExecuteScalar();           MemoryStream str =  new  MemoryStream();           str.Write(img, 0, img.Length);           Bitmap bit =  new  Bitmap(str);           connection.Close();   Reference :   https://www.youtube.com/watch?v=Ie8lnubw8kk   https://stackoverflow.com/questions/2175209/retrieve-images-from-sql-server-database

Jenith Thakkar · Answer

Show me output and tell me what exactly do you want

Jenith Thakkar · Answer

if you are storing base64 in a database then no need to convert it in byte  string memorandum = ""; using (SqlConnection openCon = new SqlConnection(con)) { SqlDataReader reader; SqlCommand cmd = new SqlCommand("SELECT memorandum from dbo.podaci_o_korisniku"); cmd.Connection = openCon; openCon.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { memorandum = reader["memorandum"].ToString(); } openCon.Close(); }

Laxmidhar Sahoo · Answer

"C#"  Class= "ImgHandler"  %>      using  System;   using  System.Web;   using  System.Data.Sql;   using  System.Data.SqlClient;         public   class  ImgHandler : IHttpHandler   {               public   void  ProcessRequest (HttpContext context)       {            byte [] buffer =  null ;            string  querySqlStr =  "" ;            if  (context.Request.QueryString[ "ImageID" ] !=  null )           {               querySqlStr= "select * from testImageTable where ID=" +context.Request.QueryString[ "ImageID" ];           }            else            {               querySqlStr= "select * from testImageTable" ;           }           SqlConnection connection =  new  SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[ "TestDataBaseConnectionString" ].ToString());           SqlCommand command =  new  SqlCommand(querySqlStr, connection);           SqlDataReader reader =  null ;            try            {               connection.Open();               reader = command.ExecuteReader();                //get the extension name of image                 while  (reader.Read())               {                    string  name = reader[ "imageName" ].ToString();                    int  endIndex = name.LastIndexOf( '.' );                    string  extensionName = name.Remove(0, endIndex + 1);                   buffer = ( byte [])reader[ "imageContent" ];                   context.Response.Clear();                   context.Response.ContentType =  "image/"  + extensionName;                   context.Response.BinaryWrite(buffer);                   context.Response.Flush();                   context.Response.Close();               }               reader.Close();                          }            finally            {               connection.Close();           }       }            public   bool  IsReusable       {            get            {                return   false ;           }       }      }                     "C#"  AutoEventWireup= "true"  CodeFile= "Default.aspx.cs"  Inherits= "_Default"  %>      "-//W3C//DTD XHTML 1.0 Transitional//EN"   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" >      "http://www.w3.org/1999/xhtml" >   "server" >                      "form1"  runat= "server" >                       "ImgHandler.ashx?ImageID=1"  alt= ""  />            "ImgHandler.ashx?ImageID=2"  alt= ""  />            "ImgHandler.ashx?ImageID=3"  alt= ""  />            "ImgHandler.ashx?ImageID=4"  alt= ""  />

Jenith Thakkar · Answer

Hi Goran Bibic Still you facing that issue?

Jenith Thakkar · Answer

You can use base64 in this way
https://stackoverflow.com/questions/19389999/can-itextsharp-xmlworker-render-embedded-images

Goran Bibic · Answer

i need directly from db   This work directly from file   iTextSharp.text.Image logo = iTextSharp.text.Image.GetInstance( "C:\memorandum.jpg" );         logo.ScaleAbsolute(550, 110);   logo.SetAbsolutePosition(20, 710);   pdfDoc.Add(logo);
I have problem with this   string  memorandum =  "" ;   using  (SqlConnection openCon =  new  SqlConnection(con))   {   SqlDataReader reader;   SqlCommand cmd =  new  SqlCommand( "SELECT memorandum from dbo.podaci_o_korisniku" );   cmd.Connection = openCon;   openCon.Open();   reader = cmd.ExecuteReader();   while  (reader.Read())   {   memorandum = reader[ "memorandum" ].ToString();   }   openCon.Close();   }         string  folderPath =  "C:\PDFs\" ;     if  (!Directory.Exists(folderPath))   {   Directory.CreateDirectory(folderPath);   }   using  (FileStream stream =  new  FileStream(folderPath +  "Podaci o korisniku.pdf" , FileMode.Create))   {   iTextSharp.text.Font calibriTitle =  new  iTextSharp.text.Font(bfCalibri, 14);   iTextSharp.text.Font calibriSubTitle =  new  iTextSharp.text.Font(bfCalibri, 10);   Document pdfDoc =  new  Document(PageSize.A4, 10f, 10f, 10f, 0f);   PdfWriter.GetInstance(pdfDoc, stream);   pdfDoc.Open();   pdfDoc.Add( new  ListItem(memorandum));
}      }       }

Goran Bibic · Answer

Jenith Thakkar   Need to select image from db and show on pdf document itextsharp

Goran Bibic · Answer

Jenith Thakkar   Same result  after update code   System.Byte[]