Problem
error mismatch count parameter when convert list to datatable
my list as below
my list output of itemcode as below "1830","950","902","540"
How to convert list of string to datatable
- static List<string> SimilarItems = new List<string>();
- Similar = ConvertToString(dt.Rows[i]["ItemCode"]);
- SimilarItems.Add(Similar);
- dtcollectlistdata = Extensions.ToDataTable(SimilarItems);
- public static DataTable ToDataTable
(List items) - {
- DataTable dataTable = new DataTable(typeof(T).Name);
- //Get all the properties
- PropertyInfo[] Props = typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance);
- foreach (PropertyInfo prop in Props)
- {
- //Setting column names as Property names
- dataTable.Columns.Add(prop.Name);
- }
- foreach (T item in items)
- {
- var values = new object[Props.Length];
- for (int i = 0; i < Props.Length; i++)
- {
- //inserting property values to datatable rows
- values[i] = Props[i].GetValue(item, null);
- }
- dataTable.Rows.Add(values);
- }
- return dataTable;
- }
Sai Kumar KoonaPosted Sep 28, 2018, 8:14 AM