load data table content into an array

Question

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 Name Marks A 20 B 30 C 40 I want to load it into an array like {('A',20), ('B',30),('c',40)} please suggest me some ideas ....

Midhun T P · Answer

Hi, Please try below code - var tableEnumerable = dt.AsEnumerable(); Array tableArray = tableEnumerable.ToArray();

Prakash Kumar · Answer

try, DataArray= table.Rows.Cast ().Select(c => new [] { c[0], c[1] });

Dinesh Santhalingam · Answer

I want to append my array into lst(dictionary ).and return the dictionary .suggest some ideas @ Midhun

Midhun T P · Answer

Hi, You can directly convert datatable to dictionary as below - var tableEnumerable = dt.AsEnumerable(); var dictionary = tableEnumerable.ToDictionary(item => item);

Manas Mohapatra · Answer

If you want convert the DataTable to Dictionary then follow below code: public Dictionary string , object > GetDictionary(DataTable dt) { return dt.AsEnumerable() .ToDictionary string , object >(row => row.Field string >(0), row => row.Field object >(1)); }

Dinesh Santhalingam · Answer

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 tuncer · Answer

Check out 2 dimensional arrays.. https://www.dotnetperls.com/2d

load data table content into an array

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (7)