Convert Datatable to List Example using LINQ in C#

Convert Datatable to List Example using LINQ in C#

 

In this article, you will how to convert datatable to list example using LINQ in C#

 

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;

public partial class ConvertDatatableToList : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindUserDetails();
        }
    }
    private void BindUserDetails()
    {
        DataTable dt = new DataTable();
        dt.Columns.Add("UserId", typeof(Int32));
        dt.Columns.Add("UserName", typeof(string));
        dt.Columns.Add("RollNo", typeof(string));
        dt.Rows.Add(1, "a", "123");
        dt.Rows.Add(2, "b", "124");
        dt.Rows.Add(3, "c", "125");
        List<UserDetails> list = new List<UserDetails>();

        list = (from DataRow row in dt.Rows

                select new UserDetails()
                {
                    UserId = row["UserId"].ToString(),
                    UserName = row["UserName"].ToString(),
                    Education = row["RollNo"].ToString()
                }).ToList();

        gdvuserdetails.DataSource = list;
        gdvuserdetails.DataBind();
    }
    public class UserDetails
    {
        public string UserId { get; set; }
        public string UserName { get; set; }
        public string RollNo{ get; set; }
    }
}

 

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Convert Datatable to List in c#</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="gdvuserdetails" runat="server">
</asp:GridView>
</div>
</form>
</body>
</html>

2021-10-03