ADO.NET DataView Class

The DataView class in ADO.NET provides a way to represent a customized view of a DataTable. It allows sorting, filtering, and searching within a DataTable without modifying the original data.

Namespace:

using System.Data;

Key Features of `DataView`

Filtering: Filter rows based on conditions using the RowFilter property.
Sorting: Sort data using the Sort property.
Searching: Use Find() to locate rows.
Editing: Modify rows without affecting the original DataTable.
Dynamic Updates: Reflects changes made to the DataTable dynamically.

Creating a DataView

DataTable dt = new DataTable();
dt.Columns.Add("ID", typeof(int));
dt.Columns.Add("Name", typeof(string));
dt.Columns.Add("Age", typeof(int));

dt.Rows.Add(1, "Alice", 25);
dt.Rows.Add(2, "Bob", 30);
dt.Rows.Add(3, "Charlie", 22);

DataView dv = new DataView(dt);

Sorting in DataView

dv.Sort = "Age ASC";  // Sort by Age in ascending order

Filtering in DataView

dv.RowFilter = "Age > 25";  // Show only rows where Age > 25

Finding Rows in DataView

Before using Find(), the Sort property must be set.

dv.Sort = "ID";  
int index = dv.Find(2);  // Find row where ID = 2

if (index != -1)
    Console.WriteLine("Row found: " + dv[index]["Name"]);

Adding New Row

DataRowView newRow = dv.AddNew();
newRow["ID"] = 4;
newRow["Name"] = "David";
newRow["Age"] = 28;
newRow.EndEdit();

When to Use `DataView`?

When you need real-time filtering and sorting without modifying the original DataTable.
When working with large datasets where creating a new DataTable for every filter/sort would be inefficient.
In data-bound controls like GridView, where you want to show a filtered view.

interview

ADO.NET DataView Class

Can you answer this question?

1 Answers

Key Features of DataView

When to Use DataView?

Key Features of `DataView`

When to Use `DataView`?