0

I have a database which is saving "Address" in one cell (i.e. "123, Park Avenue, New York, USA")

I am wondering how I would display those on my front end in separate ASP Text Boxes as if they are stored separately?

So when displayed on the front end it would look like 

123
Park Avenue
New York 
USA

All in separated text boxes.

My query is pulling the one entry through to the front end but I dont know how to "Split" it?

Kara
  • 6,115
  • 16
  • 50
  • 57
Stephen Crothers
  • 3
  • 3
  • You should split that string by comma delimiter in order to get string array. After that you can bind each string individually to the desired textbox. – Darjan Bogdan Mar 11 '17 at 20:11
  • Have a look at this answer. http://stackoverflow.com/a/14951159/3270427 – McNets Mar 11 '17 at 21:12

0 Answers0