473,322 Members | 1,846 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Pls.suggest me a way to do this in .NET 1.1

9
I have a data entry screen which adds a new user to the DB. One part of the screen (one user can have multiple address) has a next and a done button. So if the user clicks 'Next' the address needs to be stored in a detail table which can have many rows per user. But here is the issue:

1. The detail table needs userid as one of the columns , but I will not be knowing the userid until the user presses the submit button to save the entire form to a master table which then would return me a userid. But I need to store multliple address for that user in a diff table.

2. I thought of using datatable/array/arraylist to store the address details in a temporary place and then pushing the rest of the form with the multiple address rows altogether to the database. Not sure which method is better. Or is there a totally different way to do this.

3. If I have to use datatable how would I push the datatable values to a stored procedure.



Pls. suggest me an effective way of doing this



Thanks

GV
Mar 15 '07 #1
1 901
gvi
9
Pls can any one suggest a way to do this?
Mar 15 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: napsters | last post by:
Google uses some javascript for their Google Suggest service (http://www.google.com/webhp?complete=1&hl=en). When you type 'whatever', the script (http://www.google.com/ac.js, or, more readable,...
2
by: anton.aleksandrov | last post by:
Hello, First of all - sorry for may be stupid question, but as I am not a Win* administrator and my field is *nix, I am a little bit stuck with a problem, presented to me by one of the customers....
2
by: srinivas | last post by:
HI, I am a dotnet developer.Ho we can do the functionality exists in google suggest site (http://www.google.com/webhp?complete=1&hl=en).In this site in search text box if we enter some text it...
4
by: Or | last post by:
I am interested in code for creating the dynamic list (not the AJAX data transffer) shown under the text box in google suggest. Just the code for the dynamic list box.
8
by: rAinDeEr | last post by:
Hi, I have a table with the following 2 Fields - one is the description name and the second is its description to be stored in a table. description name description...
3
by: ashutosh | last post by:
I am working for a company and working for printer drivers. Most of the work is in ddk, VC++ and C++, gdi calls. I have studied C++ and ddk and VC++ is new for me. Can anybody suggest me some good...
0
by: wpm | last post by:
I have a combobox with the following properties set in Visual Basic 2005 AutoCompletMode : Suggest AutoCompletSource : Listitems DropDownStyle : DropDown I need to use a keypress event for the...
2
by: Thierry Lam | last post by:
I implemented the autocomplete/suggest for a text input, however the suggest div table does not overlap the other widgets underneath my text input. All it does is create space between my text input...
9
by: RPreetham | last post by:
Hi, I am a new member.I want help in the following... A script that receives an username and checks if the username is available, if not then suggest a new username using as input the username,...
1
by: yang__lee | last post by:
Dear Gurus, I have been programming since 4 years and I am not a computer science literate. I am basically a Mechanical engineer. I am working in GIS field I do c++, C and VC++ programming well...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.