How to convert dataset result to class object

Question

Hi All, How to convert dataset result columns into c# class object. Thank You

Sachin Singh · 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();

Sachin Singh · Answer

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 } }

ANURAG · Answer

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 Submit function send_data() { debugger; var d1 = { "total_cube": 103802.0, }; var d1_str = JSON.stringify(d1); document.getElementById("data").value = d1_str; }

Ashok · Answer

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

ANURAG · Answer

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} }

How to convert dataset result to class object

Answers (5)