How to handle database datas in List<>

dhoni kholi

How to maintaine database datas in List<>

Query = Select * from Table where ID= 'A-1' ;

how to use List<> to maintaine that table data

5 Replies

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

Jignesh Kumar6y ago
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();
0
Laxmidhar Sahoo6y ago
hey in foreach loop retrive trhe data from list and by adaptoper class or command class used for sending the data to data base
0
dhoni kholi6y ago
And How to transfer the List<> data to databse
0
Laxmidhar Sahoo6y ago
1. public class Employee{
2. public string ID {get;set;}
3. public string Name {get;set;}
4. public int Qty {get;set;}
5. public int Price {get;set;}
6. }
8. ds is the dataset that retrive the data fronm the databse
11. Employee objEmp = new Employee();
12. List empList = new List();
13. foreach (DataRow dr in ds.Tables[0].Rows)
14. {
15. empList.Add(new Employee {ID = Convert.ToString(dr["ID"]), Qty = Convert.ToInt32(dr["Qty"]), Price = Convert.ToInt32(dr["Price"]) });
16. }
0

Hi,

Creat a class and add those property inside the class then add that class into a list.

Add the above class into a list.