How to get the Values from database and show it in a label in a new line

Question

0.00/5 (No votes)

See more:

Hi,

I am storing the values in database like

India<br/> Malaysia<br/>Singapore<br/>

When I getting the values from Database, I need to display the values in a label like this structure

India

Malaysia

Singapore

How to do this one any help can be useful for me

Posted 14-May-12 15:33pm

Member 7946563

Updated 14-May-12 16:52pm

walterhevedeich

v2

Add a Solution

Comments

walterhevedeich 14-May-12 22:52pm

Removed pre tag.

2 solutions

Solution 2

Hi,

Try this:

C#

string sentence = "India<br/> Malaysia<br/>Singapore<br/>";
            string words = sentence.Replace("<br/>", " ");
            string[] word = words.Split(' '); //Now we have the words in array.
            foreach (string wrd in word) {
                if (wrd != "")
                {
                    Console.WriteLine(wrd.Trim());
                }
            }

All the best.
-AK

Posted 14-May-12 17:50pm

AmitKumar89

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Mohammad A Rahman · Accepted Answer · 2012-05-14T16:15:00

following code might help you,

C#

namespace ConsoleApplication24
{
    using System;
    using System.Linq;
    using System.Text.RegularExpressions;

    class Program
    {
        static void Main(string[] args)
        {
            string pattern = "<br/>";
            string sentence = "India<br/> Malaysia<br/>Singapore<br/>";
            string[] countries = Regex.Split(sentence, pattern);
            string labelOutput =string.Empty;
            labelOutput = string.Join(Environment.NewLine, countries.SkipWhile(country => string.IsNullOrEmpty(country)).Select(country=>country.Trim()));
            Console.WriteLine(labelOutput);
        }
    }
}

The output of the above program is as below,

India
Malaysia
Singapore

Press any key to continue . . .

Please set the output to relevant label.

More information about,

Regex[^]
SkipWhile and Select[^]

Hope it helps :)