How to get comma seprated list enclosed with single quotes from a datatable C#

Question

0.00/5 (No votes)

See more:

Hi Friends,

I need to get a comma sperated list from a datatable column. This part i am able to complete. But my requirement is to enclose single quotes between each item.
For example 'ÁBC','DEF','GHI'
I need to get output like this. Can any one please modify my code to get the desired output. Currently i am returing array of string but i am happy if i can get as a string

C#

public static string[] GetCommaSperatedList(DataTable dt)
{
  string[] allitems = dt.AsEnumerable()
                         .SelectMany(r => r.Field<string>("IN_KEY_TMS").Split(','))
                         .ToArray();
  return allitems;
}

Thanks in advance

Posted 14-May-15 0:24am

jinesh sam

Add a Solution

2 solutions

Solution 1

Try this:

C#

public static string[] GetCommaSperatedList(DataTable dt)
{
  return String.Join(",", dt.AsEnumerable()
                         .SelectMany(r => r.Field<string>("IN_KEY_TMS").Split(',')).ToArray());
}

Posted 14-May-15 0:34am

Maciej Los

Updated 14-May-15 0:35am

v2

Comments

jinesh sam 14-May-15 6:48am

@Maciej Here you are not enclosing single qutoes. My requirement was that

CHill60 14-May-15 6:49am

Apologies for the overlap ... I really must learn to refresh the page before adding a solution :-O

Maciej Los 14-May-15 7:49am

No problem, Caroline ;)

jinesh sam 14-May-15 6:58am

No worries

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)

CHill60 · Accepted Answer · 2015-05-14T00:42:00

To return the contents surrounded by single quotes use ConvertAll e.g.

Array.ConvertAll(allitems, z => "'" + z + "'");

To combine them all into a single string (once surrounded by quotes) then use Join

return String.Join(",", Array.ConvertAll(allitems, z => "'" + z + "'"));

[EDIT in response to OP comment]
Just combine the two lines...cut&paste the bit that derives allitems over the use of "allitems" in the code I supplied i.e.

C#

public static string GetCommaSperatedList(DataTable dt)
{
  return String.Join(",",Array.ConvertAll(dt.AsEnumerable()
                         .SelectMany(r => r.Field<string>("IN_KEY_TMS").Split(',')).ToArray(), z => "'" + z + "'"));
}

Note I've changed the return type of the function from string[] to string.

Additionally NOTE!
If you are planning to use this string in a SQL query and if the datatable has been influenced/created from user input then you may be exposing your code to a risk of SQL Injection. If this is the case then also consider the Solution from Richard Deeming to this post Fetching specific values from a database using user input array. It works for single items but not for a list of itemids[^]