How to insert big html markup with white spaces(i.e. line breaks) and single and double quotation marks to sql server :
To insert that big html markup to ms sql server, i tried to copy the markup and paste it to the sql server table cell first. It didnt work, it pasted only the part until the first line break. Then i tried to insert it as a parameter in t-sql query, but i couldnt add it as a parameter since the text was impossible to pass to a string variable in c#. Then i tried to directly put it in a query in sql server management studio, but this time the parameter had some quotation marks which had to be replaced. My working solution was this : i created a label and assigned the markup to its text property in design time. And i passed its text property as a parameter to the insert sql statement.