How to save uploaded Images into database Using Asp.Net/C#

Posted by on February 28, 2010 Leave a comment (0) Go to comments

Introduction:
In this article,i am going to demonstrate,how to save the uploded netImage into sql table.

Main:
Sometimes,we need to store the Image into database table column for easy access.The sql datatype
Image allows us to store the Images into sql table column.

See the below simple examble,

<asp:TextBox ID="txtFileUpload" Text ="UploadFile" runat="server" Width="75px">
</asp:TextBox>
<asp:FileUpload ID="UploadFile" runat="server"/>
</asp:Label>
<asp:Button ID="Upload" runat="server" 
            OnClick="Upload_Click" Text="Upload"/>

protected void Upload_Click(object sender, EventArgs e)
{
 string local_netImageName = UploadFile.PostedFile.FileName.ToString();
 if (UploadFile.PostedFile != null && 
     UploadFile.PostedFile.FileName != "")
  {
   byte[] local_netImageSize = new byte
                 [UploadFile.PostedFile.ContentLength];
  HttpPostedFile local_uploadednetImage = UploadFile.PostedFile;
  local_uploadednetImage.InputStream.Read
     (netImageSize, 0, (int)UploadFile.PostedFile.ContentLength);
 
 // Create SQL Connection 
  SqlConnection con = new SqlConnection();
  con.ConnectionString = ConfigurationManager.ConnectionStrings
                         ["ConnectionString"].ConnectionString;
 
 // Create SQL Command 
 
 SqlCommand cmd = new SqlCommand();
 cmd.CommandText = "INSERT INTO netImages(netImageName,netImage)" +
                   " VALUES (@netImageName,@netImage)";
 cmd.CommandType = CommandType.Text;
 cmd.Connection = con;
 
 SqlParameter netImageName = new SqlParameter
                     ("@netImageName", SqlDbType.VarChar, 50);
 netImageName.Value = local_netImageName.ToString();
 cmd.Parameters.Add(netImageName);
 
 SqlParameter UploadednetImage = new SqlParameter
               ("@netImage", SqlDbType.netImage, netImageSize.Length);
 UploadednetImage.Value = local_netImageSize;
 cmd.Parameters.Add(UploadednetImage);
 con.Open();
 int result = cmd.ExecuteNonQuery();
 con.Close(); 
 }
}