OK, my humblest apologies for feeding you incorrect information. I was thinking I had done it this way before but I mustn't have because, as you're seeing, it just doesn't work like that. I've been using business objects myself lately so I haven't bound any DataTables directly for a while. Again, sorry for wasting your time.
Even with BindingSources, if you want more than one view of a DataTable then you need to create at least one DataView explicitly. I'd suggest using the DefaultView if you only want one view but creating all views explicitly if you want more than one. You should keep the BindingSources though. Just change this:to this:vb.net Code:
.DataSource = myDataTableand it will work properly.vb.net Code:
.DataSource = New DataView(myDataTable)




Reply With Quote