please show how to connect to sql from typescripts

another approch is

var sql = require('mssql');
var config = {
server: 'localhost',
database: 'YourDatabaseName',
user: 'SqlUserName',
password: '*******',
port: '1433'
};
export async function AddItem(someValue1: string, someValue2: string) {
let db;
try {
db = await new sql.ConnectionPool(config).connect();
}
catch(err) {
console.error("Connection failed: " + err);
throw(err);
}
try {
console.info("Connected")
const insertStatement = 'INSERT INTO [dbo].[yourTable]([SomeValue1],[SomeValue2])VALUES(@SomeValue1, @SomeValue2)';
const ps = new sql.PreparedStatement(db);
ps.input('SomeValue1', sql.String)
ps.input('SomeValue2', sql.String)
await ps.prepare(insertStatement);
await ps.execute({
SomeValue1: someValue1,
SomeValue2: someValue2
});
await ps.unprepare();
} catch (e) {
console.error(e);
throw(e);
}
}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rijwan Ansari4y ago
check this example.

https://www.c-sharpcorner.com/UploadFile/5089e0/how-to-connect-database-in-typescript/
+2
zainab fatima4y ago
Thanks Sachin,

can you please guide me as to what is somevalue1 and somevalue2 and that too used in 2 places in the scriot that you sent?
+2
Sachin Singh4y ago
another approch is
var sql = require('mssql');
var config = {
    server: 'localhost',
    database: 'YourDatabaseName',
    user: 'SqlUserName',
    password: '*******',
    port: '1433'
};

export async function AddItem(someValue1: string, someValue2: string) {
    let db;
    try {
      db = await new sql.ConnectionPool(config).connect();
    }
    catch(err) {
      console.error("Connection failed: " + err);
      throw(err);
    }
    try {
      console.info("Connected")
      const insertStatement = 'INSERT INTO [dbo].[yourTable]([SomeValue1],[SomeValue2])VALUES(@SomeValue1, @SomeValue2)';
      const ps = new sql.PreparedStatement(db);
      ps.input('SomeValue1', sql.String)
      ps.input('SomeValue2', sql.String)
      await ps.prepare(insertStatement);
      await ps.execute({
            SomeValue1: someValue1,
            SomeValue2: someValue2
        });
      await ps.unprepare();
    } catch (e) {
        console.error(e);
        throw(e);
    }
}
+3
Muhammad Imran Ansari4y ago
Read the following article:
https://www.c-sharpcorner.com/UploadFile/5089e0/how-to-connect-database-in-typescript/
+2