Asp.Net with SQl Server

Question

How Can I store '(apstrophy)(S'Nagar Colony ) value which is in asp.net textbox into sql server 2008 r2 database?? Can u Plz Help me Guys Thanx in Advance....!!!!!!!!!!

Pankaj Pandey · Answer

before using the data of textbox to send into sql database use given code 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 Pabbathi · Answer

Hi PankajCan u plz give solution to my another problem which i have posted in csharpcorner in some days back below is the link which i have posted.. http://www.c-sharpcorner.com/Forums/Thread/206546/

Sathish Pabbathi · Answer

Thanx a lot PankajIt's Working Fine

Ravikumar G · Answer

Copy link and paste in browser i just checked its working..

Ravikumar G · Answer

Hi Please find the answer http://www.c-sharpcorner.com/Forums/Thread/62555/