อยากได้ตัวอย่าง code javascript ที่ใช้สำหรับ connect database "sql server"

< html >
 < SCRIPT LANGUAGE=javascript >
 < !--
 function ConDB()
 {
 var conn = new ActiveXObject("ADODB.Connection") ;
 var connectionstring="Provider=SQLOLEDB;Password=;User ID=;Initial Catalog=;Data Source=;"
 conn.Open(connectionstring);
 var rs = new ActiveXObject("ADODB.Recordset");
 rs.Open("SELECT * FROM YourTablename ", conn);
 
rs.MoveFirst
 while(!rs.eof)
 {
 document.write( yourtablefieldname);
 rs.movenext;
 }
 
rs.close;
 conn.close;
 } //–>
 < /SCRIPT >
 < body OnLoad=”javascript:ConDB()” >< /body >
 < /html >

#!javascript
var http = require('http');
var edge = require('edge');
var port = process.env.PORT || 8080;

var getTopUsers = edge.func('sql', function () {/*
    SELECT TOP 5 * FROM SampleUsers ORDER BY CreateDate DESC
*/});

function logError(err, res) {
    res.writeHead(200, { 'Content-Type': 'text/plain' });
    res.write("Error: " + err);
    res.end("");
}    

http.createServer(function (req, res) {
    res.writeHead(200, { 'Content-Type': 'text/html' });

    getTopUsers(null, function (error, result) {
        if (error) { logError(error, res); return; }
        if (result) {
            res.write("<ul>");
            result.forEach(function(user) {
                res.write("<li>" + user.FirstName + " " + user.LastName + ": " + user.Email + "</li>");
            });
            res.end("</ul>");
        }
        else {
        }
    });
}).listen(port);
console.log("Node server listening on port " + port);

<script type="text/javascript">
    var course_id = '0';
    var employees =  {!!json_encode($employees) !!};
    $(document).ready(function(){    
//event จะเกิดตอนที่เลือก
$("#course").change(function () {      
        var cntrol = $(this);        
        course_id = $('#course option:selected').val();  
        var description = cntrol.find(':selected').data('description');   
        var position = cntrol.find(':selected').data('position'); 
        var examination = cntrol.find(':selected').data('examination'); 
        var criterion = cntrol.find(':selected').data('criterion');
        var coursetype = cntrol.find(':selected').data('type'); 
        var frequencys = cntrol.find(':selected').data('frequencys'); 
        var dept = cntrol.find(':selected').data('dept');      
        
        document.getElementById("description").value =  description;    
        document.getElementById("examination").value =  examination;    
        document.getElementById("criterion").value =  criterion;    
        document.getElementById("coursetype").value =  coursetype;    
        document.getElementById("frequencys").value =  frequencys;    
        document.getElementById("department").value =  dept;    
        document.getElementById("ofdepartment").selectedIndex = -1;   

        findEmpByPositionId(position,course_id);      

    });  

   function findEmpByDepartmentId(id,course) {
        //รับค่ากับมาเป็น json เด้อ
        $.ajax({
            type: 'GET',
            url: "{{ url('/employees/department') }}/" + id +"/" +course,
            dataType: "json",
            success: function(data){
                //$('#btnDelete').show();
                //renderDetails(data);
                if(data.length > 0){                  
                   $.each( data, function( key, value ) {
                       //เขียนข้อมูลพนักงานที่ได้มาลง เทเบิล
                       drawRowTableParticipants(data[key]);                      
                   });
                }                
            }
        });
    }   

 function drawRowTableParticipants(rowData) {	
       
	    var row = $("<tr />")
	    $("#tbParticipants").append(row);
	    row.append($("<td style='display:none;'>" + rowData.id + "</td>"));
	    row.append($("<td> <div class='custom-control custom-checkbox'> " + 
                    "<input type='checkbox' class='custom-control-input' checked id='employees" + rowData.emp_num + "' name='employees[]' value ='"+rowData.id+"'>" + 
                    "<label class='custom-control-label' for='employees" + rowData.emp_num + "'>" + rowData.emp_num + "</label></td> " ));                  
	    row.append($("<td>" + rowData.name + "  " + rowData.surname + "</td>"));
        row.append($("<td>" + rowData.position + "</td>"));
        row.append($("<td>" + rowData.department + "</td>"));
        row.append($("<td>" + rowData.experience + "</td>"));
        row.append($("<td>" + isEmpty(rowData.lasttraining) + "</td>"));
	}   

});

