Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Basics
| Search | Today's Posts | Mark Forums Read
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old May 10th, 2007, 08:58 PM
Registered User
 
Join Date: May 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Declarative arguments passing between DetailsViews

Hi,
I have one SQL table Order and N SQL tables of OrderType shown in simplified form as follows:

CREATE TABLE Order
(
            order_id INTEGER IDENTITY(1,1)
            Name VARCHAR(32)
)



CREATE TABLE OrderType1
(
            Id INTEGER IDENTITY(1,1)
           order_id INTEGER REFERENCES Order(order_id)
Data1 VARCHAR(32)
            …..
)

CREATE TABLE OrderType2
(
            Id INTEGER IDENTITY(1,1)
           order_id INTEGER REFERENCES Order(order_id)
Data2 VARCHAR(32)
            …..
)

CREATE TABLE OrderTypeN..

On the aspx page I have DetailsViewOrder, and corresponding DetailsViewOrderTypeX displayed on 2 steps of the wizard.

Right now I have "manual" databinding -- I intercept "On_Next" of wizard , create OrderTableAdapter, call Insert(name) on it with argument retrieved from the Name text field, get new order_id back, then create corresponding OrderTableAdapterX adapter and call Insert(order_id, dataX)

Is there a way to do it in declarative way where somehow an "insert" would be forced on DetailsViewOrder which would return a new order_id back, which would force an "insert" on DetailsViewOrderTypeX and order_id would be passed from one DetailsViewOrder to another DetailsViewOrderTypeX?

I am interested in this approach because I'd like to reuse DetailsViewOrderTypeX in "readonly" view state as UserControls on some other pages and re-laying out UI for all these N DetailsViewOrderType seems like a duplication of effort. Additionally declarative way would allow me to have far less code without a need to manually create table adapters.
Thanks!

-- Andrey
  #2 (permalink)  
Old May 10th, 2007, 09:24 PM
Friend of Wrox
Points: 6,664, Level: 34
Points: 6,664, Level: 34 Points: 6,664, Level: 34 Points: 6,664, Level: 34
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2004
Location: Sydney, NSW, Australia.
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

This is the classic ASP area of the forum, looks like you should post this in the .net area

Wind is your friend
Matt


Similar Threads
Thread Thread Starter Forum Replies Last Post
Passing multiple arguments to function zarikiane XSLT 2 July 18th, 2006 09:35 AM
passing arguments to executables DaveG BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 0 May 30th, 2006 03:26 PM
Problem passing multiple arguments to php script method PHP How-To 0 February 8th, 2006 09:03 AM
Passing arguments to contructor of dynamically... jacob ASP.NET 1.0 and 1.1 Professional 3 December 2nd, 2005 02:43 PM
passing/getting arguments from ShellExecute TazMania23 Visual C++ 0 May 21st, 2004 12:14 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.