c# - how to save chat transcripts in sql server database and retrieve it on another page with formatting? -

i working on chat application in used multiline textbox show messages. first of want give different colors in chat. our user message should in different color , user message should in different color. second thing want want save transcripts of chat conversation formatting user can see anytime. don't know how save transcript database formatting. stucked here. using c# , sql server database. how can that?

if break down problem, make easier solve it.

1. instead of taking text textbox. have thought maybe storing xml?
2. if use xml, can use xslt generate nice looking html (but depends on how want use later)
3. you have different options how store in database
   • plain text
   • xml
   • blob

please research , ask specific questions if stuck.