How to convert datarow to string of array?

Question

I have a DataRow, I need convert it to a string of array! Everyone help me, please! Ex: MyDataRow include many column(Index type of int, Name type of string, Age type of int.... ) => to array array[0]: 1 array[1]: Henry array[2]: 23 ....

Welcome to Stack Overflow. This is not a good way to ask a question here. Did you try anything so far to solve your problem? Show your effort first so people might show theirs. Please read FAQ, How to Ask and help center as a start. — Nahuel Ianni
– Nahuel Ianni, Commented Sep 17, 2014 at 10:15

Vishwanath Mishra · Accepted Answer · 2014-09-17 10:38:38Z

3

DataRow itself has property ItemArray, you can use it. Try this code

StringBuilder sb=new StringBuilder();
foreach(DataRow dr in dt.Rows)
{
    object[] arr = dr.ItemArray;
    for (int i = 0; i < arr.Length; i++)
    {
         sb.Append(Convert.ToString(arr[i]));
         sb.Append("|");
    }
 }
Response.Write(sb.ToString());

answered Sep 17, 2014 at 10:38

Vishwanath Mishra

4455 silver badges20 bronze badges

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

Comments

Charitha Goonewardena · Accepted Answer · 2017-01-25 18:05:07Z

0

simply you can convert as follows.

var dt = new DataTable();
dt.Load(cmd.ExecuteReader());
var rows = dt.AsEnumerable().ToArray();
int num = 0;
string[] strarr = new string[rows.Length];
foreach (DataRow raw in rows)
{
    strarr[num] = raw.ItemArray[0].ToString(); 
    num++;
}

answered Jan 25, 2017 at 18:05

Charitha Goonewardena

4,7542 gold badges39 silver badges40 bronze badges

Comments

Mohsen · Accepted Answer · 2018-11-06 14:24:15Z

0

Easy with Linq:

dr.ItemArray.Select(c => c.ToString()).ToArray();

answered Nov 6, 2018 at 14:24

Mohsen

4,2551 gold badge34 silver badges33 bronze badges

Collectives™ on Stack Overflow

How to convert datarow to string of array?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related