Single & double quotes problem in sql string.

See more:

C#

C#4.0

please see my problem, i have a form in asp.net C#, and inside the form, i have used Tiny-Mac Editor for customise content, my problem is that, whenever i press the button then i face this problem( single & double quotes problems).


INSERT INTO tblExplanation VALUES ("260915",'Peel and Stick Floral Wall Art','Transform your tot's bedroom into a bright, burgeoning meadow with this set of oh-so-colorful wall art. Each unique flower, bird, butterfly, and swirly sun is a colorful creation of multilayered vinyl brimming with life and energy. How best to arrange them is entirely up to you--and your 12.2" x 15.4"')

here i have single quote and double quote in same value which i want to insert in a column

eg a) 12.2" x 15.4"

b) Transform your tot's
please suggest best solution

thanks in advanced

braj kishor