How to handle database datas in List

Question

How to maintaine database datas in List ID Name Qty Price A-1 Apple 2 25 A-1 Orange 5 50 A-1 Mango 2 10 Query = Select * from Table where ID= 'A-1' ; how to use List to maintaine that table data

Jignesh Kumar · Answer

Hey, Please try blow code, public class Product { public string Id { get ; set ;} public string Name { get ; set ;} public int Price { get ; set ;} public int Qty { get ; set ;} } DbContext entities = new DbContext(); //Database connection string for Linq to DB List Product> productList = new List Product> (); productList = (from product in entities.Products select product).Take(4) .Select(x => new Product() {Id = x.Id ,Name = x.Name ,Price = x.Price ,Qty = x.Qty }).ToList();

Laxmidhar Sahoo · Answer

hey in foreach loop retrive trhe data from list and by adaptoper class or command class used for sending the data to data base

dhoni kholi · Answer

And How to transfer the List data to databse

Laxmidhar Sahoo · Answer

public class Employee{ public string ID { get ; set ;} public string Name { get ; set ;} public int Qty { get ; set ;} public int Price { get ; set ;} } ds is the dataset that retrive the data fronm the databse Employee objEmp = new Employee(); List empList = new List (); foreach (DataRow dr in ds.Tables[0].Rows) { empList.Add( new Employee {ID = Convert.ToString(dr[ "ID" ]), Qty = Convert.ToInt32(dr[ "Qty" ]), Price = Convert.ToInt32(dr[ "Price" ]) }); }

Rajeesh Menoth · Answer

Hi, Creat a class and add those property inside the class then add that class into a list. public class Info { public int ID { get ; set ;} public string Name { get ; set ;} public int Qty { get ; set ;} public int Price { get ; set ;} } Add the above class into a list.

ID	Name	Qty	Price
A-1	Apple	2	25
A-1	Orange	5	50
A-1	Mango	2	10

How to handle database datas in List<>