Save (Insert) Image in Binary Format in database using ASP.Net Web Service

Hi paulrajmca,

Check this example. Now please take its reference and correct your code.

Database

I have made use of the following table tblFiles with the schema as follows.

Download SQL file

HTML

<asp:FileUpload ID="fuUpload" runat="server" />
<asp:Button Text="Save" runat="server" ID="btnSave" />
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript">
    $(function () {
        var reader = new FileReader();
        var fileName, type;
        $('[id*=fuUpload]').change(function () {
            var file = $(this)[0].files;
            if (typeof (FileReader) != "undefined") {
                fileName = file[0].name;
                type = file[0].type;
                reader.readAsDataURL(file[0]);
            } else {
                alert("This browser does not support HTML5 FileReader.");
            }
        });

        $("[id*=btnSave]").click(function () {
            var byteData = reader.result;
            byteData = byteData.split(';')[1].replace("base64,", "");
            var obj = {};
            obj.Data = byteData;
            obj.Name = fileName;
            obj.Type = type;
            $.ajax({
                type: "POST",
                url: "FileService.asmx/SaveFile",
                data: '{fileData : ' + JSON.stringify(obj) + ' }',
                contentType: "application/json; charset=utf-8",
                dataType: "json",
                success: function (r) {
                    if (r.d == 1) {
                        alert("File Uploaded successfully.");
                    }
                },
                error: function (r) {
                    alert(r.responseText);
                }
            });
        });
    });
</script>

WebService

C#

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Services;

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. 
[System.Web.Script.Services.ScriptService]
public class FileService : System.Web.Services.WebService
{
    [WebMethod]
    public int SaveFile(FileData fileData)
    {
        int i = 0;
        if (!string.IsNullOrEmpty(fileData.Name))
        {
            byte[] fileBytes = Convert.FromBase64String(fileData.Data);
            string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
            using (SqlConnection conn = new SqlConnection(constr))
            {
                string sql = "INSERT INTO tblFiles VALUES(@Name, @ContentType, @Data)";
                using (SqlCommand cmd = new SqlCommand(sql, conn))
                {
                    cmd.Parameters.AddWithValue("@Name", fileData.Name);
                    cmd.Parameters.AddWithValue("@ContentType", fileData.Type);
                    cmd.Parameters.AddWithValue("@Data", fileBytes);
                    conn.Open();
                    i = cmd.ExecuteNonQuery();
                    conn.Close();
                }
            }
        }

        return i;
    }

    public class FileData
    {
        public string Name { get; set; }
        public string Data { get; set; }
        public string Type { get; set; }
    }
}

VB.Net

Imports System.Configuration
Imports System.Data.SqlClient
Imports System.Web
Imports System.Web.Services
Imports System.Web.Services.Protocols

' To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
<System.Web.Script.Services.ScriptService()>
<WebService(Namespace:="http://tempuri.org/")>
<WebServiceBinding(ConformsTo:=WsiProfiles.BasicProfile1_1)>
<Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()>
Public Class FileService
    Inherits System.Web.Services.WebService

    <WebMethod>
    Public Function SaveFile(ByVal fileData As FileData) As Integer
        Dim i As Integer = 0
        If Not String.IsNullOrEmpty(fileData.Name) Then
            Dim fileBytes As Byte() = Convert.FromBase64String(fileData.Data)
            Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
            Using conn As SqlConnection = New SqlConnection(constr)
                Dim sql As String = "INSERT INTO tblFiles VALUES(@Name, @ContentType, @Data)"
                Using cmd As SqlCommand = New SqlCommand(sql, conn)
                    cmd.Parameters.AddWithValue("@Name", fileData.Name)
                    cmd.Parameters.AddWithValue("@ContentType", fileData.Type)
                    cmd.Parameters.AddWithValue("@Data", fileBytes)
                    conn.Open()
                    i = cmd.ExecuteNonQuery()
                    conn.Close()
                End Using
            End Using
        End If

        Return i
    End Function

    Public Class FileData
        Public Property Name As String
        Public Property Data As String
        Public Property Type As String
    End Class
End Class