how to insert data from object collections such as List into a DataTable?

Question

Hi, how to insert data from object collections such as List into a DataTable?

RanjithKumar chiguruvada · Answer

Hi Ravi, using System.Collections.Generic; using System.Data; using System.Windows.Forms; namespace WindowsFormsApplication1 { public partial class Form1 : Form { /// /// Contains column names. /// List _names = new List (); /// /// Contains column data arrays. /// List _dataArray = new List (); public Form1() { InitializeComponent(); // Example column. _names.Add("Cat"); // Three numbers of cat data _dataArray.Add(new double[] { 1.0, 2.2, 3.4 }); // Another example column _names.Add("Dog"); // Add three numbers of dog data _dataArray.Add(new double[] { 3.3, 5.0, 7.0 }); // Render the DataGridView. dataGridView1.DataSource = GetResultsTable(); } /// /// This method builds a DataTable of the data. /// public DataTable GetResultsTable() { // Create the output table. DataTable d = new DataTable(); // Loop through all process names. for (int i = 0; i { // The current process name. string name = this._names[i]; // Add the program name to our columns. d.Columns.Add(name); // Add all of the memory numbers to an object list. List objectNumbers = new List (); // Put every column's numbers in this List. foreach (double number in this._dataArray[i]) { objectNumbers.Add((object)number); } // Keep adding rows until we have enough. while (d.Rows.Count { d.Rows.Add(); } // Add each item to the cells in the column. for (int a = 0; a { d.Rows[a][i] = objectNumbers[a]; } } return d; } } }

RanjithKumar chiguruvada · Answer

Thank you for accepting answer.

how to insert data from object collections such as List into a DataTable?

Answers (2)