Surpress Save Changes? on a TableAdapter

[Michael Palecek]

I have a datagridview that I need to refesh on demand, either from a filter or just to get the latest data out of the database.

Whenever I run the refresh I get a messagebox asking to Save Changes?

How do I get rid of it?

[arie]

Youor question is not very detailed...

I assume you have TableAdapter bound to DataGridView as in here: http://msdn.microsoft.com/en-us/library/fbk67b6z.aspx?

Maybe you have tableadapter.Up date() method called somwhere where it shouldn't be? If it's in datagridview_Ro wsAdded or datagridview_Ro wsRemoved event method then it will be called every time you refresh or filter datagridview, not only when you manually modify it.