Value from datatable to String

Question

I got a value from table:

zs_code  zs_name
   a      James
   b      John
   c      Mikael

i want to convert the zs_name column to one string to be like below:

["James", "Mikael", "John"]

mean the string value is like above.

may anyone help me?

Damith · Accepted Answer · 2013-12-14 04:09:39Z

1

Dim items = String.Join(",", yourTable.AsEnumerable().[Select](Function(row) row.Field(Of String)("zs_name")))
Dim result = String.Format("[{0}]", items)

answered Dec 14, 2013 at 4:09

Damith

63.2k13 gold badges106 silver badges154 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hasan Fathi · Accepted Answer · 2015-07-12 20:51:34Z

0

Try like this:

string[] arr = new string[dt.Rows.Count];
for (int i = 0;i<dt.Rows.Count;i++)
{
 arr[i] = dt.Rows[i]["zs_name"].ToString();
}

Source : this link

Happy coding!!!

edited Jul 12, 2015 at 20:51

Hasan Fathi

6,1864 gold badges49 silver badges67 bronze badges

answered Dec 14, 2013 at 4:09

Vignesh Kumar A

28.6k14 gold badges67 silver badges119 bronze badges

Collectives™ on Stack Overflow

Value from datatable to String

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related