How to split and assign the values to that values

Question

0.00/5 (No votes)

See more:

Hi,

In my application I am taking the values from the database like 'd1234','d1234','d123', I want to split this values and I want to save the values like

'd1234',
'd1234',
'd1234',
'd1234',

Can any one help me to solve this issue. I want split the data And I want to make the data in the above given format

Thanks in Advance

Posted 10-May-12 20:58pm

Member 7946563

Updated 10-May-12 23:09pm

v2

Add a Solution

Comments

Sebastian T Xavier 11-May-12 3:05am

do you want to split the string or want to get the result data in this desired format?

Maciej Los 11-May-12 5:33am

You should be more specific... What kind of database: Access, SQL Server, other? Do you know how to read data from a database? What have you done so far?

2 solutions

Solution 1

what u want to do with the string from database now make it clear ....

Posted 10-May-12 21:13pm

dharan1990

Comments

Dhanamanikandan 11-May-12 3:22am

@Dharan.. Plz post your questions by click the 'Have a question or comment?' link.. Don't Post in Solution textarea.

Thanks

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)

Umer Aziz Malik · Accepted Answer · 2012-05-10T21:42:00

Solution 2

Hello there,

C#

string yourStringFromDB = "your,string,from,db";
//
// Split string on the base of ",". This will separate all the words.
//
string[] words = yourStringFromDB.Split( new Char[] { ',' }, StringSplitOptions.RemoveEmptyEntries );
foreach (string word in words)
{
    Console.WriteLine(word);
}

Hope this helps you out,

Regards,
Umer

Posted 10-May-12 21:42pm

Umer Aziz Malik

Updated 10-May-12 23:57pm

v6

Comments

Maciej Los 11-May-12 5:35am

Check out your example and correct it... ;)

Umer Aziz Malik 11-May-12 5:54am

ummm can you please point out the mistake?

Morgs Morgan 11-May-12 5:58am

I added the StringSplitOptions.RemoveEmptyEntries to help get read of empty entries as seen in the example poster has a , at the end which end-up printing an empty string

Umer Aziz Malik 11-May-12 5:59am

Good work :)