Facing issues on converting list to datatable c#

Question

I have below code and facing issues on converting list to datatable. This line gives error. DataTable studentTable = Students;

public DataTable GetDetails()
        {

            List<Student> Students = new List<Student>(){
                new Student() { Name = "Jack", Age = 1, StudentId = 100 },
                new Student() { Name = "Smith", Age = 2, StudentId = 101 },   
                       new Student() { Name = "Smit", Age = 3, StudentId = 102 },};
            DataTable studentTable = Students;// This line gives error.
        }

        public class Student
        {
            public string Name;
            public int Age;
            public int StudentId;
        }

Please correct me.

Type `List` cannot be assigned to the type `DataTable`. Pretty simple error, I suppose. — AgentFire, Apr 26 '14 at 07:16
C# is a strongly type language. You cannot assign variables to a instance of different type. That's pretty obvious... — kevin, Apr 26 '14 at 07:17
possible duplicate of [Convert generic List/Enumerable to DataTable?](http://stackoverflow.com/questions/564366/convert-generic-list-enumerable-to-datatable) — Palak Bhansali, Apr 26 '14 at 07:19

score 0 · Answer 1 · edited May 23 '17 at 12:11

Please try this. You must convert it first. C# doesn't allow you to assign different type of value to each other.

 public DataTable GetDetails()
    {

        List<Student> Students = new List<Student>(){
            new Student() { Name = "Jack", Age = 1, StudentId = 100 },
            new Student() { Name = "Smith", Age = 2, StudentId = 101 },   
                   new Student() { Name = "Smit", Age = 3, StudentId = 102 },};
        DataTable studentTable = new DataTable();// Changed
       using(var reader = ObjectReader.Create(Students)) 
          {
            studentTable.Load(reader);
          }
       return studentTable; //need it?
    }

Sorry if it doesn't work see more Here.

score 0 · Accepted Answer · answered Apr 26 '14 at 07:27

Instead of making lists, you should make columns and then add rows.

Studenttable.columns.add("Name", typeof(string));
Studenttable.columns.add("Agg", typeof(int));
Studenttable.columns.add("StudentID", typeof(int));

Studenttable.Rows.add("Jack",1,100);

Facing issues on converting list to datatable c#

2 Answers2

Linked