Extract Name and last name from Database with JavaScript code

Question

Hello I have connected my database to Visual studio code but Can somebody give an idea how to code in JavaScript to call a mssql database to extract Name and last name if account number exists? I mean I know in VB you do something like:(This is just an example) But I do not how to in JavaScript. con.Open() cmd = New SqlCommand(Select * from dbo.ei_employee where code = ' & user_name.Text & 'and password = ' & password.Text & '  con) sdr = cmd.ExecuteReader() 'view = select * from dbo.ei_employee where code = ' & user_name.Text & ' 'Dim ds As DataSet = GetData(view) 'If (ds.Tables.Count > 0) Then ' eid = sdr.GetValue(2) If (sdr.Read()) Then Session(user_name) = enam as string End If Thank you

Jayraj Chhaya · Answer

To extract data from an MSSQL database using JavaScript you can utilize the mssql package which allows you to connect and query SQL Server databases. Below is a simple example demonstrating how to retrieve the first name and last name based on an account number. First ensure you have the mssql package installed: npm install mssql Then you can use the following code snippet: const sql = require('mssql'); async function getUserDetails(accountNumber) { try { const config = { user: 'your_username' password: 'your_password' server: 'your_server' database: 'your_database' options: { encrypt: true // Use this if you're on Azure } }; // Connect to the database await sql.connect(config); // Query the database const result = await sql.query`SELECT firstName lastName FROM dbo.ei_employee WHERE accountNumber = ${accountNumber}`; if (result.recordset.length > 0) { const { firstName lastName } = result.recordset[0]; console.log(`Name: ${firstName} ${lastName}`); } else { console.log('No user found with the provided account number.'); } } catch (err) { console.error('SQL error' err); } finally { await sql.close(); } } // Example usage getUserDetails('12345'); Replace your_username  your_password  your_server  and your_database with your actual database credentials. The function getUserDetails takes an account number as an argument and retrieves the corresponding first and last names from the ei_employee table.

Jignesh Kumar · Answer