Special Character Insert int SQL Server

Ravi Kiran Chanduri,

 

Thanks for reply.

 

i am asking insert application. in backend . means

 

design asp.net

 

to create 3 textboxs

 

1st textbox = name

2nd textbox=email

3 rd textbox (multiline) = discription.

 

in backend

 

insert into table name values('"+textbox1.text+"','"+textbox2.text+"','"+textbox3.text+"').

 

how to insert special charecters in 3rd textbox ?

Hello Rupesh,

 

For your first Question ,

 

to insert  single quotation (') you have to use it 2 times. 

 

For example : we have to insert name Kevin o'brien for this , Query will be as follows

 

For your second question ,

 

You would like to call SQL from Angular Js ?

Well, it is not possible to call sql server from Angular js as it is a client side scripting language. To Achieve this, you have to use server side scripting like c# coding or You can use Node js too. 

 

To code Angular js with Sublime text editor , here is the link 

https://dzone.com/articles/input-typequottextquot-busted