Node.js MSSQL CRUD Tutorial
Read Data from MSSQl DB using NodeJS
var webconfig = {
user: 'login',
password: 'sa@123',
server: 'localhost',
database: 'TestDB',
options: {
encrypt: false // Use this if you're on Windows Azure
}
}
var express = require('express');
var sql = require('mssql');
var http = require('http');
var app = express();
var port = process.env.PORT || 8000;
var connection = new sql.Connection(webconfig, function(err) {
var request = new sql.Request(connection);
request.query('select * from Employees', function(err, recordset) {
if(err) // ... error checks
console.log('Database connection error');
console.dir("User Data: "+recordset);
});
});
app.listen(port);
console.log(port+' is the magic port');
Create(Insert) Data into MSSQL DB from NodeJS
request.query("insert into Employee
(EmpId,EmpName,EmpGender) values ('400','Raman','Male')").then(function(res) {
console.dir("User Data: "+res);
}).catch(function(err){
console.log('Database connection error' +err);
});
});
}).catch(function(err){
console.log('Database connection error' +err);
});
});
Update Record from NodeJS
console.dir("User Data: "+res);
}).catch(function(err){
console.log('Database connection error' +err);
});
}).catch(function(err){
console.log('Database connection error' +err);
});
No comments:
Post a Comment