Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Employee objEmp = new Employee();
- List<Employee> empList = new List<Employee>();
- foreach (DataRow dr in ds.Tables[0].Rows)
- {
- empList.Add(new Employee { Name = Convert.ToString(dr["Name"]), Age = Convert.ToInt32(dr["Age"]) });
- }
- var empList = ds.Tables[0].AsEnumerable().Select(dataRow => new Employee{Name = dataRow.Field<string>("Name")}).ToList();
- public static class Extensions
- {
- public static List<T> ToList<T>(this DataTable table) where T : new()
- {
- IList<PropertyInfo> properties = typeof(T).GetProperties().ToList();
- List<T> result = new List<T>();
- foreach (var row in table.Rows)
- {
- var item = CreateItemFromRow<T>((DataRow)row, properties);
- result.Add(item);
- }
- return result;
- }
- private static T CreateItemFromRow<T>(DataRow row, IList<PropertyInfo> 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;
- }
- }
- List<Employee> lst = ds.Tables[0].ToList<Employee>();
- var myData = ds.Tables[0].AsEnumerable().Select(r => new Employee {
- Name = r.Field<string>("Name"),
- Age = r.Field<int>("Age")
- });
- var list = myData.ToList(); // For if you really need a List and not IEnumerable
- List<Employee> target = dt.AsEnumerable()
- .Select(row => new Employee
- {
- Name = row.Field<string?>(0).GetValueOrDefault(),
- Age= row.Field<int>(1)
- }).ToList();
- DbDataAdapter adapter = DbProviderFactories.GetFactory(cmd.Connection).CreateDataAdapter();
- adapter.SelectCommand = cmd;
- DataSet ds = new DataSet();
- adapter.Fill(ds);
- string s = ds.GetXmlSchema();
- xsd datasetSchema.xsd /c
- public static T Create<T>(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<NewDataSet>(xml);
- DataSet ds = new DataSet();
- ds = obj.getXmlData();// get the multiple table in dataset.
- Employee objEmp = new Employee ();// create the object of class Employee
- List<Employee > empList = new List<Employee >();
- int table = Convert.ToInt32(ds.Tables.Count);// count the number of table in dataset
- for (int i = 1; i < 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;
- using Newtonsoft.Json;
- string JSONString = string.Empty;
- JSONString = JsonConvert.SerializeObject(ds.Tables[0]);
- public static class Helper
- {
- public static List<T> DataTableToList<T>(this DataTable table) where T : class, new()
- {
- try
- {
- List<T> list = new List<T>();
- 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;
- }
- }
- }
- DataTable dtt = dsCallList.Tables[0];
- List<CallAssignment> lstCallAssignement = dtt.DataTableToList<CallAssignment>();
- public DataTable ListToDataTable<T>(IList<T> data)
- {
- PropertyDescriptorCollection props =
- TypeDescriptor.GetProperties(typeof(T));
- DataTable table = new DataTable();
- for (int i = 0; i < 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 < values.Length; i++)
- {
- values[i] = props[i].GetValue(item);
- }
- table.Rows.Add(values);
- }
- return table;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement