How to add paragraph in sql column

Question

How to add paragraph in sql column. Bind that data to listview. But in listview that data also show the paragraph Please give some suggestion urgently..............

Afzaal Ahmad Zeeshan · Answer

The first thing is, what do you actually mean by paragraph ? When you pass the data to the SQL Server (Pardon me if you're using any other data source; like MySQL, MS Access etc), it stores that data in nvarchar (or what so ever data type you've provided to that column) any new line entry is also preserved. So when ever you're going trying to enter the data to the SQL Server's column, it would store the data as it is and will return the data as it is. If you're not getting the data back, as it was sent to the SQL Server, you might try to check if there is any code that is removing the new line character (sometimes 
 and sometime 
). If this is ASP.NET, you might also want to try using Html.Raw() to convert the string data returned from the database to the HTML markup. If you're using any other framework (like WPF, or Win Forms) then you might want to use their specific codes like covert to Unicode etc.

How to add paragraph in sql column

Answers (1)