Use the command parameters to insert values. It should solve the problem...
On Wed, Jul 22, 2009 at 1:11 PM, Brandon Betances <[email protected]>wrote: > Whats the error? Im guessing your saving as a varchar or nvchar and not a > text column > > On Wed, Jul 22, 2009 at 1:02 AM, yashodabest v <[email protected]>wrote: > >> >> Hi............. >> >> I'm having a little bit problem in c# 2005 sql insert statement. >> Do u know how to send descriptions with single quotation without replacing >> it with double quotations. >> like "Perera & Son's Stores" >> Here Son's has a single quotation so it gives an error. >> >> Thanks in advance. >> >> Rgds, >> Yashoda >> > > -- WITH BEST REGARDS ================== ADARSH KUMAR :) mob:- +919096122978
