Solved

TableAdapter Configuration Wizard Doesn't work properly with foxpro tables

Posted on 2009-04-12
3
371 Views
Last Modified: 2012-06-27
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
0
Comment
Question by:DrProf
  • 2
3 Comments
 
LVL 96

Expert Comment

by:Bob Learned
ID: 24128832
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.
0
 

Author Comment

by:DrProf
ID: 24129330
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?
0
 
LVL 96

Accepted Solution

by:
Bob Learned earned 500 total points
ID: 24129405
Can you attach a .png screen shot of your designer?
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_4334-Minify-and-Concatenate-Your-Scripts-and-Stylesheets.html)…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question