Split SQL Column to Multiple Rows in HTML Table in C#

Question

Lets say my datatable retrieves column with value "SAGAR - SAGAR"

DataTable dtOutput;
dtOutput = Generix.getATMDetails(sATM);//Retrieves data

I can convert my datatable to HTML Table for display in HTML Page. How can i convert one of its Column into multi line format while displaying it in HTML Page

E.g: dtOutput (data)

Comments (Column Header)
SAGAR - SAGAR - SAGAR

now while displaying it in HTML page it should be like this

SAGAR
SAGAR
SAGAR

Are you using ASP.NET? It's also not clear what you're trying to do. What have you tried? — Tim Schmelter
– Tim Schmelter, Commented Dec 3, 2012 at 14:16
Heads up - I removed the SQL tag, since your code is strictly C#. Consider changing title. — Nick Vaccaro
– Nick Vaccaro, Commented Dec 3, 2012 at 14:18
Convert it to an array of strings by calling String.Split() and manipulating from there? Use String.replace to replace " - " with html BR tags? What have you tried so far? — David
– David, Commented Dec 3, 2012 at 14:18

Indi · Accepted Answer · 2012-12-03 14:25:08Z

1

You can get a new line by adding </ br>. There are several ways to do this.

from the select query using REPLACE(comments, ' - ' , '</ br>') (if you are in sql server)
within the datatable

during the data binding as follows

<%# Eval("comments").ToString().Replace(" - ","</ br>") %>

answered Dec 3, 2012 at 14:25

Indi

33.9k7 gold badges61 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Split SQL Column to Multiple Rows in HTML Table in C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related