Back to Devexpress

WorksheetDataBindingCollection.Clear() Method

officefileapi-devexpress-dot-spreadsheet-dot-worksheetdatabindingcollection.md

latest3.9 KB
Original Source

WorksheetDataBindingCollection.Clear() Method

Removes all WorksheetDataBinding objects from the collection.

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
void Clear()
vb
Sub Clear

Remarks

To remove an individual WorksheetDataBinding object from the collection, use the WorksheetDataBindingCollection.Remove or WorksheetDataBindingCollection.RemoveAt method.

The following code snippets (auto-collected from DevExpress Examples) contain references to the Clear() method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

how-to-bind-a-worksheet-to-a-generic-list-or-a-bindinglist-data-source/CS/DataBindingToListExample/Form1.cs#L124

csharp
private void barBtnUnbind_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) {
    spreadsheetControl1.Document.Worksheets[0].DataBindings.Clear();
}

wpf-spreadsheet-bind-a-worksheet-to-generic-list-or-bindinglist-data-source/CS/DataBindingToListExample/MainWindow.xaml.cs#L104

csharp
fishesDataBinding = null;
    spreadsheetControl1.Document.Worksheets[0].DataBindings.Clear();
}

how-to-bind-a-worksheet-to-a-generic-list-or-a-bindinglist-data-source/VB/DataBindingToListExample/Form1.vb#L121

vb
Private Sub barBtnUnbind_ItemClick(ByVal sender As Object, ByVal e As DevExpress.XtraBars.ItemClickEventArgs) Handles barBtnUnbind.ItemClick
    spreadsheetControl1.Document.Worksheets(0).DataBindings.Clear()
End Sub

wpf-spreadsheet-bind-a-worksheet-to-generic-list-or-bindinglist-data-source/VB/DataBindingToListExample/MainWindow.xaml.vb#L104

vb
fishesDataBinding = Nothing
    spreadsheetControl1.Document.Worksheets(0).DataBindings.Clear()
End Sub

See Also

WorksheetDataBindingCollection Interface

WorksheetDataBindingCollection Members

DevExpress.Spreadsheet Namespace