TableAdapter Configuration Wizard Doesn't work properly with foxpro tables

I am trying to create a dataset with two foxpro tables the tableadapter configuration wizard creates on select and insert commands, but doesn't create update or delete commands, also if I change the insert command I will loose all the parameters and then I have to redifine all the parameters again manaually.
I am using Visual Studio 2008 and my project in VB.NET.
any suggestion or help.
thx in advance
Who is Participating?
Bob LearnedConnect With a Mentor Commented:
Can you attach a .png screen shot of your designer?
Bob LearnedCommented:
That is usually a problem when the wizard cannot determine primary key columns, which are needed to generate the update, insert, and delete commands.  Maybe that is a problem with how the wizard works with FoxPro.
DrProfAuthor Commented:
thx for your comments, actually I agree with you about the disability to determine the primary key, but what about changing the insert commands, the wizard unable to determine the parameters types and names, what do you think the cause of that?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.