views:

22

answers:

0

Hi there,

I'm having some trouble with Visual Studio and the creation of DataSets from a database.

Whenever I create a new TableAdapter, the Insert-Methods parameters are, lets just say, fucked up.

The database is a MS Access 2000 Database file. If I create a new TabelAdapter, everything works just fine. I select to create DatabaseDirect Methods and it all goes through without errors.

Then, I look at the statements. All perfectly fine. But then, I check the Insert-Methods parameters and I see this:

Parameter List

All the parameters are set to default Strings with no name. I have to rename and define all of their types over again.

Interesting thing is, this does never affect the last parameter (As you see: Comment is not renamed etc) and it only happens to the Insert-Method. When I check the Update-Method (which also uses the exact same parameters), they are all correctly named and the type also fits the one in the databse.

Parameter list

Is this a known bug? Did I do something wrong when creating the TableAdapter?

You see, it's not that big an issue, I just can't understand why it works with every other method, just not the Insert and it is quite a fuss to rename and retype all of the parameters if you create a table adapter for a table that has significantly more fields than just the 12 I showed you.