Click here to Skip to main content
14,694,039 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi im a junior programmer, and been given a task to display data inside a table but im stuck on how to display the data across multiple columns, ive got 6 columns that the data needs to display in, when i run the query it retrieves all the data into the first column the values are separated by a "/" is there a way to split the values at the occurrence of the "/" to display the values in their separate columns?

any help will be appreciated greatly

Zoltán Zörgő 11-Jul-12 2:40am
How the query statement looks like?

Yes this is quite easy.
Just use the Split keyword.

string[] splitStart = startString.Split('/') will put all the text from the first column into an array.
thanks alot that "that split keyword" helped got them to show across multiple columns

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900