Convert DataSet to List

Question

Here is my c  code  Employee objEmp   new Employee    List lt Employee gt  empList   new List lt Employee gt     foreach  DataRow dr in ds Tables 0  Rows        empList Add new Employee   Name   Convert ToString dr  Name     Age   Convert ToInt32 dr  Age            It uses a loop to create a List from a dataset Is there any direct method or shorter method or one line code to convert dataset to list

User · Accepted Answer

Try something like this   var empList   ds Tables 0  AsEnumerable        Select dataRow   gt  new Employee               Name   dataRow Field lt string gt   Name          ToList

User · Answer

Use the code below   using Newtonsoft Json  string JSONString   string Empty  JSONString   JsonConvert SerializeObject ds Tables 0

User · Answer

DataSet ds   new DataSet                    ds   obj getXmlData      get the multiple table in dataset                   Employee objEmp   new Employee       create the object of class Employee                  List lt Employee  gt  empList   new List lt Employee  gt                     int table   Convert ToInt32 ds Tables Count     count the number of table in dataset                 for  int i   1  i  lt  table  i      set the table value in list one by one                                       foreach  DataRow dr in ds Tables i  Rows                                                empList Add new Employee   Title1   Convert ToString dr  Title     Hosting1   Convert ToString dr  Hosting     Startdate1   Convert ToString dr  Startdate     ExpDate1   Convert ToString dr  ExpDate                                                                dataGridView1 DataSource   empList

User · Answer

Here s extension method to convert DataTable to object list       public static class Extensions               public static List lt T gt  ToList lt T gt  this DataTable table  where T   new                         IList lt PropertyInfo gt  properties   typeof T  GetProperties   ToList                List lt T gt  result   new List lt T gt                  foreach  var row in table Rows                                var item   CreateItemFromRow lt T gt   DataRow row  properties                   result Add item                              return result                     private static T CreateItemFromRow lt T gt  DataRow row  IList lt PropertyInfo gt  properties  where T   new                         T item   new T                foreach  var property in properties                                if  property PropertyType    typeof System DayOfWeek                                         DayOfWeek day    DayOfWeek Enum Parse typeof DayOfWeek   row property Name  ToString                         property SetValue item day null                                     else                                       if row property Name     DBNull Value                          property SetValue item  null  null                       else                          property SetValue item  row property Name   null                                                return item                    usage   List lt Employee gt  lst   ds Tables 0  ToList lt Employee gt        itay b CODE EXPLAINED  We first read all the property names from the class T using reflection then we iterate through all the rows in datatable and create new object of T  then we set the properties of the newly created object using reflection   The property values are picked from the row s matching column cell   PS  class property name and table column names must be same

User · Answer

var myData   ds Tables 0  AsEnumerable   Select r   gt  new Employee       Name   r Field lt string gt   Name        Age   r Field lt int gt   Age       var list   myData ToList       For if you really need a List and not IEnumerable

User · Answer

Add a new class named as  Helper  and change the property of the class to  public static   public static class Helper       public static List lt T gt  DataTableToList lt T gt  this DataTable table  where T   class  new                 try                       List lt T gt  list   new List lt T gt                  foreach  var row in table AsEnumerable                                  T obj   new T                     foreach  var prop in obj GetType   GetProperties                                          try                                               PropertyInfo propertyInfo   obj GetType   GetProperty prop Name                           propertyInfo SetValue obj  Convert ChangeType row prop Name   propertyInfo PropertyType   null                                             catch                                               continue                                                           list Add obj                              return list                    catch                       return null                      and access this class in your code behind as like below   DataTable dtt   dsCallList Tables 0    List lt CallAssignment gt  lstCallAssignement   dtt DataTableToList lt CallAssignment gt

User · Answer

