VB.NET โปรแกรมแจ้งเตือนว่า OleDbException: Multiple-step OLE DB operation generated errors. ค่ะ

[AllowAnonymous]
[HttpPost]
[Route("SignIn")]
public IActionResult SignIn(JObject user) 
{
    //res = response, var <> dynamic
    //var resMessage = new { Id = 1, errorMessage = "" };
    dynamic resMessage = new { Id = 1, errorMessage = string.Empty };

    //if (string.IsNullOrEmpty((user.Value<string>("username") ?? null)))
    //{
    //    resMessage.errorMessage = "User Name Required";
    //}
    //else if (string.IsNullOrEmpty((user.Value<string>("password") ?? null)))
    //{
    //    //All when you needs.
    //}
    //All when you needs.
    //All when you needs.
    return Ok(resMessage);
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Reflection;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Builder;
using Microsoft.AspNetCore.Diagnostics;
using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Http.Features;
using Microsoft.AspNetCore.HttpsPolicy;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Hosting;

//nuget Microsoft.AspNetCore.Mvc.NewtonsoftJson // .NET Core 2.2 -> 3.1 ฝั่งเรียก Web MVC 3.1 -> ฝั่งรับ Web API 3.1 มีปัญหา
//หมายความว่าใช้ JObject ไม่ได้ อทิเช่น WEB API -> Method Post JObject param
//จำเป็นต้องใส่ในฝั่ง Frontend/Backend(MVC Web/ Web API)

namespace sexyERP.WebApp
{
    public class Startup
    {
        public Startup(IConfiguration configuration)
        {
            Configuration = configuration;
        }

        public IConfiguration Configuration { get; }
        // This method gets called by the runtime. Use this method to add services to the container.
        public void ConfigureServices(IServiceCollection services)
        {
            services.AddControllersWithViews()
                    .AddRazorRuntimeCompilation()
                    .AddNewtonsoftJson() //nuget Microsoft.AspNetCore.Mvc.Razor.RuntimeCompilation Fixed .cshtml/other change browser not refresh
                  //.AddApplicationPart(typeof(faceHe_APIServiceSexy.Startup).GetTypeInfo().Assembly); //face He Add before .NET Core 2.2 สำหรับ .NET Core 3.x ไม่จำเป็น
            ;
        }

        // This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
        public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
        {
            if (env.IsDevelopment())
            {
                app.UseDeveloperExceptionPage();
            }
            else
            {
                app.UseExceptionHandler("/Home/Error");
                // The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
                app.UseHsts();
            }

            //app.UseHttpsRedirection(); //face He Comment
            app.UseStaticFiles();

            app.UseRouting();

            //app.UseAuthorization(); //face He Comment

            app.UseEndpoints(endpoints =>
            {
                endpoints.MapControllerRoute(
                    name: "default",
                    pattern: "{controller=Home}/{action=Index}/{id?}");
            });
        }
    }
}

<script>
        $("#btnSignIn").on("click", function (e) {
            e.preventDefault();
            doAjax();
        });

         function doAjax() {
            let user = {
                username: "Dang",
                password: "Slowly As Fuck"
            }
            //try {
                $.ajax({
                    type: "POST",
                    url: "/api/Security/SignIn",
                    data: JSON.stringify(user), //Mapping JObject user
                    contentType: "application/json; charset=utf-8",
                    dataType: "json",
                    success: function (data) {
                        //console.log(data);
                    },
                    error: function (req, status, error) {
                        //TODO
                        alert(error);
                    }
                });
            //} catch (error) {
            //    console.error(error);
            //}
        }
    </script>

        [HttpGet]
        [Route("getMDivisionByJDT")]
        public IActionResult getMDivisionByJDT()
        {
            var db = SexyDatabase.GetCurrentDialect();
            var start = (string)HttpContext.Request.Query["start"] ?? "0"; //ตำแหน่งระเบียนปัจจุบัน
            var pageSize = (string)HttpContext.Request.Query["length"] ?? "10"; //จำนวนที่แสดงต่อหน้า
            var searchValue = (string)HttpContext.Request.Query["search[value]"] ?? ""; //คำค้นหา 

            var orderColumnIndex = (string)HttpContext.Request.Query["order[0][column]"] ?? "1"; //จัดเรียงที่ Column ถ้าไม่ระบุ = 1
            var orderColumnName = (string)HttpContext.Request.Query["columns[" + orderColumnIndex + "][name]"] ?? ""; //จัดเรียงชื่อคลัมภ์
            var orderDirection = (string)HttpContext.Request.Query["order[0][dir]"] ?? "asc"; //จัดเรียงแบบ asc/desc

            string query = "";
            var whereClause = ""; 

            if (orderColumnIndex.ToLower() == "id")
            {
                whereClause = "Id >=" + searchValue;
            } else
            {
                whereClause = "LIKE '%" + searchValue + "%'";
            }

            switch (db)
            {
                case SimpleCRUD.Dialect.SQLServer:
                    break;
                case SimpleCRUD.Dialect.PostgreSQL:
                    break;
                case SimpleCRUD.Dialect.SQLite:
                    break;
                case SimpleCRUD.Dialect.MySQL:
                      query = @$"-- START TRANSACTION;
                              SET @recordsTotal := (SELECT count(1) FROM wldb.mdivision); 
                              -- SELECT @recordsTotal := 0;
                              -- SELECT COUNT(*) INTO @recordsTotal FROM wldb.mdivision;
                              CREATE TEMPORARY TABLE IF NOT EXISTS temp_cs
                               AS (
                                   SELECT *
                                   FROM
                                   wldb.mdivision WHERE {orderColumnName} {whereClause} ORDER BY {orderColumnName} {orderDirection});
                               SET @recordsFiltered := (SELECT count(1) FROM temp_cs); 
                               SELECT *, @recordsTotal AS recordsTotal, @recordsFiltered AS recordsFiltered FROM temp_cs LIMIT {pageSize} OFFSET {start};
                               DROP TEMPORARY TABLE IF EXISTS temp_cs;
                               -- COMMIT;
                           ";
                    break;
                case SimpleCRUD.Dialect.Oracle:
                    break;
                case SimpleCRUD.Dialect.DB2:
                    break;
                case SimpleCRUD.Dialect.InfluxDB:
                    break;
                default:
                    break;
            }

            var lstMock = new[] { new { Id = 1, code = "", nameth = "", nameus = "", Remark = "" } }.Take(0).ToList();

            IEnumerable<dynamic> results1 = null;
            IEnumerable<IDictionary<string, dynamic>> results3;

            using (var cn = SexyDatabase.SexyConnection(forceOpen : true))
            {
               results1 = cn.Query<dynamic>(query);
               //results3 = cn.Query(query) as IEnumerable<IDictionary<string, dynamic>>;
               //results2 = cn.GetList<sexy_Database.Models.Settings.MDivision>();
            }

            int recordsTotal = 0;
            int recordsFiltered = 0;
            if (results1.Count() > 0)
            {
                recordsTotal = (int)(long)(results1.ElementAt(0) as IDictionary<string, object>)["recordsTotal"];
                var hum1 = results1.ElementAt(0) as IDictionary<string, object>;
                var hum2 = hum1.Count();
                recordsFiltered = (int)(long)(results1.ElementAt(0) as IDictionary<string, object>)["recordsFiltered"];
            }

            foreach (var row in results1)
            {
                var fields = row as IDictionary<string, object>; //row.Cast<IDictionary<string, object>>()
                lstMock.Add(new
                {
                    Id = (int)fields["Id"], //(int)fields["Id"]
                    code = (string)fields["Code"],
                    nameth = (string)fields["NameTH"],
                    nameus = (string)fields["NameUS"],
                    Remark = (string)fields["Remark"]
                });
            }
            return Ok(new { data = lstMock.ToList(), error = "", recordsTotal = recordsTotal, recordsFiltered = recordsFiltered }); 
        }

            var objDivision = new sexy_Database.Models.Settings.MDivision //ชื่อตารางในฐานข้อมูล
            {
                Id = gId,
                Code = gCode,
                NameTH = gNameTH,
                NameUS = gNameUS,
                Remark = gRemark
            };

            try
            {
                using (var cn = SexyDatabase.SexyConnection())
                {
                    cn.Open(); 
                    using (var trans = cn.BeginTransaction())
                    {
                        try
                        {
                            switch (gActFlag)
                            {
                                case "A":
                                    cn.Insert<sexy_Database.Models.Settings.MDivision>(objDivision, trans);
                                    break;
                                case "E":
                                    cn.Update<sexy_Database.Models.Settings.MDivision>(objDivision, trans);
                                    break;
                                case "D":
                                    cn.Delete<sexy_Database.Models.Settings.MDivision>(objDivision, trans);
                                    break;
                            }
                            trans.Commit();
                        }
                        catch (Exception ex2)
                        {
                            hasError = ex2.Message;
                            trans.Rollback();
                        }
                    }
                }
            }
            catch (Exception ex1)
            {
                hasError = ex1.Message;                
            }
            return Ok(hasError);
        }