Solved

TableAdapter Configuration Wizard Doesn't work properly with foxpro tables

Posted on 2009-04-12
3
364 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Summary Displaying images in RichTextBox is a common requirement with limited solutions available. Pasting through clipboard or embedding into RTF content only support static images.  This article describes how to insert Windows control objects int…
This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

863 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

Need Help in Real-Time?

Connect with top rated Experts

28 Experts available now in Live!

Get 1:1 Help Now