Inserting & Retrieving Images from SQL Server Database without using Stored Procedures

Sign in to leave a comment.

• GD

  G Dragon5y agoPosted Apr 24, 2021, 4:52 PM

  What is datatype in sql server?
• ZM

  Zikriya Muneer7y agoPosted Jul 8, 2019, 12:26 AM

  Any one can help me
• ZM

  Zikriya Muneer7y agoPosted Jul 8, 2019, 12:26 AM

  This is not download how can i do
• VH

  Vora Himansu7y agoPosted Jan 29, 2019, 11:38 AM

  Declare variable photo error please solve
• IB

  Indrajeet Bhattacharya8y agoPosted Dec 30, 2017, 12:50 PM

  The zip file is not downloading. Please suggest.
• 

  Bunty Jain9y agoPosted Jul 12, 2017, 12:19 AM

  Thanks.very good article.
• PK

  Pradeep Kumar9y agoPosted Jun 23, 2017, 5:54 PM

  I get error in below code: pictureStudent.Image = null; if (reader["image"] != System.DBNull.Value) { byte[] photo_array = (byte[])reader["image"]; MemoryStream ms2 = new MemoryStream(photo_array); pictureStudent.Image = Image.FromStream(ms2); Error: Parameter is not valid. at System.Drawing.FromStream(Stream,Stream, Boolean useEmbeddedCouorManagement, Boolean validateImageData)
• JG

  john.grimanis Grimanis10y agoPosted Oct 21, 2016, 6:07 AM

  Good example, thanks
• KS

  kumar s12y agoPosted Sep 23, 2014, 1:23 PM

  ms.Position = 0; this statement made my code to work....thank you buddy...keep it up
• KS

  kumar s12y agoPosted Sep 23, 2014, 1:22 PM

  ms.Position = 0;
• 

  Prashanth Chindam12y agoPosted Jan 29, 2014, 7:23 AM

  Instead of saving image in binary format, save the image physically in a folder and save the image path in database with data type as nvarchar. use image url eg: http://abc.com/images/sampleimage.jpg, to display image in email content.
• FV

  Filipe Vilhena12y agoPosted Jan 29, 2014, 6:54 AM

  hello, I have a similar situation to what you describe here, although I need to get the image cid when getting it from database (or stream) in order to insert it in my email body, replacing the current LinkedResource which doesn't display anything. Can you help?
• 

  Santosh Yadav12y agoPosted Jan 29, 2014, 1:09 AM

  good article indeed, thanks..
• AK

  ashok kumar14y agoPosted Jan 23, 2012, 6:32 AM

  I have table like this.. SLNO UNITNO PHOTOBARCODE -------------------------------------- 1 C45678 <NULL> 2 C89678 <NULL> 3 C47878 <NULL> 4 D65678 <NULL> .... .... 1000 H45678 <NULL> I WANT TO GENERATE BARCODE FOR THE UNITNO AND WANT TO STORE THE BARCODE IMAGE IN DATABASE USING FORLOOP... PLEASE HELP ME... WHILE I USED U'R CODE...ITS SHOWS AN ERROR MESSAGE AS...."MUST DECLARE SCALAR VARIABLE @PHOTO"
• SJ

  sunil jadhav15y agoPosted Nov 18, 2011, 1:49 AM

  sir i am doing one project in vb 6.0 so please can you give me that same code for vb 6.0 instead of vb.net
  • AK

    ashok kumar14y agoPosted Jan 23, 2012, 6:28 AM

    Hi, I have table like this.. SLNO UNITNO PHOTOBARCODE -------------------------------------- 1 C45678 <NULL> 2 C89678 <NULL> 3 C47878 <NULL> 4 D65678 <NULL> .... .... 1000 H45678 <NULL> I WANT TO GENERATE BARCODE FOR THE UNITNO AND WANT TO STORE THE BARCODE IMAGE IN DATABASE USING FORLOOP... PLEASE HELP ME... WHILE I USED U'R CODE...ITS SHOWS AN ERROR MESSAGE AS...."MUST DECLARE SCALAR VARIABLE @PHOTO" PLEASE HELP ME...
• A

  Amol15y agoPosted Oct 30, 2011, 3:38 AM

  GR8 WORK!!!
• VM

  Venkatesh MR15y agoPosted Apr 6, 2011, 3:03 AM

  Nice example
  • 

    Prashanth Chindam15y agoPosted Apr 7, 2011, 12:20 AM

    Thanks
• TA

  Techni All15y agoPosted Apr 5, 2011, 12:59 AM

  Hi I ve uploaded my image binary from VC++6 to SQL server. On the web end, I am using C# commands to display these image but its not working. A possible problem may be: I am uploading the image in binary format but SQL DATAtype is IMAGE. C# is using showimage(). Your help will be highly appreciated.
• KR

  Ketul Rathod15y agoeditedPosted Feb 2, 2011, 10:58 PMEdited Feb 2, 2011, 11:17 PM

  Does it work with Sql Express Edition or we have to install SQL server 2005 Externally..... reply immediately....
  • 

    hilda r15y agoeditedPosted Feb 22, 2011, 11:47 PMEdited Feb 22, 2011, 11:49 PM

    thank you for your professinal code,this code is thing i really need it,but I have a request:I have a dataGridView in my form and all info show in it,when I explore rows of datagridview the info apeare in textBox and picture must show in pictureBox too,how I do that?please help me. thank you so much
  • 

    Prashanth Chindam15y agoPosted Feb 3, 2011, 12:59 AM

    yes it will work
• KK

  kishore kumar15y agoPosted Jan 18, 2011, 9:12 PM

  hi,im kishore im saving image successfully,but while retreiving gettingerror as parameter is not valid, is there any mistake in my code? here is my code...pls help me... thank u in adv... using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Drawing.Imaging ; using System.Linq; using System.Text; using System.Windows.Forms; using System.IO; using System.Data.SqlClient; namespace WindowsFormsApplication1 { public partial class Form1 : Form { SqlConnection con = new SqlConnection("user id=sa;password=kiran;database=kiran"); MemoryStream ms; public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { openFileDialog1.ShowDialog(); pictureBox1.ImageLocation = openFileDialog1.FileName; } private void button2_Click(object sender, EventArgs e) { SqlDataAdapter da = new SqlDataAdapter("insert into img values(" + textBox1.Text + ",'" + pictureBox1.ImageLocation + "')", con); DataSet ds = new DataSet(); da.Fill(ds, "img"); ms = new MemoryStream(); pictureBox1.Image.Save(ms, ImageFormat.Jpeg); byte[] data = new byte[ms.Length]; ms.Position = 0; ms.Read(data, 0, Convert.ToInt32(ms.Length)); MessageBox.Show("Saved"); } private void button3_Click(object sender, EventArgs e) { // SqlDataAdapter da = new SqlDataAdapter("select * from img where id=" + textBox1.Text, con); SqlCommand cmd = new SqlCommand("img_ret", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", textBox1.Text); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds, "img"); byte[] data = (byte[])ds.Tables["img"].Rows[0][0]; ms = new MemoryStream(data); pictureBox1.Image= Image.FromStream(ms); } } }
  • 

    Prashanth Chindam15y agoPosted Jan 22, 2011, 8:57 PM

    In think this might solve ur problem: byte[] data = (byte[])ds.Tables["img"].Rows[0][0]; Replace above statement with the following in buttton3_click byte[] data = (byte[])ds.Tables["img"].Rows[0][1];
• JS

  jagadeesh seelam15y agoPosted Jan 3, 2011, 12:18 PM

  nice..,.
  • 

    Prashanth Chindam15y agoPosted Jan 3, 2011, 10:59 PM

    Thanks
• MN

  mahesh nani16y agoPosted Nov 1, 2010, 4:26 AM

  thanks..........
  • 

    Prashanth Chindam16y agoPosted Nov 1, 2010, 10:30 AM

    Thanks for Ur Feedback ~Urs Prashanth.Chindam