An error occur while adding data to datatable using loop

Question

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)); }

Jaish Mathews · 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... } }

Ravikiran Suravarapu · Answer

I am already add colmns at form_load event

Salman Beg · Answer

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.

Faisal Pathan · Answer

You need to first add columns to this data table.

An error occur while adding data to datatable using loop

Answers (4)