Retaining Bold, Underline Format.

[Sunil Yadala]

I’m saving bold and underline formatted text from the INFOPATH to SQL SERVER
through XML WEBSERVICE.

The saved text is retrieved and populated in a webpage.

The issue is I’m not able to retain the format i.e., bold, underline.

Data Type used in SQL SERVER is String.

 

[Scott L. Heim [MSFT]]

Hi Sunil,

This is simply the way a database (SQL or Access) functions - standard
"text" fields (varChar in SQL, Text in Access) only store data - not
formatting. As such, when you submit the data from InfoPath to SQL Server,
most likely the database only contains the data.

I am assuming you are using a Rich Text control in InfoPath and the only
way this may be possible is to actually store the underlying XML string for
the Rich Text control. However, this is just a thought off the top of my
head - maybe someone else has implemented a solution like this.

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Sunil Yadala]

Hi Scott,

Yes you are right, i am using rich text control in the Infopath.

Even I am working on accessing XML String in the Infopath

--
Thanks & Regards

Sunil Yadala.

P.S: If any one finds the Solution, please update me.