<%@ Page Language="C#" %>
<%@ Import Namespace="System.IO" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
void UploadImage(Object sender, EventArgs e)
{
String connectionString = "Enter your Connection String";
Stream imageStream = ImageFile.PostedFile.InputStream;
Byte[] byteData = new Byte[ImageFile.PostedFile.ContentLength];
SqlConnection objConn = new SqlConnection(connectionString);
SqlCommand objCommand = new SqlCommand("INSERT INTO sql_images(Image) VALUES(@image)", objConn);
SqlParameter objParam = new SqlParameter("@image", SqlDbType.Image);
imgStream.Read(imgdata, 0, ImageFile.PostedFile.ContentLength);
objParam.Value = imgdata;
objCommand.Parameters.Add(imgparam);
try
{
objConn.Open();
objCommand.ExecuteNonQuery();
}
catch (System.Exception exc)
{
ErrorLabel.Text = exc.ToString();
}
finally
{
objConn.Close();
imgStream.Close();
}
}