Multiline textbox - SQL Database.

[pk.yadav]

Issue: On Read data show in single line instead of multiline

Explanation:

Currently i have a multiline textbox for address.

it has text like :

textbox1.text = "add1" & Environment.NewLine & "Add2" & Environment.NewLine & "Add3" & Environment.NewLine & "Add4"




everything so far works fine and i save data to SQL

SqlCmd.Parameters.AddWithValue("@FullAddress", t19.Text)




#Problem: My issue is when i read the same from SQL server :

While SDR.Read

t19.Text = SDR.GetString(0)

End While



my textbox1 don't show data in multiline instead show as textbox1.text = "Add1Add2Add3Add4"


Please guide and thanks in advance for help.




Pradeep Yadav (Social MSDN)

Continue reading...