store and retrieve image to/from sql server database

Introduction

hi.I have a database for save large image and binary data. we use a simple method for save and retrieve image from sqlserver database.

Background

this article useful for every application programmer in related work.

we use this method in LG-iomind company

Using the code

At first we have two main storedprocedure for save and retrieve image

CREATE PROCEDURE sr_fetch_image(@ID int) AS
BEGIN
    SELECT    [Name], Exc, Image_Data
    FROM         [dbimage].[dbo].[tbl_Image]
    WHERE [ID]=@ID
END
GO

CREATE PROCEDURE [sr_insert_Image]
    (
     @Name     [nvarchar](50),
     @Exc     [nvarchar](50),
     @Image_Data     [image])

AS INSERT INTO [dbimage].[dbo].[tbl_Image] 
     (
     [Name],
     [Exc],
     [Image_Data]) 
 
VALUES 
    ( 
     @Name,
     @Exc,
     @Image_Data)
GO

and some code in C# for save and fetching

      // Save image in database
      OpenFileDialog odlg = new OpenFileDialog();
      odlg.ShowDialog();
      Cursor.Current = Cursors.WaitCursor;
      this.Refresh();
      Image bmp=Bitmap.FromFile(odlg.FileName);
      System.IO.MemoryStream ms=new System.IO.MemoryStream();
      bmp.Save(ms,System.Drawing.Imaging.ImageFormat.Bmp);
      sr_fetch_imageTableAdapter.Insert("df", "rer", ms.GetBuffer());
      Cursor.Current = Cursors.Default;
 

      // fetch data from database
      sr_fetch_imageTableAdapter.Fill(dSMoblie.sr_fetch_image, 3);
      System.IO.MemoryStream ms = new System.IO.MemoryStream();
      //bmp.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp);
      ms.Write(dSMoblie.sr_fetch_image[0].Image_Data, 0, dSMoblie.sr_fetch_image[0].Image_Data.Length);
      Image bmp = Bitmap.FromStream(ms);
      pictureBox1.Image = bmp;

note that sr_fetch_imageTabelAdapter is my table adapter that have to stored procedure for save and fetching