An error occur while adding data to datatable using loop

Ravikiran Suravarapu

While we add the data to datatable using foreach loop it will get an exception i.e., "input array is longer than the number of columns in this table".

Example:-

DataTable dt = new DataTable();

public void GetData()

{

List emplist = db.Employees.ToList();

foreach(var emp in emplist)

{

dt.Row.Add(emp.Name,emp.Address,emp.City); //Input array is longer than the...

}

dataGridView.DataSource=dt;

}

public void Form_Load(object sender,EventArgs e)

{

dt.Columns.Add("Name",typeof(string));

dt.Columns.Add("Address",typeof(string));

dt.Solumns.Add("City",typeof(string));

}

4 Replies

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

Jaish Mathews7y ago
Accepted answer
1st of all please give a code which is compiling. The code you pasted here will throw error in any IDE and not even need of debug to find the error.

e.g. dt.Solumns.Add("City",typeof(string)); and also dt.Row.Add etc...
static void Main(string[] args)

{

DataTable dt = new DataTable();

dt.Columns.Add("Name", typeof(string));

dt.Columns.Add("Address", typeof(string));

dt.Columns.Add("City", typeof(string));

// List emplist = db.Employees.ToList();

List emplist = new List { new Employee { Address = "Address1", City = "Calicut", Name = "Jaish" }, new Employee { Address = "Address2", City = "Bangalore", Name = "Shailesh" } };

foreach (var emp in emplist)

{

dt.Rows.Add(emp.Name, emp.Address, emp.City); //Input array is longer than the...

}

}
0
Ravikiran Suravarapu7y ago
I am already add colmns at form_load event
0
Salman Beg7y ago
Hi.
First you create the datatable object. After that add columns in it. And then atlast add values in it.
DataTable dt = new DataTable();
dt.Columns.Add("Name",typeof(string));
dt.Columns.Add("Address",typeof(string));
dt.Columns.Add("City",typeof(string));
After this you call the getData().
Thanks.
0
Faisal Pathan7y ago
You need to first add columns to this data table.
0