Asp.net And HTML Css And Web Development: How To Call Any Api From Sql (sql Sript)

Asp.net And HTML Css And Web Development: How To Call Any Api From Sql (sql Sript): How To Call Any Api From Sql (sql Sript) Declare @Object as Int; Declare @ResponseText as Varchar(8000); --Code Snippet Exec sp_...

How To Call Any Api From Sql (sql Sript)

How To Call Any Api From Sql (sql Sript)




Declare @Object as Int;
Declare @ResponseText as Varchar(8000);
--Code Snippet
Exec sp_OACreate 'MSXML2.XMLHTTP', @Object OUT;
Exec sp_OAMethod @Object, 'open', NULL, 'get',
'http://www.yoururl.com', --Your Web Service Url (invoked)
'false'
Exec sp_OAMethod @Object, 'send'
Exec sp_OAMethod @Object, 'resp

Asp.net And HTML Css And Web Development: How To Create Encryption and Description of url an...

Asp.net And HTML Css And Web Development: How To Create Encryption and Description of url an...: How To Create Encryption and Description of url and Data using angular 6 import { Injectable } from '@angular/core'; import...

How To Create Encryption and Description of url and Data using angular 6


How To Create Encryption and Description of url and Data using angular 6


import { Injectable } from '@angular/core';
import * as CryptoJS from 'crypto-js';

@Injectable({
    providedIn: 'root'
})

export class EncrDecrService {
    saltKeys: string = 'MyMD5';
    constructor() { }

    // The set method is use for encrypt the value.
    set(value) {
        const key = CryptoJS.enc.Utf8.parse(this.saltKeys);
        const iv = CryptoJS.enc.Utf8.parse(this.saltKeys);
        const encrypted = CryptoJS.AES.encrypt(CryptoJS.enc.Utf8.parse(value.toString()), key,
            {
                keySize: 128 / 8,
                iv: iv,
                mode: CryptoJS.mode.CBC,
                padding: CryptoJS.pad.Pkcs7
            });

        return encrypted.toString();
    }

    // The get method is use for decrypt the value.
    get(value) {
        const key = CryptoJS.enc.Utf8.parse(this.saltKeys);
        const iv = CryptoJS.enc.Utf8.parse(this.saltKeys);
        const decrypted = CryptoJS.AES.decrypt(value, key, {
            keySize: 128 / 8,
            iv: iv,
            mode: CryptoJS.mode.CBC,
            padding: CryptoJS.pad.Pkcs7
        });

        return decrypted.toString(CryptoJS.enc.Utf8);
    }
}

Asp.net And HTML Css And Web Development: How To Get IP Address And MAC Address Using c# , A...

Asp.net And HTML Css And Web Development: How To Get IP Address And MAC Address Using c# , A...: How To Get IP Address And MAC Address Using c# , Aps.net MVC public ActionResult Index() {     var IP = GetUser_IP();           ...

Featured Post

Asp.net And HTML Css And Web Development: How To Call Any Api From Sql (sql Sript)

Asp.net And HTML Css And Web Development: How To Call Any Api From Sql (sql Sript) : How To Call Any Api From Sql (sql Sript) Declare...

Popular Posts