This topic is locked

ASPRunner vs ASPRunner.net

6/24/2007 6:43:33 PM
ASPRunnerPro General questions
S
shelliegary author

Absolute newbie here, I am going to attempt to develop an enterprise level solution for our company. I anticipate using multiple database together and multiple master/detail relationships in tables.
Relationships may be in Tables may the same database or may be in another database.
I read a post that says ASPRunner has a limit of 1 master/detail relationship does the .net version have the same limitation?
Following is a small example of what I am asking.
I will have a database in it will be 2 tables, customer_data which is all customer data and customer_contacts which will be all contacts for a given customer.
IF I wanted to add another table that list lets say open invoices how would you do this in ASPRunner.
Does the .net version allow this to be done easier?
I apoligize if my question is dumb, just trying to start with the right version. I know what I want to be able to do, I want to find software that will allow me to code this myself without having to hire it done.
Thanks
Currently running Server 2003 with .net and ASP, IIS 6.0 and Microsoft SQL Server Express, and Managment Studio.

I am a novice at all of this, but I do have it up and running.
Thanks in Advance
Gary

Sergey Kornilov admin 6/24/2007

Gary,
use ASPRunnerPro. Check your email for more detailed answer.

S
shelliegary author 6/25/2007

Sergy, Email never arrived can you resend please. email address is garyr@accommodatainc.com

L
live2 6/25/2007

Sergy, Email never arrived can you resend please. email address is garyr@accommodatainc.com


I wonder also , Does asprunner pro for asp allows one to many relationships ?

I am also in the same position.

I have customer tbl then Contact table, then Invoice table, then order table.

Now i want to display just all on one page.

On top Records from Customer table

then in the bottom of page i want to display data from 4 tables like in one table i want to populate last 5 orders, then last 5 invoices from invoice table for this customer, then 5 contacts from employees tbl for this customer, then last 5 payments from payment tbl for thi customer etc.

Is this what we call one to many table relations ? How this can be done ? as of now i am only able to see one main table then only one table i can display at the bottom as i could only join one relationship. How this can be done, Could you mail me also pls ?

And if this is not done in asprunner pro then is it possibe in .net version ?

Sergey Kornilov admin 6/25/2007

ASPRunnerPro supports unlimited number of one-to-one, one-to-many and many-to-many relationships.

To create a relationship proceed to the Datasource tables tab and create as many relationships as you need.
To display an additional info on any page you can use Events.

Check this sample for more info:

http://www.xlinesoft.com/asprunner/docs/sh...omer_orders.htm