What is the best way to refresh a datagridview control

[Rob Dob]

Hi,

I have a tabcontrol with several tabs, each tab contains a datagridview
control, and displays data from the same dataset, the only difference being
the "where" clause of the select statement. As the user changes the value
of a particular field the record will move from tab to tab, based upon the
where condition. As each records criteria changes the record will leave one
datagridview control and become part of the other one. Currently I am
accomplishing this by: Using the Fill method of the DataAdapter that is
bound to the two BindingSource's ( the one from where the record was updated
and the other to where the record will be moving to )

Is there a better way to accomplishing this?

thanks

 

[Kevin Spencer]

I don't believe there's any *other* way to do it, if you're using a DataSet,
etc. In any case, I would say yes, it's the best way. The Fill method
doesn't necessarily fetch the entire set of data.

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Hard work is a medication for which
there is no placebo.