function actToggle(act) {
    if (act == 'E') {
        if (!objHead.rows('.selected').any()) {
            $.SpermConfrim({
                title: 'ข้อความเตือน',
                content: 'กรุณาเลือกระเบียนในตารางด้านล่าง เพื่อทำการแก้ไขข้อมูล',
                draggable: true,
                dragWindowBorder: false,
            });
            return false;
        } else {
            var he = objHead.rows('.selected').data();
            if (he.length > 0) {
                var she = objHead.rows('.selected').indexes();
                console.log(he[0]);
                console.log(she);
                console.log(she[0]);
                console.log(objHead.rows(she).data());
                console.log(HeSheIt);
            }
        }
    }

    $('#divList').slideToggle();
    $('#divActions').slideToggle();

    if (act == 'A') {
        $('#lblActions').html('เพิ่มข้อมูล (Add new data)').data('act', 'A').data('xIndex', '-1');
        $('#txtDrugName').val('');
        $('#cboLocation_Group').val(null).trigger('change');
    } else if (act == 'E') {
        $('#lblActions').html('แก้ไขข้อมูล (Edit data)').data('act', 'E').data('xIndex', objHead.rows('.selected').indexes()[0]);
    } else {
        //back from add/edit
        $('#lblActions').html('').data('act', '').data('xIndex','-1');
    }
}

function initCBO() {
    $.ajax({
        type: "GET",
        url: "/api/extUtils/BasicSetting/Location/GetLocation_Group",
        data: {},//{email: $("#email").val()},
        success: function (data) {
            var he = $('#cboLocation_Group');
            he.empty();//.trigger("change");  //Clear all items.
            var options = he.get(0).options;
            $.each(data, function (index, value) {
                options[options.length] = new Option(value.text, value.id);
            });
            he.select2({ dropdownAutoWidth: true, width: 'auto', height: '100%' })
        },
        error: function (req, status, error) {
            //TODO
        }
    });
}

Imports System.Net
Imports System.Web.Http

Namespace Controllers.BasicSetting.Location
    Public Class LocationController : Inherits ApiController
        'ประเภทการจัดเก็บยาเสียสาว เสียแล้วเสียอีก
        <HttpGet>
        <Route("api/extUtils/BasicSetting/Location/GetLocation_Group")>
        Public Function GetLocation_Group() As IHttpActionResult
            Dim strSQL =
                     <Suparuck>
                          Select * FROM LOCATION_GROUP ORDER BY LOCATION_GROUP ASC                            
                     </Suparuck>
            Dim dt = sexDatabase.Query(strSQL.Value)
            Dim data = {New With {.id = "", .text = ""}}.Take(0).ToList()

            dt.AsEnumerable.ToList().ForEach(Sub(r)
                                                 data.Add(New With {.id = r.Item("LOCATION_GROUP").ToString().Trim(),
                                                                    .text = r.Item("LOCATION_GROUP").ToString() & " - " & r.Item("LOCATION_GROUP_NAME").ToString()})
                                             End Sub)
            Return Ok(data)
        End Function

namespace หำ_Server_CS.classUtils
{
    public class classหำBoard
    {
        //reuseable code.
        private static void jimSend(string msg)
        {
            var context = GlobalHost.ConnectionManager.GetConnectionContext<jimConnection>();
            context.Connection.Broadcast(msg);
        }

        /// <summary>
        /// เปิด Comport
        /// </summary>
        public static void OpenComPort() {
            jimSend("open");
        }

        /// <summary>
        /// Control Over pump and probe.
        /// </summary>
        public static void TurnOn()
        {
            jimSend("start");
        }
   }
}