Our Training Programs

All contents are copyright of their authors.

multiline textbox

multiline textbox

ranjan sahoo

13yAsked Aug 24, 2013, 4:27 AM3.2kVisual Basic .NET

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

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

It is the same account you read, post and publish with — and you will come straight back to this page.

Iftikar Hussain13y ago
Hi,
While saving data from multiline textbox to database, it will save the next line data with \n or \r 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,'\r\n','
');

Regards,
Iftikar
Abhineet Srivastava13y ago
You need also check the column size in database.

Cheers!
Sanjeeb Lenka13y ago
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 sahoo13y ago
How can i show multiline data in gridview cell
Sanjeeb Lenka13y ago
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.