How to convert dataset result to class object

Ashok

5y1.2kVisual Basic .NET

Hi All,

How to convert dataset result columns into c# class object.

Thank You

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
simply convert it to Enumarable and then loop through it using linq
var ContactList= ds.Tables[0].AsEnumerable()
    .Select(dataRow => new Contact()
    {
        Name = dataRow.Field<string>("Name"),
       PhoneNumber= dataRow.Field<int>("PhoneNumber")
    }).ToList();
ANURAG5y ago
public ActionResult ConvertToClassObject() {

return View();
}
[HttpPost]
public ActionResult ConvertToClassObject(string data) {
Root r1 = JsonConvert.DeserializeObject(data);
double get_total_cube = r1.total_cube;
return View();
}
public class Root
{
public double total_cube { get; set; }
}

@{
ViewBag.Title = "ConvertToClassObject";
}
ConvertToClassObject
Ashok5y ago
Hi TQ U its working now but getting some convertion problems could u pls help me out

as my json is

{
"total_cube": 103802.0,
}
using https://json2csharp.com i converted to classes
public class Root {
public double total_cube { get; set; }
}
in c#
var EmployeeList= ds.Tables[0].AsEnumerable()
.Select(dataRow => new Employee()
{
Name = dataRow.Field<string>("Name"), // dataset col 1
total_cube= dataRow.Field<double>("total_cube") //col 2
}).ToList();
how can i get value like this 103802
ANURAG5y ago
string data = JsonConvert.SerializeObject(ds.Tables[0]);
var EmployeeList = JsonConvert.DeserializeObject(data);

public class Employee
{
public string Name {get;set}
public int PhoneNumber {get;set}
}
Sachin Singh5y ago
i have just given you an example
if you datatable contains information about employee then you need to create a class with employee and then take its object
for example
    var EmployeeList= ds.Tables[0].AsEnumerable()
        .Select(dataRow => new Employee()
        {
            Name = dataRow.Field<string>("Name"),  // dataset col 1
           PhoneNumber= dataRow.Field<int>("PhoneNumber")  //col 2
        }).ToList();

public class Employee
{
public string Name {get;set}
public int PhoneNumber {get;set}
}

How to convert dataset result to class object

ConvertToClassObject