Introducation:

Explanation:

Our fisrt step is to create a Table in our MS SQL DataBase. We are going to create the Table using following SQL Script.

Our MS SQL Table:

CREATE TABLE [dbo].[Photos](
[PhotoID] [int] IDENTITY(1,1) NOT NULL,
[Caption] [nvarchar](50) NOT NULL,
[Photo] [image] NOT NULL,
CONSTRAINT [PK_Photos] PRIMARY KEY CLUSTERED
([PhotoID] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Retrieving an image from the hard disk and inserting it into SQL Server:

byte[] image;
string fileName = @"c:\yourImage.jpg";
// Open File and Read Into Byte Array
using (FileStream fs = new FileStream(fileName, FileMode.Open)) {
BinaryReader reader = new BinaryReader(fs);
image = reader.ReadBytes((int)fs.Length);
fs.Close();
}
using (SqlConnection conn = new
SqlConnection(ConfigurationManager.ConnectionStrings["Personal"].ConnectionString))
{
SqlCommand command = new
SqlCommand("INSERT INTO Photos (Caption,Photo) VALUES (@Caption,@Photo)");
command.Parameters.Add("@Caption", SqlDbType.NVarChar).Value = textbox1.Text;
command.Parameters.Add("@Photo", SqlDbType.Image).Value = image;
conn.Open();
command.EndExecuteNonQuery();
}

Retrieving an image from SQL Server:

// Get Database
Database db = DatabaseFactory.CreateDatabase();
// Create Example DbCommand
string selectSql = "SELECT Photo FROM Photos  WHERE PhotoID = 1";
DbCommand selectCommand = db.GetSqlStringCommand(selectSql);
// Execute Command
byte[] storedImage = (byte[])db.ExecuteScalar(selectCommand);
// Convert byte[] to Image
Image newImage;
using (MemoryStream stream = new MemoryStream(storedImage)) {
newImage = Image.FromStream(stream);
}
// Display to make sure code works
pictureBox1.Image = newImage;

Upload an Image using FileUpload Control

If you are loading the picture from a FileUpload Control in a web page, the code will be slightly different. Here is the same example of saving the image to SQL Server using a FileUpload Control :

//Use a TextBox (say textbox1) for the Image Caption
//FileUpload1 is our FileUpload Control
if (FileUpload1.HasFile && !string.IsNullOrEmpty(textbox1.Text))
{ BinaryReader reader = new BinaryReader(FileUpload1.PostedFile.InputStream);
byte[] image = reader.ReadBytes(FileUpload1.PostedFile.ContentLength);

using (SqlConnection conn = new
SqlConnection(ConfigurationManager.ConnectionStrings["Personal"].ConnectionString))
{
SqlCommand command=new SqlCommand("INSERT INTO Photos (Caption,Photo) VALUES (@Caption,@Photo)");
command.Parameters.Add("@Caption", SqlDbType.NVarChar).Value = textbox1.Text;
command.Parameters.Add("@Photo", SqlDbType.Image).Value = image;
conn.Open();
command.EndExecuteNonQuery();
}
}