PropertyInfo set value List
display the error in the conversion list
I tried to convert to json and I could not
public class PurchaseBill
{
public DateTime Date { get; set; }
public string Type { get; set; }
public string BillType { get; set; }
public List Listproduct { get; set; }
}
public class PurchaseProduct
{
public Int64 id { get; set; }
public String itemId { get; set; }
public String image { get; set; }
}
code convert MySqlDataReader to the list
public static List DataReaderMapToList(MySqlDataReader dr)
{
List list = new List();
T obj = default(T);
while (dr.Read())
{
obj = Activator.CreateInstance();
foreach (PropertyInfo prop in obj.GetType().GetProperties())
{
if (!object.Equals(dr(prop.Name), DBNull.Value))
{
if (prop.PropertyType.Name == "List`1")
{
var getval = Convert.ChangeType(dr(prop.Name), typeof(string)).ToString();
var objectType = prop.PropertyType.GetGenericArguments().First();
var Object = Activator.CreateInstance(objectType);
var company = JsonConvert.DeserializeObject>(getval);
// error in next line 'can`t convert to list`1 '
prop.SetValue(obj, Convert.ChangeType(dr(prop.Name), prop.PropertyType), null);
}
else
{
prop.SetValue(obj, Convert.ChangeType(dr(prop.Name), prop.PropertyType), null);
}
}
}
list.Add(obj);
}
return list;
}
mysql MySqlCommand cmd = new MySqlCommand(query, connection); //Create a data reader and Execute the command MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list list = DataReaderMapToList(dataReader);
show error debug An exception of type System.InvalidCastException & # 39; it was produced in mscorlib.dll but was not handled in the user code. Additional Information: Invalid casting of "System.String" at & # 39; System.Collections.Generic.List`1 ((test. Purchase_Management + PurchaseProduct, App, Version = 1.0.0.0, Culture = neutral, PublicKeyToken = null)) & # 39 ;.
please i want solution see the error in the conversion list
