Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Generic data structure
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Environment versions
Environment:
C# 2.0
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01173538
Message ID:
01173579
Views:
7
Linda,

>I need to create a routine that allows the user to select a table that gets read, processed and uploaded to a web server. The table is an export from another system, which is written in Visual FoxPro. I was thinking about using FoxPro tables. I want to use the Mere Mortals business model but I'm not sure exactly how to set up the config files and business objects to accommodate a file structure that is always the same but has a name that continually changes. Is this something that is better handled by XML?

You can easily change the table name to be retrieved by adding a property to your business object. If you are using dynamic SQL, you can reference this property and dynamically build your SELECT statements. For example:
string Command = "SELECT * FROM " + this.TableName;
Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Previous
Reply
Map
View

Click here to load this message in the networking platform