How to clear a bindingsource without deleting from database

[desanti]

Hello ! I'm using vb.net 2017 and EF 6. I have a bindingsource and also datagrid that is bound to this bindingsource. I need a way to clear all the items from bindingsource to empty it , but without deleting from database. I've tried

Bindingsource1.Datasource=Nothing.

But , after calling this , the datagrid still have all the bindingsource items.

[Lost User]

You need to call the Refresh method to repaint the grid.

[desanti]

I've tried also Bindingsource.Clear

Bindingsource.Clear

Bindingsource.Clear , this is working , but does this remove also from database ( if I call savechanges for example ?)

[Lost User]

You should not use savechanges unless you want the database updated.

[desanti]

ok , but Bindingsource.clear only remove items from bindingsource or also mark them for deletion from database ?

[Lost User]

Sorry, I don't know the answer. You could study the documentation, or write a simple test program to try it out.

[Lost User]

.DataSource = Nothing

The Master said, 'Am I indeed possessed of knowledge? I am not knowing. But if a mean person, who appears quite empty-like, ask anything of me, I set it forth from one end to the other, and exhaust it.' ― Confucian Analects