please show how to connect to sql from typescripts

Question

Kindly show me how to connect to SQL from typescripts. That is i want to add data from textbox in typescript to a SQL table.

Rijwan Ansari · Answer

check this example. https://www.c-sharpcorner.com/UploadFile/5089e0/how-to-connect-database-in-typescript/

Sachin Singh · Answer

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); } }

zainab fatima · Answer

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?

Muhammad Imran Ansari · Answer

Read the following article: https://www.c-sharpcorner.com/UploadFile/5089e0/how-to-connect-database-in-typescript/