I'm trying to update/insert a record in SQL 2005 perserving all the formatting (like new lines ..etc) . I used datatype "varchar(MAX)" in the database . The update/insert works but for some reason the formatting of the text is ignored.I'm using databinding btw.