# Working with Data Views

## Content

## Adding a Data View

1. Open the form in the designer.
2. Hover over the connection in the tool window and click ![image](https://cdn.mescius.io/document-site-files/images/d955dec4-5c03-497a-875e-1da749bee0ab/image-20261016.d61102.png?width=20)**Add Data View**. The Query Builder opens.
3. Compose the query. See [Query Builder](/componentone/docs/services/online-datawizard/features/query-builder).
4. Enter a Data View name.
5. Click **Save Data View**.

Expand the connection in the tool window to display the new Data View.
![C1 DataWizard - GIF showing adding a Data View ](https://cdn.mescius.io/document-site-files/images/d955dec4-5c03-497a-875e-1da749bee0ab/AddingDataView-20261016.24898d.gif?width=800)

>type=note
> **Note**: A Data View can be added only while the designer form is open. The Data View name cannot be changed after creation.

## Editing a Data View

Hover over a Data View in the tool window and click ![image](https://cdn.mescius.io/document-site-files/images/d955dec4-5c03-497a-875e-1da749bee0ab/image-20261016.062015.png?width=20) **Edit Data View**. The Query Builder opens with the existing query. Modify the query, then click **Save Data View**. The Data View name cannot be changed.
![C1 DataWizard - Editing a data view ](https://cdn.mescius.io/document-site-files/images/d955dec4-5c03-497a-875e-1da749bee0ab/EditingDataView-20261016.7374c7.gif?width=800)

## Viewing Data View Details

Hover over a Data View in the tool window and click ![image](https://cdn.mescius.io/document-site-files/images/d955dec4-5c03-497a-875e-1da749bee0ab/image-20261016.9e66a3.png?width=20) **View Details**. The details page displays the Data View identifier, type, filter, and bound controls. A control can be unbound from this page. See [Unbinding a Data View](/componentone/docs/services/online-datawizard/features/binding-data-views-to-control).
![C1 DataWizard - GIF showing viewing Data View details by clicking on view details icon](https://cdn.mescius.io/document-site-files/images/d955dec4-5c03-497a-875e-1da749bee0ab/ViewingDataView-20261016.3462f9.gif?width=800)

## Removing a Data View

Hover over a Data View in the tool window and click **![image](https://cdn.mescius.io/document-site-files/images/d955dec4-5c03-497a-875e-1da749bee0ab/image-20261016.0dc2ae.png?width=20) Remove Data View**.
![C1 DataWizard - GIF showing removing a Data View by clicking on Remove Data View icon](https://cdn.mescius.io/document-site-files/images/d955dec4-5c03-497a-875e-1da749bee0ab/RemovingDataView-20261016.910aa2.gif?width=800)

>type=note
> **Note:** A Data View cannot be removed while it is bound to a control. Unbind it from every control first.

## Previewing Data and Queries

**Result Preview** in the Query Builder provides two views:

* ![image](https://cdn.mescius.io/document-site-files/images/d955dec4-5c03-497a-875e-1da749bee0ab/image-20261016.ce2f3b.png?width=20) **Grid View:** Displays the data returned by the query.
* **![image](https://cdn.mescius.io/document-site-files/images/d955dec4-5c03-497a-875e-1da749bee0ab/image-20261016.98da62.png?width=20) Code View:** Displays the generated query. For Entity Framework connections, it displays a LINQ query.

Click the corresponding icon button to switch views. The preview displays up to 30 rows and includes the total row count. Click **Refresh** to update the preview.
The total row count appears at the right of the **Conditions** and **Result Preview** headers. The preview updates automatically when a condition value changes.
![](https://cdn.mescius.io/document-site-files/images/d955dec4-5c03-497a-875e-1da749bee0ab/Preivew-20261016.f372cc.gif?width=800)

>type=note
> **Note**: The preview is read-only. Modify the query through the Query Builder.