What is the difference between a DataTable and a DataView?

Short answer: And columns, and it is used to hold data returned from the database. Key Features: Can hold data from one table. view.RowFilter = "Name = 'Alice'"; view.Sort = "ID DESC"; Summary: DataTable holds data, and DataView provides a dynamic view (filtering, sorting) of the DataTable.

Example code

And columns, and it is used to hold data returned from the database. Key Features: Can hold data from one table. view.RowFilter = "Name = 'Alice'";
view.Sort = "ID DESC"; Summary: DataTable holds data, and DataView provides a dynamic view (filtering, sorting) of the DataTable.

Real-world example (ShopNest)

For large order exports, ShopNest uses SqlDataReader (forward-only, fast). DataSet is heavier and mainly for disconnected editing scenarios.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.