Try the above which will run with any list type     public DataTable ListToDataTable lt T gt  IList lt T gt  data                PropertyDescriptorCollection props               TypeDescriptor GetProperties typeof T            DataTable table   new DataTable            for  int i   0  i  lt  props Count  i                          PropertyDescriptor prop   props i               table Columns Add prop Name  prop PropertyType                     object   values   new object props Count           foreach  T item in data                        for  int i   0  i  lt  values Length  i                                  values i    props i  GetValue item                             table Rows Add values                     return table

User · Answer

List lt GSTEntity gst jobwork to mfgmaster gt  ListToGetJwToMfData   new List lt GSTEntity gst jobwork to mfgmaster gt                 DataSet getJwtMF   new DataSet                getJwtMF   objgst jobwork to mfgmaster BLL GetDataJobWorkToMfg AssesseeId  PremiseId   Fyear   MonthId  out webex               if getJwtMF Tables  gst jobwork to mfgmaster      null                                 ListToGetJwToMfData    from master in getJwtMF Tables  gst jobwork to mfgmaster   AsEnumerable   select new GSTEntity gst jobwork to mfgmaster   Partygstin   master Field lt string gt   Partygstin    Partystate                                          master Field lt string gt   Partystate    NatureOfTransaction   master Field lt string gt   NatureOfTransaction    ChallanNo   master Field lt string gt   ChallanNo    ChallanDate master Field lt int gt   ChallanDate     OtherJW ChallanNo master Field lt string gt   OtherJW ChallanNo      OtherJW ChallanDate   master Field lt int gt   OtherJW ChallanDate                        OtherJW GSTIN master Field lt string gt   OtherJW GSTIN                        OtherJW State   master Field lt string gt   OtherJW State                        InvoiceNo   master Field lt string gt   InvoiceNo                        InvoiceDate master Field lt int gt   InvoiceDate                        Description  master Field lt string gt   Description                        UQC  master Field lt string gt   UQC                        qty master Field lt decimal gt   qty                        TaxValue master Field lt decimal gt   TaxValue                        Id master Field lt int gt   Id                                               ToList

User · Answer

Try this    modify the code as per your needs         List lt Employee gt  target   dt AsEnumerable          Select row   gt  new Employee                 Name   row Field lt string  gt  0  GetValueOrDefault            Age  row Field lt int gt  1           ToList

User · Answer

I couldn t get Nitin Sawant s answer to work  but I was able to modify his code to work for me  Essentially I needed to use GetRuntimeFields instead of GetProperties  Here s what I ended up with   public static class Extensions       public static List lt T gt  ToList lt T gt  this DataTable table  where T   new                 IList lt FieldInfo gt  fields   typeof T  GetRuntimeFields   ToList            List lt T gt  result   new List lt T gt             if  row Table Columns Contains field Name                         foreach  var row in table Rows                                var item   CreateItemFromRow lt T gt   DataRow row  fields                   result Add item                                    return result             private static T CreateItemFromRow lt T gt  DataRow row  IList lt FieldInfo gt  fields  where T   new                 T item   new T             foreach  var field in fields                        if  row field Name     DBNull Value                  field SetValue item  null               else                 field SetValue item  row field Name                      return item

User · Answer

Fill the dataset with data from  say a stored proc command  DbDataAdapter adapter   DbProviderFactories GetFactory cmd Connection  CreateDataAdapter    adapter SelectCommand   cmd  DataSet ds   new DataSet    adapter Fill ds     Get The Schema    string s   ds GetXmlSchema      save it to  a file say  datasetSchema xsd  Generate the C  classes for the Schema   at the VS Command Prompt   xsd datasetSchema xsd  c   Now  when you need to convert the DataSet data to classes you can deserialize  the default name given to the generated root class is NewDataSet    public static T Create lt T gt  string xml        XmlSerializer serializer   new XmlSerializer typeof T        using  StringReader reader   new StringReader xml                 T t    T serializer Deserialize reader            reader Close            return t           var xml   ds GetXml    var dataSetObjects   Create lt NewDataSet gt  xml

[c#] Convert DataSet to List

Examples related to c#

Examples related to list

Examples related to ado.net

Examples related to dataset