Any built in functions to convert Datacolumn to split strings in C#.net 2.0

Question

I have a datacolumn, which I would like to split e.g.

ALICE MEGAN JANET

split to: ALICE, MEGAN, JANET

I know I can do it with for loops but I'd like to know if there's any built-in functions in .Net Framework. Thanks.

EDIT: My question is not clear. Let me try to re-articulate:

I have a datacolumn i.e. one column of many rows of names in this context:

datarow[0]["name"] = ALICE
datarow[1]["name"] = MEGAN
datarow[2]["name"] = JANET

I'd like to know what's the most elegant way to split this column of names into a string of format: ALICE, MEGAN, JANET

What do I need it for: I will use this format in a where clause query.

I'm using .Net C# 2.0

score 3 · Answer 1 · answered Jul 07 '11 at 07:47

3

string[] parts = "ALICE MEGAN JANET".Split();

answered Jul 07 '11 at 07:47

Petar Ivanov

1

The solution that you've provided does not split the values in a datacolumn. Datacolumn - by definition is one column of many rows of names in this context: row[0]["name"] = ALICE, row[1]["name"] = MEGAN, row[1]["name"] = JANET. – hyperkittie Jul 18 '11 at 09:35

score 1 · Answer 2 · answered Jul 07 '11 at 07:48

1

Use the text.Split(new char[] {' '}) code to do this. This method is described at:

answered Jul 07 '11 at 07:48

platon

score 0 · Answer 3 · answered Jul 07 '11 at 07:52

0

Try This

string[] parts = "ALICE MEGAN JANET".Split(' ');

answered Jul 07 '11 at 07:52

SMK

score 0 · Answer 4 · answered Jul 09 '11 at 18:24

0

try this:

string[] results = dt.Rows[row_number]["col_name"].ToString().Split(' ');

"dt" is the DataTable object

answered Jul 09 '11 at 18:24

Ovais Khatri

4 Answers4