How to Upload and Save Image in SQL Server as BLOB Data with Asp.Net

To upload and save an image in SQL Server as BLOB (Binary Large Object) data using ASP.NET, you can follow these steps:

1. Create a table in your SQL Server database to store the image data. The table should have a column of type varbinary(MAX) to hold the binary image data. You can also include additional columns to store other relevant information about the image, such as filename, description, etc.

2. Create an ASP.NET web form or MVC view with a file upload control to allow users to select the image file.

3. Handle the file upload in the server-side code (C#) of your ASP.NET application. Here's an example of how you can handle the file upload and save the image as BLOB data:

   using System;
   using System.Data.SqlClient;
   using System.IO;
   
   protected void UploadButton_Click(object sender, EventArgs e)
   {
       if (ImageFileUpload.HasFile)
       {
           // Get the file name and extension
           string fileName = ImageFileUpload.FileName;
           string fileExtension = Path.GetExtension(fileName);
   
           // Create a byte array to hold the image data
           byte[] imageData = new byte[ImageFileUpload.PostedFile.ContentLength];
   
           // Read the file data into the byte array
           using (Stream inputStream = ImageFileUpload.PostedFile.InputStream)
           {
               inputStream.Read(imageData, 0, imageData.Length);
           }
   
           // Save the image data to the database
           string connectionString = "your_connection_string_here";
           string insertQuery = "INSERT INTO Images (FileName, ImageData) VALUES (@FileName, @ImageData)";
   
           using (SqlConnection connection = new SqlConnection(connectionString))
           {
               SqlCommand command = new SqlCommand(insertQuery, connection);
               command.Parameters.AddWithValue("@FileName", fileName);
               command.Parameters.AddWithValue("@ImageData", imageData);
   
               connection.Open();
               command.ExecuteNonQuery();
           }
   
           // Display a success message or perform any other actions
           UploadStatusLabel.Text = "Image uploaded successfully!";
       }
       else
       {
           // Display an error message or perform any other actions
           UploadStatusLabel.Text = "Please select an image to upload.";
       }
   }
   

    

please review the sample code attached

how to save image in folder path

Please try  with below updated code. 

DataTable DtPhoto = new DataTable();
DtPhoto.Columns.Add("FilePath", typeof(string));
List