IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
Coder
Search Coder Group:

Advanced
-Collapse +Expand Coder Study Test
PRESTWOODCERTIFIED
-Collapse +Expand Coder Store
PRESTWOODSTORE

Prestwood eMagazine

January Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCoding & OO BoardGeneral .Net Concepts Topic   Print This     

Connecting to Paradox tables using VS.NET

Connecting to Paradox tables using VS.NET in General .Net Concepts topic (part of our Coding & OO group).

Quick Search: Connecting   Paradox   Connecting Paradox   Connecting Paradox tables   using NET  
Moet
-- USA

How do I go about connecting to Paradox tables using VS.NET. I'm new to VS.NET and at the moment feel VB.NET is the way to go. We currently only require to read the Paradox tables (if that makes life easier). We are starting to develop Web sites and initially will access data contained within our legacy Paradox CRM applications.

Regards

Jon

 Posted 15 years ago (Thread Starter)
Comment Quote
About Moet -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #12042, 2 replies
Thread Started 8/9/2007 7:10:27 AM
View Counter=4744
Last Reply Posted 8/13/2007 7:02:27 AM)
Location=-- USA 
Joined=16 years ago   MB Posts=16  
Wes Peterson
Prestwood IT
Prestwood IT office in Citrus Heights, CA

Jon:

Yes, VS .NET is a great way to go these days. And you can certainly use it to get at your Paradox database.

Here is one way (there's probably an easier way - I just didn't find it in exploring this quick test). Incidentally, what follow will seem like a lot of steps. Take heart - you only have to do it once per project:

First, set up an ODBC connection to your database via Control Panel | Administrative Tools | Data Sources (ODBC).

Next, in your VS project, drop a data-bindable control(say a TextBox) on a form.

In that control's Data | Data Bindings property, select Advanced and click the little '...' button. This will bring up the "Formatting and Advanced Editing" dialog.

You'll see a dropdown labeled "Binding" click the drop-down and, click the Add Project Datasource link at the bottom.

That will invoke another wizard. Select the "Database" icon and click next.

In the "Choose Datasource" dialog that pops up, use the "Data Provider" dropdown to select ".NET Data Provider for ODBC," then click "Continue"

On the next dialog, in the "Data Source Specification" radio group, make sure the first radio button is checked ("use user or system data source name"), then select the ODBC connection you created at the beginning, via the dropdown.

Click the "Test Connection" button. It should succeed and, when it does, click OK.

The Data Source Configuration Wizard will then display a tree of your datbase objects. Pick a table and one or more fields, then click OK until you're out of the wizard.

You'll notice, now, that, at the bottom of your design area, there are some new objects: A dataset, a tableadapter, and a binding source. Throughout the rest of yoru project, you can add to these, and connect them up as needed. You don't have to go through all the steps again for every form or control in your project.

You can also "throw away" the TextBox you used to get things rolling, and proceed to build the form to your liking.

In the Solution Explorer, you'll also notice new entries. Between these, and the objects at the bottom of your design area, you now have all the basic connectivity your application needs.

Wes Peterson
Senior Software Engineer
Prestwood IT Solutions
http://www.prestwood.com

 Posted 15 years ago
Comment Quote
About Wes Peterson -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Wes Peterson

Wes Peterson is a Senior Programmer Analyst with Prestwood IT Solutions where he develops custom Windows software and custom websites using .Net and Delphi. When Wes is not coding for clients, he participates in this online community. Prior to his 10-year love-affair with Delphi, he worked with several other tools and databases. Currently he specializes in VS.Net using C# and VB.Net. To Wes, the .NET revolution is as exciting as the birth of Delphi.


Post ID #12043 (Level 1.1)  Reply to 12042
Thread Started 8/11/2007 2:12:40 PM
View Counter=2
Location=Prestwood IT office in Citrus Heights, CA 
Joined=18 years ago   MB Posts=158   KB Posts=163   KB Comments=34   BLOG, Topics=20  
Most Recent Post
Moet
-- USA

Wes,

Many thanks for your reply. I have tried to follow your steps. Creating the ODBC is fine.

When I come to adding the textbox and accessing the Data | Data Bindings Property I do not have an Advanced option only the '...' button which opens a form entitled 'Textbox1 DataBindings'. This form has all the properties of the textbox but no mention of enabling binding or clicking 'Add Project Datasource'

I'm using VS 2003 btw

Regards

Jon

 Posted 15 years ago (Thread Starter)
Comment Quote
About Moet -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #12045 (Level 1.2)  Reply to 12042
Reply Posted 8/13/2007 7:02:27 AM
Location=-- USA 
Joined=16 years ago   MB Posts=16  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1183A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #12042 Counter
4744
Since 4/2/2008
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2022 Prestwood IT Solutions.   [Security & Privacy]