multiline textbox

Question

i have one textbox with property TextMode="MultiLine"on my aspx page(C#)

i entered data in that textbox & press enter to write next line

but while saving that multi line data in database it saves only single line data,

i want this data store in sql database in multi line format .

how it is possible ?plz

Iftikar Hussain · Answer

Hi While saving data from multiline textbox to database it will save the next line data with 
 or  character (which will be not visible to us). So while display same data in same format you just need to replace these character with SELECT REPLACE(yourcolumndata'
'' '); Regards Iftikar

Abhineet Srivastava · Answer

You need also check the column size in database. Cheers!

Sanjeeb Lenka · Answer

you can put item style width to grid cell. so it will so the text in next line when text width increase from cell width

ranjan sahoo · Answer

How can i show multiline data in gridview cell

Sanjeeb Lenka · Answer

hi In data base it will always show it in one line. you can't do it in database column. but you can do it in front end when retrieving the data and showing it in front end in the multiline textbox it will show it in multiline.