How to use array with delimiters?

Question

2.00/5 (1 vote)

See more:

I want to use array to get the contacts' email so that I can send out the email as mass amount.
& I need to also use delimiters to separate each of the emails with a semi-colon ;
after that i need to use join them back again as a string to store it into a textbox.
I have no idea how the codes look like.

Is there any tutorials or steps to follow so that I can learn how to use array and delimiters?

I am new to codings, so urgent help is needed. Thanks

Posted 7-Jun-12 7:26am

Fiona Tan

Add a Solution

2 solutions

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)

VJ Reddy · Accepted Answer · 2012-06-07T07:41:00

Solution 1

As I understand from the question, it is required to store the emailIds in an array and then it is required to build a string with those emailIds using ; as delimiter. If it is so, then the following code can be used.

C#

string[] emailIds = new string[] {"id1@abc.com", "id2@def.com", "name1@xyz.org"};
string emailIdsString = string.Join("; ", emailIds);
Console.WriteLine (emailIdsString);

//id1@abc.com; id2@def.com; name1@xyz.org

Posted 7-Jun-12 7:41am

VJ Reddy

Comments

Maciej Los 7-Jun-12 13:44pm

+5!

VJ Reddy 7-Jun-12 13:47pm

Thank you, losmac :)

Fiona Tan 7-Jun-12 13:49pm

It is not emailIds.
As i will be using SQL statements to select the "email" column from Customers table.

Which apparently my SQL statement being inserted to the button to call it also gives me an error.

Here is my SQL select statement :

SELECT Email
FROM Customer
WHERE newsletterAgree = "True"

Maciej Los 7-Jun-12 14:56pm

SELECT Email FROM Customer WHERE newsletterAgree = 'True'
Use a ' instead of "
See my answer, to your comment.

codeBegin 8-Jun-12 2:18am

good one 5!

VJ Reddy 8-Jun-12 2:58am

Thank you, codeBegin :)

Manas Bhardwaj 8-Jun-12 5:21am

nice +5!

VJ Reddy 8-Jun-12 6:00am

Thank you, Manas :)

Maciej Los · Accepted Answer · 2012-06-07T09:02:00

Solution 2

SQL Server does not know BOOLEAN data type. See availible DataTypes[^] for MS SQL Server. BOOLEAN is a text!
So... If you would like to get emails where newsletterAgree is set to "TRUE", use this query:

SQL

SELECT Email
FROM Customer
WHERE newsletterAgree = 'True'

I recomend you to change the data type for newsletterAgree field for int, where
0 = False
and
-1 = TRUE

Posted 7-Jun-12 9:02am

Maciej Los

Comments

Sandeep Mewara 7-Jun-12 16:21pm

5!

Maciej Los 7-Jun-12 16:27pm

Thank you, Sandeep ;)

VJ Reddy 7-Jun-12 20:20pm

Good answer and suggestion. 5!

Maciej Los 8-Jun-12 6:50am

Thank you, VJ ;)

codeBegin 8-Jun-12 2:18am

good one 5!

Maciej Los 8-Jun-12 6:50am

Thank you, codeBegin;)