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/

please show how to connect to sql from typescripts

Answers (4)