What is the difference between dataview and datatable?

by

When you want to run a query and show the subset of data in a control, a DataView could help you. That’s just one example, look at the MSDN example for DataView, that explains where you should use DataViews with DataTables…

DataTable

A datatable is an in-memory representation of a single database table. You can think of it as having columns and rows in the same way. The DataTable is a central object in the ADO.NET library. Other objects that use the DataTable include the DataSet and the DataView.

Look at MSDN The DataTable class for more details.

DataView

A dataview is a view on a datatable, a bit like a sql view. It allows you to filter and sort the rows – often for binding to a windows form control.

Additionally, a DataView can be customized to present a subset of data from the DataTable. This capability allows you to have two controls bound to the same DataTable, but showing different versions of the data. For example, one control may be bound to a DataView showing all of the rows in the table, while a second may be configured to display only the rows that have been deleted from the DataTable. The DataTable also has a DefaultView property which returns the default DataView for the table.

Look at MSDN DataView class for more details.

More Related Contents:

  1. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  2. MetadataException: Unable to load the specified metadata resource
  3. Get output parameter value in ADO.NET
  4. When should “SqlDbType” and “size” be used when adding SqlCommand Parameters?
  5. SQLite Database Locked exception
  6. Is it necessary to manually close and dispose of SqlDataReader?
  7. Populate data table from data reader
  8. When using Trusted_Connection=true and SQL Server authentication, will this affect performance?
  9. Difference with Parameters.Add and Parameters.AddWithValue
  10. SqlConnection SqlCommand SqlDataReader IDisposable
  11. Exception when AddWithValue parameter is NULL
  12. Calling Oracle stored procedure from C#?
  13. Insert into C# with SQLCommand
  14. MultipleActiveResultSets=True or multiple connections?
  15. How to pass a table-value parameter
  16. How DataReader works?
  17. How to keep single SQL Server connection instance open for multiple request in C#?
  18. DataTable equivalent in Java [duplicate]
  19. How do I re-write a SQL query as a parameterized query?
  20. Check if a SQL table exists
  21. Reading a date using DataReader
  22. What ‘length’ parameter should I pass to SqlDataReader.GetBytes()
  23. How do I connect to a SQL database from C#?
  24. .net connection pooling
  25. Do we have transactions in MS-Access?
  26. How can I remove accents on a string? [duplicate]
  27. How to grant full permission to a file created by my application for ALL users?
  28. Entity Framework – Cannot convert lambda expression to type ‘string’ because it is not a delegate type
  29. Internal .NET Framework Data Provider error 1025
  30. Validating user input / Give .NET controls status OK or NOK

Leave a Comment