Understanding data access through comboboxes

[Denaes]

I know sometimes you have to redo databinding at various points to get a combobox to recognize a change... but if the DataTable isn't finding all the new rows, thats annoying.

 

If it's a smallish sample project, you could post it and I could poke around a little. I know it sounds like the database table you're using seems really simple.

[pachjo]

if you can tell me how to post it, or I can zip the project up and email to you?

 

It's doing my nut in! I deleted the stuff and recreated it all to no avail!!

[Denaes]

You can zip it up and post it here with the paperclip button to the right of the Fonts on the a postings formatting bar.

 

You can email it to me at SlinkingFerret at gmail dot com also. Just make sure to remove the .exe files from all the directories

[pachjo]

here is the project with the .exe files removed.

 

when you click on the detailed monthly tab the password is set to 123 for now.

 

the problem is when you try to save a new transaction description that should be reflected in the combo box above.

 

I tried to email it to you also but it bounces back...

Butters.zip

Edited December 30, 2006 by PlausiblyDamp

[pachjo]

Not sure why I should have to do it this way, but if it works dont knock it?

 

I removed all the guff from the design view and coded the lot and it works?

 

I created a tableadapter, commandbuilder and datatable and linked the combobox to this.

 

Now when I do the update it all works a treat ;)

[Denaes]

Sorry, I tried your project and couldn't get it to run. Just something about the way you attached the MDB and ran it through SQL Express. Not something I was familiar with and even when I tried to attach it to SQL Server directly and use a new connection string, exceptions would still be thrown when running the app.

 

But I did take a look and I wasn't familiar with using a TableAdapter as you did on the form (I use them in a public method in the dataset), but your dataset was strongly typed and looked fine.

 

I'm glad you found out what the problem was... well you didn't really find out what the problem was, but I'm glad you found an alternate way of getting it done :)

[pachjo]

Thanks, been away for a few days!!

 

Yes weird that I can't see why I should have to do it this way, but it works perfect so I am happy