load data table content into an array

Dinesh Santhalingam

I have a data table and i want to load my data table content into an array.how can i do this?help me....

datatable dt= new data table(); //I have two column in my data table Name and Marks

I want to load it into an array like {("A",20), ("B",30),("c",40)}

please suggest me some ideas ....

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Midhun Tp9y ago
Accepted answer
Hi,

Please try below code -

var tableEnumerable = dt.AsEnumerable();
Array tableArray = tableEnumerable.ToArray();
Dinesh Santhalingam9y ago
I want to append my array into lst(dictionary ).and return the dictionary .suggest some ideas
@ Midhun
Midhun Tp9y ago
Hi,

You can directly convert datatable to dictionary as below -

var tableEnumerable = dt.AsEnumerable();
var dictionary = tableEnumerable.ToDictionary(item => item);
Manas Mohapatra9y ago
If you want convert the DataTable to Dictionary then follow below code:
public Dictionary<string,object> GetDictionary(DataTable dt)
{
    return dt.AsEnumerable()
      .ToDictionarystring, object>(row => row.Field<string>(0),
                                row => row.Field<object>(1));
}
Prakash Kumar9y ago
try,
DataArray= table.Rows.Cast().Select(c => new[] { c[0], c[1] });
Dinesh Santhalingam9y ago
Thanks for your response.Now i want to load this array into dictionary .Is it possible? please help me.@ midhun
Dictionary<string, object> lst = new Dictionary<string, object>();
ali tuncer9y ago
Check out 2 dimensional arrays..
https://www.dotnetperls.com/2d