Posted on: 4/1/2015 3:47:05 PM | Views : 793

Hi, I got this error when I tried to export CSV data to SQL server, there are over 800 rows, not sure if it is the reason, but the array should be dynamic. code attached. Please help.

DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[10] { new DataColumn("Type", typeof(string)), new DataColumn("Id",typeof(string)), new DataColumn("Status", typeof(string)), new DataColumn("Priority",typeof(string)), new DataColumn("Severity",typeof(string)), new DataColumn("ResolvedBy",typeof(string)), new DataColumn("BusinessArea",typeof(string)), new DataColumn("Volume",typeof(string)), new DataColumn("Complexity",typeof(string)), new DataColumn(&q ...

Go to the complete details ...