How can I add arraylist items in Datatable?

Abhilash J A

10y982Visual Basic .NET

Hello Everyone,

How can I add arraylist items in Datatable? I can create a program but, it occured errors.

Kindly answer me with your explanation.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Web;
using System.Collections;
namespace ConsoleApplication14
{
class Program
{
static void Main(string[] args)
{
DataTable table1 = new DataTable();
table1.Columns.Add("M1");
table1.Columns.Add("M2");
table1.Columns.Add("M3");
DataRow row1 = table1.NewRow();
row1["M1"] = "100";
row1["M2"] = "120";
row1["M3"] = "322";
table1.Rows.Add(row1);
DataRow row2 = table1.NewRow();
row2["M1"] = "200";
row2["M2"] = "350";
row2["M3"] = "542";
table1.Rows.Add(row2);
DataRow row3 = table1.NewRow();
row3["M1"] = "300";
row3["M2"] = "120";
row3["M3"] = "544";
table1.Rows.Add(row3);
table1.Columns.Add("ID", typeof(int));
table1.Columns.Add("Name_student", typeof(String));
DataView view = new System.Data.DataView(table1);
DataTable selected = new DataTable();
selected = view.ToTable(true, "ID", "Name_student", "M1", "M2", "M3");
string Name_student = string.Empty;
int i = 0;
ArrayList arrlist = new ArrayList();
arrlist.Add("Mohammad");
arrlist.Add("Ali");
arrlist.Add("Fahe");
foreach (DataRow item in table1.Rows)
{
foreach (DataRow row in selected.Rows)
{
row["Name_student"] = arrlist[i];
i = i + 1;
for (int j = 0; j <= 3; j++)
{
row["ID"] = j;
}
}
}
var objselelcted = selected;
}
}
}

2 Replies

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

Pradeep Shet10y ago
Accepted answer
Hi Abilash,
I made some changes in your code. I hope this is what you wanted. Run the code & check it. It this answers your query, plz dont forget to mark this as answered.
class Program
{
static void Main(string[] args)
{
DataTable table1 = new DataTable();
table1.Columns.Add("M1");
table1.Columns.Add("M2");
table1.Columns.Add("M3");

DataRow row1 = table1.NewRow();
row1["M1"] = "100";
row1["M2"] = "120";
row1["M3"] = "322";
table1.Rows.Add(row1);
DataRow row2 = table1.NewRow();
row2["M1"] = "200";
row2["M2"] = "350";
row2["M3"] = "542";
table1.Rows.Add(row2);
DataRow row3 = table1.NewRow();
row3["M1"] = "300";
row3["M2"] = "120";
row3["M3"] = "544";
table1.Rows.Add(row3);
table1.Columns.Add("ID", typeof(int));
table1.Columns.Add("Name_student", typeof(String));
DataView view = new System.Data.DataView(table1);
DataTable selected = new DataTable();
selected = view.ToTable(true, "ID", "Name_student", "M1", "M2", "M3");
string Name_student = string.Empty;
int i = 0;
ArrayList arrlist = new ArrayList();
arrlist.Add("Mohammad");
arrlist.Add("Ali");
arrlist.Add("Fahe");
foreach (DataRow row in selected.Rows)
{
row["Name_student"] = arrlist[i];
i = i + 1;
row["ID"] = i;
}

var objselelcted = selected;
}
}
Tapan Patel10y ago
Please clarify the question you have or what do you want to do with this code.
Also, mention the error you are getting.
just wondering, what are you trying to achieve with below code.
foreach (DataRow item in table1.Rows)
{
foreach (DataRow row in selected.Rows)
{
row["Name_student"] = arrlist[i];
i = i + 1;
for (int j = 0; j <= 3; j++)
{
row["ID"] = j;
}
}
}