BindingSource.Sort

[Arg81]

I've added a column to the Sort field on one of my BindingSources.

However, when I close the form I get the error
Sort string contains a property that is not in the IBindingList.

huh? I searched on Google but couldn't find much - well specifically no answers to the problem.

My layout:

Form with combobox and grid (parent - child). If I edit the name that is displayed in the combobox, I want the names to appear in ASC order, so if I name something from ZONKY to AGAGAGA then when dropping the list down it's automatically sorted and that row changed position.


Anyone know the answer to the problem, or a better way of doing this?

 

[cjard]

I've had this.. Remove the sort before you close the form; when the underlying list is destroyed, an event fires that it has changed, and the sort routine attempts to sort on a column that no longer exists

 

[Arg81]

I tried

Public sub mnuExit (............

me.bindingsource.sort = nothing
me.close

to no avail, is there another way to remove the sort?

 

[cjard]

bs.RemoveSort ?

 

[Arg81]

ah, I'll give that one a go, let you know if it works or not (will be tomorrow now, it's my favourite time of day right now)

 

[cjard]

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=124508&SiteID=1

 

[Arg81]

yep, that's the one I found which I was setting the sort to nothing. However, I still get the error. Just about to try your suggestion.

ah I just seen to set .sort = Nothing in the Form_Closing event...I was setting it in my close button click command before I call me.close.

I'll have a go at that as well!

 

[Arg81]

I had it right to start with just calling it at the wrong time.

Works perfectly when calling in the Form_Closing event.

Cheers Cjard!

 

[rcarran]

I have a similar problem

When I apply a sort field to a bindingsource, it works the first time. The next time it is applied, I get this error, and keep getting it every time I try to change the sort, even if I try bindingsource.sort = nothing, or bindingsource.sort = "" first.

I apply the sort by using bindingsource.sort = srt.

Any thoughts on this?

 

[cjard]

bindingsource.RemoveSort()

 

[rcarran]

Thanks. That did the trick.