Can u Plz Help me Guys,,
Thanx in Advance....!!!!!!!!!!
Asp.Net with SQl Server
How Can I store '(apstrophy)(S'Nagar Colony ) value which is in asp.net textbox into sql server 2008 r2 database??
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pankaj PandeyPosted Apr 29, 2013, 10:13 AM
TextBox1.Text.Replace("'", "''");
replace (') by ('') double apstrophy note-- not inverted comma(")
in sql server when we want to store a apstrophy we always use double apstrophy('') which automatically convert it into single apstrophy.
Sathish PabbathiPosted Apr 29, 2013, 10:45 AM
below is the link which i have posted..
http://www.c-sharpcorner.com/Forums/Thread/206546/
Sathish PabbathiPosted Apr 29, 2013, 10:27 AM
Ravikumar GPosted Apr 29, 2013, 8:12 AM
Ravikumar GPosted Apr 29, 2013, 7:55 AM
Please find the answer
http://www.c-sharpcorner.com/Forums/Thread/62555/