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

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 < this._dataArray.Count; 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

2 Replies

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

RanjithKumar chiguruvada14y ago
Accepted 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 < this._dataArray.Count; 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