Object Binding Series - Just Added One More!

Comments

# Mike said on August 2, 2007 3:15 PM:

Beth,

Thanks for the video!  It was exactly what I needed.

# NZ said on August 3, 2007 10:43 AM:

Thanks for the awesome video. Its perfect.

Just a quick question: I followed you video and created my own database with no data. Update to the database and dataadapter works fine in the back end but my Datagridview row disaappears when I click outside the datagridview.

Not sure what I'm missing. Is there a property I need to set beside AllowUserToRows = True

# J.R. said on August 7, 2007 11:51 AM:

In the Sortable tutorial, when I close the form I an exception "Sort string contains a property that is not in the IBindingList".  I tried looking up the exception but received no hits.

# Beth Massi said on August 10, 2007 2:18 PM:

Hi NZ,

Make sure to call Me.Validate and Bindingsource.EndEdit before you call the update on the TableAdapter.

-B

# Beth Massi said on August 10, 2007 2:19 PM:

Hi Jr,

You can work around this bug by resetting the Sorts in the FormClosing event:

   Private Sub Form1_FormClosing(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles Me.FormClosing

       Me.StateBindingSource.Sort = ""

       Me.CitiesBindingSource.Sort = ""

   End Sub

HTH,

-B

# Paul Guernsey Player said on April 29, 2008 5:33 PM:

These videos are great. Simple and understandable. And I didn't have to fly to Toronto or anything!

Congratulations on your 1 year anniversary.

# Paul Guernsey Player said on April 29, 2008 6:32 PM:

A possible improvement?

I added this line to the end of RemoveSortCore():

OnListChanged(New ListChangedEventArgs(ListChangedType.Reset, -1))

I causes the DataGridView to show the new row asterisk as soon as you click the remove sort button. Lets the user that he can now add a new row.

Leave a Comment

Name (required) 

Your URL (optional)

Comments (required) 

Remember Me?

About Beth Massi