Issue while saving string data from UI into database

Anjana Purohit

Hi,

I have an application using .NET, JQUERY and database as SQL. On UI user is copy pasting some data and is getting saved into database in following format with font details:

281112 Sabar raised

Openreach advise the A End exchange equipment is reserved for ONEA42543459 - Not Wholesale. As you have now assigned our circuit to this equipment can you advise on the ONEA / ETHA status on ONEA42543459

But I want this data to be stored into database as follows:

281112 Sabar raised

Openreach advise the A End exchange equipment is reserved for ONEA42543459 - Not Wholesale. As you have now assigned our circuit to this equipment can you advise on the ONEA / ETHA status on ONEA42543459

Please suggest.

Thanks in advance.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar7y ago
Please use richtextbox,

You can store data in binary format and read that data.

https://stackoverflow.com/questions/15983278/storing-data-of-rich-text-box-to-database-with-formatting
0
Tushar Dikshit7y ago
Assuming you have a webapp, I would suggest use jquery based rich text edotors, in place of asp.net text box or text area controls.
Also these editors will give you formatted data when you access .text like property of these.

Mostly these are free open source.
Thanks.
0